Reader Level:
Articles

Inserting Form Data Into DataBase Using Stored Procedure In ASP.NET C#

By Vithal Wadje on December 31, 2012
In this article I will explain how to insert the form data into the database using a stored procedure
  • 3
  • 0
  • 82845
Download Files:
 

Background

I have decided to write this article by considering the requirements of students and beginners that often ask how to insert the form data using a Stored Procedure. So due to this I have explained this requirement with basics so they can get an idea of how to submit form data using a Stored Procedure.

So let us start the walkthrough.

Create a table "Student" as in the following:


studentTable.png

Create a Stored Procedure named "Studenentry" as:

Create procedure Studententry
(
@fname Varchar (50),
@Mname varchar (50),
@Lname Varchar (50)

)
as
begin
Insert into Student (Fname,MName,Lastname) values (@fname,@Mname,@Lname)
End

In the above Stored Procedure I have declared three variables, they are @fname, @Mname and @Lname to store Fname, MName and Lastname into the table.

Now create the one sample application "StudentEntry" as:
  1. Start - All Programs - Microsoft Visual Studio 2010.
  2. File - New Website - C# - Empty website (to avoid adding a master page).
  3. Give the web site a name such as  "StudentEntry" or another as you wish  and specify the location.
  4. Then right-click on Solution Explorer - Add New Item - Default.aspx page.
  5. Drag and drop one button, three textboxes and one label on the <form> section of the Default aspx page.
Then switch to the design view; the <form> section of the Default aspx page source will look as in the following:

<form id="form1"runat="server">
    <div>
First Name  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
Middle Name<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
Last Name <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
        <asp:ButtonID="Button1"runat="server"Text="Add"onclick="Button1_Click" />
    </div>
</form>
 
Now double-click on "Button" then write the following code:

protected void Btnsave_Click(object sender, EventArgs e)
{
      connection();
      query = "Studententry";         //Stored Procedure name 
      SqlCommand com = new SqlCommand(query, con);  //creating  SqlCommand  object
      com.CommandType = CommandType.StoredProcedure;  //here we declaring command type as stored Procedure

       /* adding paramerters to 
 SqlCommand below *\
       com.Parameters.AddWithValue("@FName",TextBox1.Text.ToString());        //first Name
       com.Parameters.AddWithValue("@Mname ", TextBox2.Text.ToString());     //middle Name
       com.Parameters.AddWithValue("@LName ",TextBox3.Text.ToString());       //Last Name
       com.ExecuteNonQuery();                     //executing the sqlcommand
       Label1.Visible = true;
       Label1.Text = "Records are Submitted Successfully";
}

In the above code, I have explained detail in each line through comments what each line is used for what purpose, I hope you understand it.

Now run the application; the starting page should be as follows:

demo.png

Now insert some data and click on the submit button, the following message will be shown after successful submission of the data:

Final.png

Note 
  • For detailed code please download the zip file attached above.
  • Don't forget to Perform changes into the Web.config file according to your Server location. 
Summary

Now we have learned how to submit the form data using a Stored Procedure into the database. I hope this article is useful for all students and beginners. If you have any suggestion related to this article please contact me.

Vithal Wadje

Vithal Wadje Currently working as Senior Software Engineer on Microsoft Technologies with BFSI Domain at one of the top MNCs in Mumbai.  He has experience in handling large financial projects involved Microsoft te... Read more

COMMENT USING

Trending up