stored procedure

Question

haii i am a beginner in asp.net....i want to change my work by using stored procedore..i want to enter the empidnamedept to database by using stored procedure....

Vijaya Kadiyala · Answer

Hi The Best thing would be creating one stored procedure for all insert update delete actions on the table. You can you al these differernt actions in one single procedure with in Different BEGIN block and having different transactions for each of these. Thanks -- Vj http://dotnetvj.blogspot.com

John Penn · Answer

You can combine inserts deletes updates and selects any way you want to within a stored procedure. You can use the IF and BEGIN/END statements to create blocks of SQL code that are to be executed conditionally. You can also make use of temporary tables to hold data that is only needed during the execution of the procedure (and temp tables can be returned as resultsets as well).

ganga nair · Answer

thank u.........i tried its working but i want to know one thing also...can i use more than one action ina procedure..means....i tried one stored procedure for insert...in tha same application i want to deleteupdateselect also......for that i have to write separate procedure or same procedure for all those actions...

Manish Dwivedi · Answer

Hi Ganga For calling the stored procedure  u have to pass the parameter name and value. here I am writing the code which shows the way of calling the SP. // create and open a connection object conn = new SqlConnection( Define Connection here. ); conn.Open(); // create a command object identifying // the stored procedure name InsertEmpRecord SqlCommand cmd = new SqlCommand( InsertEmpRecord  conn); // set the command object so it knows // to execute a stored procedure cmd.CommandType = CommandType .StoredProcedure; // add parameter to command which // will be passed to the stored procedure cmd.Parameters.Add( new SqlParameter( @EmpID  Pass the value here )); cmd.Parameters.Add( new SqlParameter( @Name  Pass the value here )); cmd.Parameters.Add( new SqlParameter( @Deptt  Pass the value here )); cmd.ExecuteNonQuery(); by this way u can call the sp. Simply write the Stored Procedure. and use this code. Happy Coding!!