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) ENDaspx.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
©Mike Brind 2006 - 2012. All rights reserved.