how to creat store procedure

Regards,
Raja, USA

Regards,
Raja, USA

CREATE PROCEDURE Proc_Insertdata

	@name varchar(50),

        @address varchar(50)

AS

BEGIN

insert into table1 (Name,Address)values(@name,@address)	



END

button_click

{

            SqlConnection sqlconn = new SqlConnection("Data Source=xxx;Initial Catalog=xyz;Integrated Security=True");

               SqlCommand cmdIns = new SqlCommand();

                cmdIns.Connection = sqlconn;

                cmdIns.CommandType = CommandType.Text;

                cmdIns.CommandText = "exec proc_inserdata 'abc','pune' ";

                cmdIns.ExecuteNonQuery();

}

Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/

Thank you for posting at Dotnetfunda
[Administrator]