public void IDExists(string Product_ID) { bool Product_ID_Inuse = false; using (SqlConnection con = new SqlConnection("Persist Security Info=False;User ID=sa;Password=admin;Initial Catalog=Product_Catalogue;Data Source=192.168.0.153")) { SqlCommand cmd = new SqlCommand("spIDExists", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Product_ID", Product_ID); //cmd.Parameters.Add(new SqlParameter() //{ // ParameterName = @Product_ID, // Value=Product_ID //}); con.Open(); Product_ID_Inuse = Convert.ToBoolean(cmd.ExecuteScalar()); } CheckProduct chk = new CheckProduct(); chk.Product_ID = Product_ID; chk.Product_ID_Inuse = Product_ID_Inuse; JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(chk)); }
public void IDExists(string Product_ID) { bool Product_ID_Inuse = false; using (SqlConnection con = new SqlConnection("Persist Security Info=False;User ID=sa;Password=admin;Initial Catalog=Product_Catalogue;Data Source=192.168.0.153")) { SqlCommand cmd = new SqlCommand("spIDExists", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Product_ID", Product_ID); //cmd.Parameters.Add(new SqlParameter() //{ // ParameterName = @Product_ID, // Value=Product_ID //}); con.Open(); Product_ID_Inuse = Convert.ToBoolean(cmd.ExecuteScalar()); } CheckProduct chk = new CheckProduct(); chk.Product_ID = Product_ID; chk.Product_ID_Inuse = Product_ID_Inuse; JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(chk)); }