Comments by Babu Kumar (Top 22 by date)

Hi,,
Check the code
string[] strarray = strvalue.Split('/');
instead of this u need to use
string[] strarray = strvalue.Split(',');
because you want to split with comma right?

If anything further required, Let us know.

Regards,
Babu.K

Hi,
User the Update Like below sample query

CREATE TRIGGER [dbo].[UpdateLogRecords]
ON [dbo].[employee] FOR UPDATE
AS
BEGIN
UPDATE employeedummy SET first_name=(SELECT inserted.first_name FROM inserted)
WHERE employeedummy.id in (SELECT inserted.ID from inserted)
END

Regards,
Babu.K

Hi,
Can you post your sample code, so that we can understand how u created table and how we can get data from the table.

Regards,
Babu.K

Hi,
I Couldn't understand your problem clearly, Kindly give more info to understand your problem.

Regards,
Babu.K

Welcome Ram, Rate my answer if you like :)

Use IN Opereator instead of EQUAL Operator.
i've mentioned sample query in the below post. Check that.

Hi Use like this,

ALTER TRIGGER DeleteLogRecords
ON employee FOR DELETE
AS
BEGIN
DELETE FROM employeedummy WHERE employeedummy.id in (SELECT deleted.ID from deleted)
END

like that for update.

Regards,
Babu.K

Can you post the trigger and your table structure of both the table

CREATE TRIGGER DeleteLogRecords
ON mainlog FOR DELETE
AS
BEGIN
DELETE FROM users2.dbo.sparelog WHERE users2.dbo.sparelog.ID=deleted.ID
END

Here "users2.dbo.sparelog.ID=deleted.ID" ID is some common column value to be mapped for delelet.

CREATE TRIGGER UpdateLogRecords
ON mainlog FOR UPDATE
AS
BEGIN
UPDATE users2.dbo.sparelog SET users2.dbo.sparelog.Column1=Inserted.Column1 WHERE users2.dbo.sparelog.ID=Inserted.ID
END

Check the above Query.

Regards,
Babu.K

Hi Srinivas,
Kindly give us a brief of your problem, from this question we couldn't understand.

Regards,
Babu.K

no u cant write trigger inside stored proc.

hi check this link it'll be usefull
http://www.codeproject.com/Articles/33995/Getting-Started-with-WCF

Hi,

A trigger is a special kind of a store procedure that executes in response to certain action on the table like insert/delete/update. Once u create a trigger it will trigger automatically once the DML (Insert/Delete/Update) execute. Check the below link.

http://www.codeproject.com/Articles/25600/Triggers-Sql-Server

Regards,
Babu.K

you are welcome. Rate my answer if you like it. :)

Regards,
Babu.K

You Can do like that,

Create PROCEDURE MasterInsertUpdateDelete
(
@id INTEGER,
@first_name VARCHAR(10),
@last_name VARCHAR(10),
@salary DECIMAL(10,2),
@city VARCHAR(20),
@StatementType nvarchar(20) = ''
)

AS


BEGIN
BEGIN TRAN

IF @StatementType = 'Insert'
BEGIN
insert into employee (id,first_name,last_name,salary,city) values( @id, @first_name, @last_name, @salary, @city)
END

IF @StatementType = 'Select'
BEGIN
select * from employee
END

IF @StatementType = 'Update'
BEGIN
UPDATE employee SET
First_name = @first_name, last_name = @last_name, salary = @salary,
city = @city
WHERE id = @id
END

else IF @StatementType = 'Delete'
BEGIN
DELETE FROM employee WHERE id = @id
END
IF @@ERROR <> 0
ROLLBACK TRAN
ELSE COMMIT TRAN
END

Regards,
Babu.K

Welcome kalyan. Rate my answer if you like it.

Regards,
Babu.K

First u need to create a rdlc report file using that datasource. Then u need to assign the dataset to the reort document. then load the report in the reportviewer.

http://www.codeproject.com/Articles/13592/Binding-DataSet-and-Generic-rdlc-Reports-to-a-Repo

Check this link this will give u a idea to load the dataset into rdlc report.

Babu.K