求助 button2 触发后 Text.Box写不进数据库

weixin_41786000 2018-03-14 06:25:28



using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using SUI.dcode;





namespace SUI

{

    public partial class shangjyouhuiquan : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!Page.IsPostBack)

            {

                sel.Items.Add("10");

                sel.Items.Add("20");

                sel.Items.Add("30");

                sel.Items.Add("50");

                sel.Items.Add("100");

                sel.Items.Add("200");

                sel.Items.Add("300");

                sel.Items.Add("500");

                sel.AutoPostBack = true;

            }

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            TextBox1.Text= Guid.NewGuid().ToString();

        }



        protected void sel_SelectedIndexChanged(object sender, EventArgs e)

        {

            TextBox2.Text = sel.SelectedItem.Text;

        }



        protected void Button2_Click(object sender, EventArgs e)

        {

            int i;

            data mydb = new data();

            string mysql,sn ="";



            mysql = "SELECT * FROM youhuiquan WHERE 优惠券码 ='" +TextBox1.Text+ "'";

            i = mydb.Rownum(mysql, "youhuiquan", ref sn);

            if (i > 0)  

                Response.Redirect("");

            else

            {

                mysql="INSERT INTO youhuiquan （优惠券码,金额）VALUES('"

                    +TextBox1.Text+ "','"

                    +TextBox2.Text+ "',)";

               

            }

            bool success = mydb.ExecuteNonQuery(mysql);

            Response.Redirect("WebForm1.aspx?=info=欢迎使用本系统&Success=" + success+"");

        }

    }

}