using(SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ToString())) { SqlCommand cmd = new SqlCommand("proc_Customers", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cname = new SqlParameter("@CustomerName", txtcname.Text); SqlParameter clocation = new SqlParameter("@CustomerLocation", txtclocation.Text); SqlParameter cgender = new SqlParameter("@Gender", ddlgender.Text); SqlParameter caddress = new SqlParameter("@CustomerAddress", txtcaddress.Text); SqlParameter cphonenumber = new SqlParameter("@PhoneNumber",txtphonenumber.Text); SqlParameter cemailid=new SqlParameter("@EmailId",txtemailid.Text); cmd.Parameters.Add(cname); cmd.Parameters.Add(clocation); cmd.Parameters.Add(cgender); cmd.Parameters.Add(caddress); cmd.Parameters.Add(cphonenumber); cmd.Parameters.Add(cemailid); con.Open(); cmd.ExecuteNonQuery();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)