Here is a Long way ...if you asked the same.
for (int i = 0 ; i < dataSet2.Tables["myremotedata"].Rows.Count; i ++)
{
dataSet1.Tables["mylocaldata"].Rows.Add(dataSet2.Tables["myremotedata"].Rows
[i].ItemArray);
}
oleDbDataAdapter1.Update(dataSet1, "mylocaldata");
"Kifaro" <no****@nospam.com> wrote in message
news:Tf********************@adelphia.com...
Hi I am looking for info on the correct way to import data from a dataset
directly into my local SQL Server database. I need to take into account
PK id. I could look through the data, but I think there has to be a better
way!!!
Thanks