Stored Procedure

Question

Sir/Madam I would like learn about stored procedures.send me some links for clear reference. With Regards, Gomathi.P

Gomathi Palaniswamy · Answer

This is the code to call sql stored procedure from from front end SqlCommand oc = new SqlCommand("create1", connection.con); oc.CommandType = CommandType.StoredProcedure; oc.Parameters.AddWithValue("@Date", DateTime.Now.ToString()); oc.Parameters.AddWithValue("@Branch", branch.Text); oc.Parameters.AddWithValue("@Name", Name.Text); oc.Parameters.AddWithValue("@DateofBirth", dob.Text); oc.Parameters.AddWithValue("@Qualification", TextBox3.Text); if (Home.Checked == true) { str = "home"; } if (land.Checked == true) { str = str + "land"; } if (Vehicle.Checked == true) { str = str + "vehicle"; } oc.Parameters.AddWithValue("@PropertyDetails", str.ToString()); oc.Parameters.AddWithValue("@Email", Email.Text); oc.Parameters.AddWithValue("@CurrentCity", currentcity.Text); oc.Parameters.AddWithValue("@Years", years.Text); oc.Parameters.AddWithValue("@Address", address.Text); oc.Parameters.AddWithValue("@Occupation", occupation.Text); oc.Parameters.AddWithValue("@MonthlyIncome", monthlyincome.Text); oc.Parameters.AddWithValue("@AccountType", Accounttype.Text); oc.Parameters.AddWithValue("@ContactNo", contactno.Text); byte[] imagedata = new byte[FileUpload1.PostedFile.ContentLength]; oc.Parameters.AddWithValue("@Photo", imagedata); oc.Parameters.AddWithValue("@Legalguadian", legalgau.Text); oc.Parameters.AddWithValue("@Guadianaddress", gaddress.Text); oc.ExecuteNonQuery(); With Regards, Gomathi.P

Gomathi Palaniswamy · Answer

Can anybody help to write coding in front end using c# ??

Naeem Khan · Answer

hello friend, What is stored procedure? A program running in the database that can take complex actions based on the inputs you send it. Using a stored procedure is faster than doing the same work on a client, because the program runs right inside the database server . Stored procedures are nomally written in PL/SQL or Java. this is the definition of Store Procedure i m also sending you web site links... http://databases.about.com/od/sqlserver/a/storedprocedure.htm