Shawn,
>But when i check the dr object it has two rows .
>zero as the first row which is from the server filled with data, and 1 for the second row which is the new row i added.
>
>How do i find the new row, if the above syntax is not correct assumption.
If you're working with a DataTable (as opposed to a DataView) a new row is added to the end of the Rows collection, so you could retrieve the last added row as follows:
DataRow dr = ds.Tables[tableName].Rows[ds.Tables[tableName].Count-1];
However, even easier, when a new DataRow is added you can access the new row from the business object's DataRow property.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com