Finding the index of the DataRow to update?
I've got a strongly-typed dataset with 2 related tables in it ("Staff"
and "Roles"). I want to make a change to the parent Staff row and also
to its child Role row. I'm having difficulty figuring out the best way
to do this.
I can get myself a new instance of a row and make changes to it, but
presumably that's then a separate object from the original dataset
row. How do I reconcile my changes back to the dataset?
Because I haven't figured out the answer to the above, I'm updating
the rows directly in the dataset. But in order to find which row to
update, I'm having to do something which looks really complicated (see
code snippet below).
It can't be that difficult! But the MSDN examples are no help at all -
they simply refer to the required row using an absolute value:
dataset1.Tables["Customers"].Rows["CompanyName"] = "Wingtip Toys";
How much use is that in The Real World?! Not much - what I need to
know is, how to dynamically find that value 4 in the example.
Any help would be much appreciated. Thanks very much. Here's the code
//find the index of the Staff row to update (where StaffID=_staffID):
int i=0, rowID=0;
foreach(UserDataSet.StaffRow dr in staffRows)
//update the staff datarow with the new values:
etc. then I do the same for the child table (Role) rows:
//find the index of the child Role row to update (where
foreach(UserDataSet.RolesRow rr in
//update the Role datarow with the new values:
|All times are GMT. The time now is 04:02 PM.|
Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.