RowState

[Bhagya]

Hello,

I have a Dataset in which i have multiple rows. Some of these rows
have been edited and some new rows have also been added to the
Dataset.

Now I have two Commands that is the InsertCommand and the
UpdateCommand.

I want to seperate the rows in such a way that, all the rows that have
been newly added should at once be sent to the InsertCommand and all
the rows that have been edited should be sent to the UpdateCommand.
Can someone pls tell me how to do this???

 

[Miroslav Stampar [MCSD.NET / Security+]]

Hi.

The standard way to do this is by using the SqlDataAdapter object. It
automatically does this for you when you call it's method Update(...).

Excellent tutorial can be found on
http://quickstart.developerfusion.co.uk/QuickStart/howto/doc/adoplus/UpdateDataFromDB.aspx

HTH

Bhagya je napisao/la: