Loading

Use One Store Procedure For All Event

Manath Pathana

Hi dear
Can help me one problem.
I want to use one store procedure for use all event in page,
Add Update Delete and when page load. when i use one event one store procedure
it have a lot of store procedure that make i boring when i want to edit on the page.
so how to do to use one store procedure?
i wish you have good Idear for me.
and wish you have good everythink.
thank advance
bye

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manath Pathana17y ago
Thank for reply
i know how do it.
but how i write in c# or vb.net
?
Swetha B17y ago
Create PROCEDURE [procedurename] @Allyourdeclarations @action(Add or delete passthin from your application) AS BEGIN SET NOCOUNT ON; if(@action = ADD) BEGIN IF(NOT EXISTS( select 1 from table where you condition ) ) BEGIN INSERT INTO your table( ColoumnNames = VALUES ) END ELSE BEGIN UPDATE Table SET ColoumnName1 = Value1 ColoumnName2 = Value2 . . END END ELSE BEGIN DELETE FROM Table WHERE you Condition END END