public partial class _Default : System.Web.UI.Page { string str = ConfigurationManager.AppSettings["constr"].ToString(); protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { insertdeatails(); } // string message = string.Empty; protected void insertdeatails() { SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "USP_ONSHOP"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter name = new SqlParameter("@NAME", SqlDbType.VarChar, 50); SqlParameter age = new SqlParameter("@AGE", SqlDbType.Int); SqlParameter phoneno = new SqlParameter("@PHONE_NO", SqlDbType.VarChar, 50); SqlParameter interestefields = new SqlParameter("@INTERESTED_FIELDS", SqlDbType.VarChar, 50); SqlParameter regid = new SqlParameter("@REG_ID", SqlDbType.Int); regid.Direction = ParameterDirection.Output; SqlParameter success = new SqlParameter("@SUCCESS_PARAMETER", SqlDbType.Int); success.Direction = ParameterDirection.Output; SqlParameter error = new SqlParameter("@ERROR_DESC", SqlDbType.VarChar, 50); error.Direction = ParameterDirection.Output; message = (string)cmd.Parameters["@ERROR_DESC"].Value; name.Value = TextBox1.Text.Trim(); age.Value = Convert.ToInt32(TextBox2.Text); phoneno.Value =TextBox3.Text; interestefields.Value = CheckBoxList1.SelectedValue; cmd.Parameters.Add(name); cmd.Parameters.Add(age); cmd.Parameters.Add(phoneno); cmd.Parameters.Add(interestefields); string insertfields = ""; for (int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items[i].Selected) { insertfields += CheckBoxList1.Items[i].Value + ","; } } insertfields = insertfields.TrimEnd(','); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { con.Close(); con.Dispose(); } //cmd.Parameters.Add(new SqlParameter("@NAME", TextBox1.Text.ToString())); //cmd.Parameters.Add(new SqlParameter("@AGE", TextBox2.Text.ToString())); //cmd.Parameters.Add(new SqlParameter("@PHONE_NO", TextBox3.Text.ToString())); //cmd.Parameters.Add(new SqlParameter("@INTERESTED_FIELDS", CheckBoxList1.SelectedValue.ToString())); //string insertfileds = ""; //for (int i = 0; i < CheckBoxList1.Items.Count; i++) //{ // if (CheckBoxList1.Items[i].Selected) // { // insertfileds += CheckBoxList1.Items[i].Value + ","; // } //} //insertfileds = insertfileds.TrimEnd(','); //cmd.Connection = con; //cmd.ExecuteNonQuery(); //foreach (ListItem item in CheckBoxList1.Items) //{ // string sql = string.Format("insert into CUSTEMER_DETAILS (INTERESTED_FIELDS) values ('{0}')", item.Selected); // SqlCommand cmd1 = new SqlCommand(sql, con); // cmd1.CommandType = System.Data.CommandType.Text; // cmd1.ExecuteNonQuery(); //} //cmd.Parameters.Add(new SqlParameter("@REG_ID", SqlDbType.Int)); //cmd.Parameters["@REG_ID"].Direction = ParameterDirection.Output; //cmd.Parameters.Add(new SqlParameter("@SUCCESS_PARAMETER", SqlDbType.Int)); //cmd.Parameters["@SUCCESS_PARAMETER"].Direction = ParameterDirection.Output; //cmd.Parameters.Add("@ERROR_DESC", SqlDbType.Char, 50); //cmd.Parameters["@ERROR_DESC"].Direction = ParameterDirection.Output; //message = (string)cmd.Parameters["@ERROR_DESC"].Value; } protected void Button2_Click1(object sender, EventArgs e) { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; foreach (ListItem list in CheckBoxList1.Items) { list.Selected = false; } }
cmd.Connection = con;
using (SqlCommand Cmd = new SqlCommand("USP_ONSHOP ", Cn)) { }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)