C#

public void InsertPlannedMaterialMasterRequest(int id, string requestDocument, string requestDescription, string requestType, string hodApproval, int companyCode, string hodRemarks, string det_Description, string name, int qty, string code)
    {
        string query = "INSERT INTO MasterRequest (ID,Req_Document,Req_Description,ReqType,HODApproval,CompanyCode,HODRemarks) VALUES (@ID,@Req_Document,@Req_Description,@ReqType,@HODApproval,@CompanyCode,@HODRemarks)";
        
        SqlConnection con = new SqlConnection(constr);
        SqlCommand com = new SqlCommand(query, con);
        com.Parameters.Add("@ID", SqlDbType.Int).Value = id;
        com.Parameters.Add("@Req_Document", SqlDbType.NVarChar).Value = requestDocument;
        com.Parameters.Add("@Req_Description", SqlDbType.NVarChar).Value = requestDescription;
        com.Parameters.Add("@ReqType", SqlDbType.NVarChar).Value = requestType;
        com.Parameters.Add("@HODApproval", SqlDbType.NVarChar).Value = hodApproval;
        com.Parameters.Add("@CompanyCode", SqlDbType.Int).Value = companyCode;
        com.Parameters.Add("@HODRemarks", SqlDbType.NVarChar).Value = hodRemarks;

        con.Open();
        com.ExecuteNonQuery();
        con.Close();


        string query2 = "INSERT INTO DetailRequest (ID,Req_Document,Description,Approval) VALUES (@ID,@Req_Document,@Description,@Approval)";
        SqlConnection con2 = new SqlConnection(constr);
        SqlCommand com2 = new SqlCommand(query2, con2);
        com2.Parameters.Add("@ID", SqlDbType.Int).Value = id;
        com2.Parameters.Add("@Req_Document", SqlDbType.NVarChar).Value = requestDocument;
        com2.Parameters.Add("@Description", SqlDbType.NVarChar).Value = det_Description;
        //com2.Parameters.Add("@Quantity", SqlDbType.Int).Value = qty;
        //com2.Parameters.Add("@UOM", SqlDbType.NVarChar).Value = unitOfMeasure;
        com2.Parameters.Add("@Approval", SqlDbType.NVarChar).Value = hodApproval;

        con2.Open();
        com2.ExecuteNonQuery();
        con2.Close();

        string query3 = "INSERT INTO ITEMS (ID,Code,Name,Quantity) VALUES (@ID,@Code,@Name,@Quantity)";
        SqlConnection con3 = new SqlConnection(constr);
        SqlCommand com3 = new SqlCommand(query3, con3);
        com3.Parameters.Add("@ID", SqlDbType.Int).Value = id;
        com3.Parameters.Add("@Code", SqlDbType.NVarChar).Value = code;
        com3.Parameters.Add("@Name", SqlDbType.NVarChar).Value = name;
        com3.Parameters.Add("@Quantity", SqlDbType.Int).Value = qty;

        con3.Open();
        com3.ExecuteNonQuery();
        con3.Close();


    }

//Now following is the code I am using in my PlannedmterialRequest.aspx.cs

protected void Button1_Click(object sender, EventArgs e)
    {
        MasterRequest_DAL helper = new MasterRequest_DAL();

        PlannedMaterialRequest pnd = new PlannedMaterialRequest();
        ItemsHandling itm = new ItemsHandling();

        string[] labelName = new string[100];
        string[] coder = new string[100];
        string[] quantity = new string[100];

        
        if (TextBox6.Text != "0")//if quantity entered into Capacitor textBox
        {
            labelName[1] = itm.Code(0).ToString();
            labelName[2] = TextBox6.Text;
            helper.InsertPlannedMaterialMasterRequest(Convert.ToInt32(TextBox1.Text), TextBox2.Text, TextBox4.Text, DropDownList6.SelectedValue, DropDownList2.SelectedValue, Convert.ToInt32(TextBox11.Text), TextBox12.Text, TextBox13.Text, Label8.Text, Convert.ToInt32(TextBox6.Text), labelName[1]);

          
        }

        if (TextBox12.Text != "0")//if quantity entered into Wires textBox
        {
            //labelName(0) needs to be commented
            //labelName[0] = pnd.Label8.Text.ToString();
            labelName[1] = itm.Code(1).ToString();
            labelName[2] = TextBox12.Text;
            helper.InsertPlannedMaterialMasterRequest(Convert.ToInt32(TextBox1.Text), TextBox2.Text, TextBox4.Text, DropDownList6.SelectedValue, DropDownList2.SelectedValue, Convert.ToInt32(TextBox11.Text), TextBox12.Text, TextBox13.Text, Label12.Text, Convert.ToInt32(TextBox8.Text), labelName[1]);



        }
}