how to do insert update delete in single stored procedure

Question

how to do insert update delete in single stored procedure with in asp .net?

Rafnas T P · Answer

ALTER proc [dbo].[csp_Org] ( @mode nvarchar(20), @id int = null , @ on nvarchar(100)= null , @oaddr nvarchar(250)= null , --your parameters ) as begin if @mode = 'Insert' begin insert into tbl_Name values (@id,@ on ,@oaddr) end if @mode = 'Update' begin update tbl_Name set _Name=@ on ,_Address=@oaddr where _id=@id end if @mode = 'Delete' begin delete from tbl_Name where _id=@id end end

Nitin Sontakke · Answer

If you plan to do all three operation on a single table by passing a parameter, I strongly discourage you from doing so. You are better of writing three separate stored procedures.

Rafnas T P · Answer

if you want to do all in one short then write all statement together in one plase and call this procedure. if you want to do seperatly insert, update, delete but in one stored procedure then create proocedure add all parameters and add one one more parameter like @mode then you can pass this @mode from asp.net page what action you want to do example @mode,"Insert" or @mode,"update". and check it in procedure using if condition in stored procedure if @mode='Insert' begin insert into table values end else if @mode='update' begin Update table set ... end like this you can do it

Bryian Tan · Answer

Here are some example http://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx http://www.c-sharpcorner.com/blogs/insert-delete-and-update-using-stored-procedure-in-asp-net1

how to do insert update delete in single stored procedure

Answers (4)