Hi.
How do i "bulk update" data rows on a dataset table from another one
DataTable?
i have a dataset ds1 with a table "Groups" and a table "newgroupdata"
and i want to update the records in ds1.Tables["Groups"] from the data
in ds1.Tables["newgroupdata"].
Additional i want to insert groups wich are not already in "Groups"
too.
Is this possible.
At the moment i loop thru "newgroupdata" and do a
DataRow[] foundRows = ds1.Tables["Groups"].Select( "Group = '" +
findgroup + "'", "", DataViewRowState.Added );
if(0==foundRows.Length)
{
// Add group to "Groups"
}
else
{
// Update foundRows
}
running this on a table with multiple thousand group records is
horrable slow.
I fear this can only be done in a fast and efficient way using a
database server.