Question on DataSet

[Manikrag]

Hi

I did not find any solution on internet so pretty basic question here:

I am trying to copy a dataset to a new dataset by

ds1 = ds.Copy(); // ds has one row

After that I am trying to update the SqlDataAdapter by using below statement

adptr.Update(ds1.Tables["table name"]);

I am not facing any issue but the SqlDataAdapter is not adding the new row.


Please help

[Manikrag]

Hi

I did not find any solution on internet so pretty basic question here:

I am trying to copy a dataset to a new dataset by

ds1 = ds.Copy(); // ds has one row

After that I am trying to update the SqlDataAdapter by using below statement

adptr.Update(ds1.Tables["table name"]);

I am not facing any issue but the SqlDataAdapter is not adding the new row.


Please help

[tlhintoq]

Please don't double-post your questions. It divides attempts to help you in an organized and cohesive manner. Your threads have been merged

[Manikrag]

Sorry about that - I was desperate and was looking for reaction on the issue which i did not get..Point taken anyway!!

[Manikrag]

got a better way, sharing it for others who might be OR will be in the same situation where I was..

System.Data.SqlClient has a class - SqlBulkCopy (http://msdn.microsoft.com/en-us/libr...lbulkcopy.aspx) - this can copy tables as per the select command over servers like a charm..try u will love it :)

SqlCommand cmd = new SqlCommand("SELECT QUERY", dbConn_source);
dbConn_target.Open();
SqlDataReader rdr = cmd.ExecuteReader();
// Initializing an SqlBulkCopy object
SqlBulkCopy sbc = new SqlBulkCopy(dbConn_target);
// Copying data to destination
sbc.DestinationTableName = "TableName";
sbc.WriteToServer(rdr);
sbc.Close();
rdr.Close();