ASP.NET

protected void Button2_Click(object sender, EventArgs e)
    {
        OleDbDataReader dr = null;
        string str = "Select Count(Specification)From ProductSpecification";
        OleDbCommand cmd = new OleDbCommand(str, conn);
        conn.Open();
        string Count = cmd.ExecuteScalar().ToString();
        int count = Convert.ToInt32(Count);
        conn.Close();
        str = "Select * From ProductSpecification";
        cmd = new OleDbCommand(str, conn);
        conn.Open();
       // dr = cmd.ExecuteReader();
        //DataTable dt = new DataTable();
       // dt.Load(dr);
        
        for (int i = 1; i <= count; i++)
        {
            txt = new TextBox[count]; 
            //string s=dr["Specification"].ToString();
            //TextBox text = (TextBox)Panel2.FindControl(txt[i].ID);
            ///TextBox txtctrl = (TextBox)Panel2.FindControl("txt" + i.ToString());
            txt[i] = new TextBox(); 
            txt[i].ID = "txt" + i.ToString();
            string s1 = txt[i].Text;
            string s2 = "Insert Into ProductSpecification(Value)Values('"+s1+"')";
            cmd = new OleDbCommand(s2, conn);
            cmd.ExecuteNonQuery();
           
        }
        conn.Close();
    }

private void bounddropdownlist()
    {
        string query = "select CouponName,CouponTypeID from CouponType";
        DAL Helper = new DAL();
        Helper.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
        ds = new DataSet();
        ds = Helper.ExecuteDataSet(CommandType.Text, query, null);
        ddlCType.DataValueField = "CouponTypeID";
        ddlCType.DataTextField = "CouponName";
        ddlCType.DataSource = ds;
        ddlCType.DataBind();
    }

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        try
        {
            ErrorMessage.Text = "";
        
string query = "insert into CouponTransaction(CouponTypeID,TransactionDate,TransactionTypeID,Description,CafeMenu,SerialStart,SerialEnd,Price,

TotalSale)values('" + ddlCType.SelectedValue.ToString() + "','"+ TxtbxDate.Text 

+"','"+ddlTtype .SelectedValue .ToString ()+"','"+TxtDes .Text +"',

'"+ddlMenu .SelectedValue+"','"+txtSFrom .Text +"','"+TxtEnd .Text +"','"+Txtprice .Text  +"','"+TxtSale .Text +"')";

DAL helper = new DAL();
            helper.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
            int result = helper.ExecuteNonQuery(CommandType.Text, query, null);
            if (result == 1)
                ErrorMessage.Text = "Records inserted successfully";
            else
                ErrorMessage.Text = "Records could not be inserted";
            cnx.Close();
        }
        catch (Exception ex)
        {
            ErrorMessage.Text = ex.Message;
        }
    }