Trigger Insert Update Delete

Create TRIGGER trgTransactions on dbo.test1 AFTER INSERT, DELETE, UPDATE
AS
BEGIN
DECLARE @DeletedId INT, @InsertId int


SELECT @InsertId = Test from inserted
SELECT @DeletedId= Test from Deleted




IF (@InsertId > 0 AND isnull(@DeletedId,'') = '')

BEGIN
--DELETE FROM TomsWebDBNProdV2_clone_test.dbo.test1 where Test = @InsertId

INSERT INTO TomsWebDBNProdV2_clone_test.dbo.test1
SELECT * FROM INSERTED

END

-- insert
IF (@InsertId > 0 AND @DeletedId > 0)
BEGIN
DELETE FROM TomsWebDBNProdV2_clone_test.dbo.test1 where Test = @InsertId

INSERT INTO TomsWebDBNProdV2_clone_test.dbo.test1
SELECT * FROM INSERTED

END

-- update
IF( isnull(@InsertId,'') = '' AND @DeletedId > 0)

-- delete
DELETE FROM TomsWebDBNProdV2_clone_test.dbo.test1 where Test = @DeletedId


END

Execute Normal Query

Using Oledb
Execute Normal Query
Step 1: Establishing Connection

OleDbConnection OCon=new OleDbConnection(StrCon);

//StrCon is a connection String

Step 2: Execute Normal Query

OCon.Open();

OleDbCommand OCmd = new OleDbCommand(strQry, OCon);

//StrQry is Query

OCmd.ExecuteNonQuery();

OCon.Close();

Using Sqlclient
Execute Normal Query
Step 1: Establishing Connection

SqlConnection OCon=new SqlConnection(StrCon);

//StrCon is a connection String

Step 2: Execute Normal Query

OCon.Open();

SqlCommand OCmd = new SqlCommand(strQry, OCon);

//StrQry is Query

OCmd.ExecuteNonQuery();

OCon.Close();