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