Blogs I Like

Brad Wilson [MSFT]
Dave Ward [MVP]
David Hayden [MVP]
Ian Cooper [MVP]
Imar Spaanjaars [MVP]
Jimmy Bogard [MVP]
Kazi Manzur Rashid
Phil Haack [MSFT]
Rick Anderson [MSFT]
Scott Guthrie [MSFT]
Rick Strahl [MVP]
Steve Sanderson [MVP]

Microsoft Most Valuable Professional ASP/ASP.NET

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.

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

Date Posted: 03 April 2007 14:16
Last Updated: 12 May 2007 23:12
Posted by: Mikesdotnetting
Total Views to date: 5926
Printer Friendly Version

Comments

18 January 2010 21:07 from 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".

Add your comment

If you have any comments to make about this article, please use this form to do so. Make sure that your comment relates specifically to the article above. More general comments can be posted through the form on the Contact page.

Please note, all comments are moderated, and some may not be published. The kind of things that will ensure your comment is deleted without ever seeing the light of day are as follows:

Not relevant to the article
Gratuitous links to your own site or product
Anything abusive or libellous
Spam
Anything in a language I don't understand (English is best)

I do not pass email addresses on to spammers, so a valid one will assist me in responding to you personally if required.

Your name:

Your email address:

Your comments:

0 + 2

Mikesdotnetting

Tags

Blogs I Like

Insert Single Value With Stored Procedure ASP.NET C#

Comments