مشكلتى عند الضغط على زر إضافة

السلام عليكــم ورحمـة الله وبركاتــه ،،

هذا الكود

using System;

using System.Collections.Generic;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Configuration;

public partial class Controls_Common : System.Web.UI.UserControl

{

protected void Page_Load(object sender, EventArgs e)

{

TextBox20.Text = DateTime.Today.Day.ToString() + "/" + DateTime.Today.Month.ToString() + "/" + DateTime.Today.Year.ToString();

}

protected void Button2_Click(object sender, EventArgs e)

{

DropDownList2.Items.Clear();

SqlConnection cnn = new SqlConnection();

cnn.ConnectionString = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString;

string cmdtext = "Select Sub_Region_Name,Sub_Region_Id From Sub_Regions Where Area_Id = @id";

SqlCommand cmd = new SqlCommand(cmdtext, cnn);

cmd.Parameters.Add(new SqlParameter("@id", DropDownList3.SelectedValue.ToString()));

cnn.Open();

SqlDataReader rd = cmd.ExecuteReader();

while (rd.Read())

{

DropDownList2.Items.Add(rd["Sub_Region_Name"].ToString());

}

cnn.Close();

}

protected void Button1_Click(object sender, EventArgs e)

{

int a = 0;

int b = 0;

if (RadioButton1.Checked == true)

{

a = 1;

}

if (RadioButton3.Checked == true)

{

b = 1;

}

SqlConnection cnn = new SqlConnection();

cnn.ConnectionString = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString;

string cmdcheck = "select count(*) from participants where Common_Name = @name";

SqlCommand check = new SqlCommand(cmdcheck, cnn);

check.Parameters.Add(new SqlParameter("@name", TextBox1.Text));

cnn.Open();

int checkresult = (int)check.ExecuteScalar();

cnn.Close();

if (checkresult == 0)

{

string getid = "select Sub_Region_Id From Sub_Regions Where Sub_Region_Name = @name";

SqlCommand get = new SqlCommand(getid, cnn);

get.Parameters.Add(new SqlParameter("@name", DropDownList2.Text));

int res2 = 0;

cnn.Open();

SqlDataReader rd = get.ExecuteReader();

while (rd.Read())

{

res2 = Convert.ToInt32(rd["Sub_Region_Id"].ToString());

}

rd.Close();

string regtext = "select Id From Subscription_typies Where Subscription_type=@type";

SqlCommand reg = new SqlCommand(regtext, cnn);

reg.Parameters.Add(new SqlParameter("@type", DropDownList1.Text));

int id = 0;

SqlDataReader rdd = reg.ExecuteReader();

while (rdd.Read())

{

id = Convert.ToInt32(rdd["Id"].ToString());

}

rdd.Close();

int year = Convert.ToInt32(TextBox37.Text);

int month = Convert.ToInt32(TextBox36.Text);

int day = Convert.ToInt32(TextBox35.Text);

string d = day + "/" + month + "/" + year;

string cmdtext = "INSERT INTO Participants (Date_insert,Common_Name,Area_Id,Sub_Region_Id,Account_Number" +

",Registration_No,Installed_Capacity,Pregnancy_Of_The_Contractual_joint" +

",Monthly_Consumption,Annual_Consumption,Consumption_Both_within_And_Outside

_The_Peak_Time" +

",Common_Tariff_Changing,Common_tariff_Cutting,Meter_Type_Id,Date_Of_Visit,A

ddress,Name_Of_The_Person_Responsible" +

",Mobile_No,Phone_No,Fax_No,Website,Email,Notes) Values (@dateinsert,@name,@area_id,@sr_id" +

",@accountnumber,@reg_no,@ins_ccity,@potcj,@monthconsum,@annulconsum,@cbwao" +

",@c_t_c,@common_tariff_cutting,@meter_type_id,@datevisit,@address,@nameofth

eperson,@mobile" +

",@phone,@fax,@website,@email,@note)";

int dr = Convert.ToInt32(DropDownList3.SelectedValue);

int meterid = Convert.ToInt32(DropDownList4.SelectedValue);

SqlCommand cmd = new SqlCommand(cmdtext, cnn);

cmd.Parameters.Add(new SqlParameter("@dateinsert", TextBox20.Text));

cmd.Parameters.Add(new SqlParameter("@name", TextBox1.Text));

cmd.Parameters.Add(new SqlParameter("@area_id", dr));

cmd.Parameters.Add(new SqlParameter("@sr_id", res2));

cmd.Parameters.Add(new SqlParameter("@reg_no", id));

cmd.Parameters.Add(new SqlParameter("@accountnumber", TextBox2.Text));

/////////////////////////////////////////////////////////////////////////////

cmd.Parameters.Add(new SqlParameter("@ins_ccity", TextBox5.Text));

cmd.Parameters.Add(new SqlParameter("@potcj", TextBox4.Text));

//cmd.Parameters.Add(new SqlParameter("@no_plant_nutrition", TextBox20.Text));

cmd.Parameters.Add(new SqlParameter("@monthconsum", TextBox6.Text));

cmd.Parameters.Add(new SqlParameter("@annulconsum", TextBox7.Text));

////////////////////////////////////////////////////////////////////////////

cmd.Parameters.Add(new SqlParameter("@nameoftheperson", TextBox14.Text));

cmd.Parameters.Add(new SqlParameter("@cbwao", TextBox8.Text));

cmd.Parameters.Add(new SqlParameter("@c_t_c", a));

cmd.Parameters.Add(new SqlParameter("@common_tariff_cutting", B));

//cmd.Parameters.Add(new SqlParameter("@no_station", TextBox20.Text));

cmd.Parameters.Add(new SqlParameter("@meter_type_id", meterid));

cmd.Parameters.Add(new SqlParameter("@datevisit", d));

cmd.Parameters.Add(new SqlParameter("@address", TextBox12.Text));

cmd.Parameters.Add(new SqlParameter("@phone", TextBox16.Text));

cmd.Parameters.Add(new SqlParameter("@fax", TextBox33.Text));

cmd.Parameters.Add(new SqlParameter("@website", TextBox17.Text));

cmd.Parameters.Add(new SqlParameter("@email", TextBox18.Text));

cmd.Parameters.Add(new SqlParameter("@note", TextBox19.Text));

cmd.Parameters.Add(new SqlParameter("@mobile", TextBox15.Text));

cmd.ExecuteNonQuery();

cnn.Close();

Label2.Visible = true;

Label3.Visible = false;

}

else

{

Label3.Visible = true;

Label2.Visible = false;

}

}

}