[DataObjectMethod(DataObjectMethodType.Insert)] public static void InsertClass(string name, string code) { String strConnString = ConfigurationManager.ConnectionStrings["BookstoreAppConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(strConnString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "InsClass"; cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@code", code); //cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = txtname.Text.Trim(); //cmd.Parameters.Add("@code", SqlDbType.VarChar).Value = txtcode.Text.Trim(); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); //lblMessage.Text = "Record inserted successfully"; con.Close(); }
ALTER procedure [dbo].[InsClass] ( @name varchar(50), @code varchar(50) ) as begin set nocount on; insert into Class(ClassName, ClassCode) values(@name, @code) end
InsertClass
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)