Deleted records in a dataset

[kmuthuk]

Hi I am trying to explain my problem clear enough. I have a dataset DataSet1 which has some data retrieved from the database. I have a copy of DataSet1 called DataSet2. In DataSet2 user are doing some transaction..modifying and deleting rows in a datatable. Now I want to reflect deleted records of DataSet2 in DataSet1. I tried with "Merge", but it reflects only the modified not deleted records. Can anyone help solve this? Thanks in advance Muthu.

[bobsugar222]

You don't need a second copy of the dataset to track the changes yourself. Each row has a RowState property which tracks this so you can validate / undo / whatever

[kmuthuk]

Thats right. But in this case, second dataset is generated by another application. So I need to get modified and deleted details of second dataset. Thanks Muthu.

[bobsugar222]

Are changes being made to dataSet1 while changes are being made to dataSet2 in the other application?

[kmuthuk]

Yes. Exactly. Second application returns the modified Dataset. I want to find out the deleted records for each datatable without using any loops. Thanks Muthu.

[Aleksandar Smudja]

I am not sure if this is what you want: for (int i = 0; i <= pTable.Rows.Count - 1; i++) { DataRowState rowState = pTable.Rows[i].RowState; if (rowState == DataRowState.Deleted) { //..... } }