Insert Single Value With Stored Procedure ASP.NET C#

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

<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)
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.

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);

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


- 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


Recent Comments

adam 05/10/2015 14:35
In response to Integrating Web API with ASP.NET Razor Web Pages
Can you re-open this web api project in webmatrix, once you've added web api? Basically I'm looking...

nish 24/09/2015 18:48
In response to Managing Checkboxes And Radios In ASP.NET Razor Web Pages
Very Interresting stuff! it really helped me to send an int value by checking a checkbox!...

Uğur Dinç 24/09/2015 16:45
In response to Scheduled Tasks In ASP.NET With Quartz.Net
Simplest and best explanation on Quartz.NET. Thank you!...

woo 24/09/2015 15:34
In response to Implementing Google's EU End User Consent Policy
Is there any way for the banner to appear only to EU visitors? I am referring to the jQuery code...

Justin 24/09/2015 11:10
In response to Using ASP.NET Identity with Razor Web Pages
Hi Mike, Very helpful article again, thanks. One query that I'm trying to work out is how you to...

hb 23/09/2015 23:12
In response to WebMatrix Opens Wrong Version Of Visual Studio
Mike - I got this working when I went decided to look at the community edition of VS2015 and tried I...

Muneer 22/09/2015 14:55
In response to Scheduled Tasks In ASP.NET With Quartz.Net
I have an error with these two is not recognizing the commands. am i missing any library? I am web...

David 22/09/2015 13:57
In response to iTextSharp - Working with Fonts
Mike your articles about itextsharp are excellent, really helpful and well written. In the future...

Peter 22/09/2015 06:39
In response to Accessing Your Model's Data from a Controller
Thanks.Got it. ...

sreedhar kandukuri 21/09/2015 14:05
In response to Integrating Web API with ASP.NET Razor Web Pages
Nice Overview...