DataRowState Question

[kishor]

Hi,
I have created an webservice which returns one dataset. That dataset
contains a datatable and same is used to display or manuplate information on
windows form.

I have created a one more method in webservice so that same dataset can be
updated back to the database. so There I try to identify the rows which are
modified/added deleted.. etc using DataRowState filter.

But every time I am getting all rows in DataRowState.Modified; when there
was no change. what are pre-requisite for making this work. Sql server is
backend used for this.

Is there any other way to achieve this? Datatable is populated from the
multile tables by joining so at the time of putting back it has to be
sapereated.

Regards,

 

[miher]

Hi,

I don't know if You already considered that, but try using the GetChanges()
method of the DataSet and return only the changed part of the DataSet to
Your update webservice method.

Hope You find this useful.
-Zsolt