Stored Procedure

    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

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

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