dataset

[mmb]

How to get the index of the rows that has been modified(insert,Update,delete) in the Dataset datatable, rather then Using the
dataset1.AcceptChanges and save the whole table which is not at all efficient way.

Help Me out

 

[Avanti Dharkar]

Let ds be the name of ur dataset.
then use the command

ds.tables("<name of table>").rows(<specify row number>).items(<name or index of item>)

that should help

 

[Paszt]

If you use the DataForm Wizard to create a DataForm, it will show you the correct way to do this.
It's a combination of using parameters with the SQL statement, then using the DataSet.GetChanges method to return a dataSet with only the changes. You then update the dataBase with only that subset of the dataSet.

 

[mmb]

Thanks

Pazt

U r rite.
I did it without using the wizard from MSDN online.
Thanks for the help.
Its like brothers helping in difficult situation.

Regards.