Insert Single Value With Stored Procedure ASP.NET C#

4 (37 votes)

Code for calling stored procedure in the Code-Behind to insert a single value from a text box.

aspx:
<asp:Label ID="Label1" runat="server" Visible="false"></asp:Label><br />
Add Category: <asp:TextBox ID="txtCategory" runat="server"></asp:TextBox><br />
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
Stored Procedure:
CREATE PROCEDURE [dbo].[AddCategory] 
  @Category nvarchar(20)
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  INSERT INTO CATEGORIES (Category) VALUES (@Category)
END
aspx.cs:
protected void Button1_Click(object sender, EventArgs e)
{
string ArticleType = txtArticleType.Text;
string connectionString = Utils.GetConnString();
        
using (SqlConnection conn = new SqlConnection(connectionString))
  {	
			
   using (SqlCommand cmd = new SqlCommand("AddArticleType", conn))
    {
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@ArticleType", ArticleType);
    conn.Open();
    cmd.ExecuteNonQuery();
    }
  }
}

You might also like...

Date Posted:
Last Updated:
Posted by:
Total Views to date: 41363

3 Comments

- Taner Ozdas

You have a typo erron in your code example.

using (SqlCommand cmd = new SqlCommand("AddArticleType", conn))


should be ;

using (SqlCommand cmd = new SqlCommand("AddCategory", conn))

because you create stored procedure with a name "AddCategory".

- Tabish Sagheer

This code is very Helpfull for me. Thanks for given this code.

- nirali

nice

Recent Comments

Gfw 03/02/2017 09:48
In response to Free SSL Certificates On IIS With LetsEncrypt
I have used WinSimple for about the last 9 months - works great. One thing that you want to make of...

Ted Driver 02/02/2017 13:24
In response to Free SSL Certificates On IIS With LetsEncrypt
This looks great is you have command line access to your web server - what about those of us on Is...

Carl T. 06/11/2016 05:43
In response to Server.MapPath Equivalent in ASP.NET Core
Very succinct and easy to follow. Worked perfectly the first time for me. Thanks!!...

Manoj Kulkarni 04/11/2016 05:47
In response to Entity Framework Core DbContext Updated
Great post....

Sivu 19/10/2016 08:21
In response to Entity Framework Core TrackGraph For Disconnected Data
Oh that's very very very nice ! Thanks for the write up Mike, much appreciated for the taking the to...

Mark 12/10/2016 16:42
In response to ASP.NET Web Pages vNext or Razor Pages
Although "Web Pages" was removed from the roadmap, has it just been renamed to "Razor Pages"?...

Satyabrata 12/10/2016 09:20
In response to Entity Framework Core TrackGraph For Disconnected Data
Nice article. Please write more articles featuring ASP.Net web pages. Thank you...

Julian 26/09/2016 14:27
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Fantastic, many thanks Mike! Had got half way down this road before finding your article - saved...

Abolfazl Roshanzamir 14/09/2016 05:36
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Nice article. Thanke you so much ....

cyrus 02/09/2016 15:12
In response to ASP.NET Web Pages vNext or Razor Pages
I've got some news. As Damian stated in this link: https://github.com/aspnet/Mvc/issues/5208 “We...