dataset

mmb

Active member
Joined
Aug 1, 2004
Messages
42
Programming Experience
1-3
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

New member
Joined
Feb 16, 2005
Messages
3
Programming Experience
1-3
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

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
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

Active member
Joined
Aug 1, 2004
Messages
42
Programming Experience
1-3
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.
 
Top Bottom