Hi Mike,

I had already tried as per you said but an error was occured that time.

Error was about date conversion because some data are not well formated in messagetimestamp field.

Simply...

No. In this query, it will give me error. because there while doing join, it will consider all data including invalid data. And conversion of such data into date will...

I m going to update many records at a time.

for that I collect all the data in datatable and then I want to dump it in sql table.

I don't want...

I making data table in application only.

using system.data.datatable.

In that I am collecting all records.

Now I want to update sql table with these data of datatable which i made.

please go through...