Insert Command Stored Procedure

Insert Command Stored Procedure

Create Stored Procedure in SQL SERVER,

Create Table in DB and Go to server Explorer And Right Click on Store Procedure

Code For Create Insert Command In Save Data

ALTER PROCEDURE  dbo.StoredProcedure1

    /*

    (

    @parameter1 int
= 5,

    @parameter2
datatype OUTPUT

    )

    */(

   

 @eid varchar(20) ,

 @ename varchar(20) )

   

AS

begin

INSERT INTO employee(eid,ename)VALUES(@eid,@ename)

    /* SET NOCOUNT
ON */

   

    END

Now Code IN .cs file On SAVE Button in web Page.

using System;

using
System.Collections;

using
System.Configuration;

using
System.Data;

using
System.Linq;

using
System.Web;

using
System.Web.Security;

using
System.Web.UI;

using
System.Web.UI.HtmlControls;

using
System.Web.UI.WebControls;

using
System.Web.UI.WebControls.WebParts;

using
System.Xml.Linq;

using
System.Data.SqlClient;   //
add ado classes for SQL server

public partial class Default3 : System.Web.UI.Page

{

    // Create
Connection and Command Object

    SqlConnection
cn = new SqlConnection();

    SqlCommand
cmd = new SqlCommand();

        

//
Now Define SQL Parameters for Insert data using Stored Procedure

    SqlParameter e1 = new SqlParameter();

    SqlParameter e2 = new SqlParameter();

    SqlParameter e3 = new SqlParameter();

    SqlParameter e4 = new SqlParameter();

  

    protected void Page_Load(object sender, EventArgs e)

    {

    
// Noe Open Connetion Using Connection Object

   
cn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated
Security=True;User Instance=True";

        cn.Open();

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        cmd = new SqlCommand("StoredProcedure1",cn);

// "StoredProcedure1"- is name of stored procedur created in sql server.

        cmd.CommandType = CommandType.StoredProcedure;

        e1.ParameterName= "@eid"; 
 // Parameters namegiven in store procedure (@eid,@ename)

        e1.Direction = ParameterDirection.Input; // For Input data

        e1.Value = TextBox1.Text;    
                    // Value read from TextBox1  control from page

        e1.SqlDbType = SqlDbType.VarChar;  
                                                              // Type of Parameter store value

        e1.Size = 20;                
                   //Size of Parameter

cmd.Parameters.Add(e1); // Add parameter using ADO.NET

        e2.ParameterName = "@ename";

        cmd.CommandType = CommandType.StoredProcedure;

        e2.ParameterName = "@ename";

        e2.Direction = ParameterDirection.Input;

        e2.Value =TextBox2.Text;

        e2.SqlDbType = SqlDbType.VarChar; 

        e2.Size = 20;   

       

    
cmd.Parameters.Add(e2);

    
cmd.ExecuteNonQuery();

        Response.Write("Record insert successfully");

    }