Changing the DataRowState Property

[Dennis Davitt]

I am trying to force update a DataSet which I retrieve via a Web Service.
All the rows in the DataSetRowState are "unchanged". Since this property is
read-only, I cannot use the DataAdapter.Update() method. How can I override
the DataRowState Property since it is Read-Only???

 

[Manoj G [MVP]]

Hi,

You can trick the DataAdapter by updating one of the columns to its own
value. This way the RowState changes to Modified and hence your problem
should be solved!
Something like:

ds.Tables(0).Rows(0).Item(0) = ds.Tables(0).Rows(0).Item(0)

 

[Dennis Davitt]

A hack but it works!!! Thanks.

Hi,

You can trick the DataAdapter by updating one of the columns to its own
value. This way the RowState changes to Modified and hence your problem
should be solved!
Something like:

ds.Tables(0).Rows(0).Item(0) = ds.Tables(0).Rows(0).Item(0)


--
HTH,
Manoj G [.NET MVP]
http://www15.brinkster.com/manoj4dotnet

I am trying to force update a DataSet which I retrieve via a Web Service.
All the rows in the DataSetRowState are "unchanged". Since this property is
read-only, I cannot use the DataAdapter.Update() method. How can I override
the DataRowState Property since it is Read-Only???

 

[Dennis Davitt]

I am not able to get the index value of the row using the syntax below. I
tried the importRow but the state is set to unchanged! Any suggestions.

A hack but it works!!! Thanks.

Hi,

You can trick the DataAdapter by updating one of the columns to its own
value. This way the RowState changes to Modified and hence your problem
should be solved!
Something like:

ds.Tables(0).Rows(0).Item(0) = ds.Tables(0).Rows(0).Item(0)


--
HTH,
Manoj G [.NET MVP]
http://www15.brinkster.com/manoj4dotnet

I am trying to force update a DataSet which I retrieve via a Web Service.
All the rows in the DataSetRowState are "unchanged". Since this

property
is

read-only, I cannot use the DataAdapter.Update() method. How can I override
the DataRowState Property since it is Read-Only???

 

[Dennis Davitt]

I fixed:

dr[0] = dr[0]

I am not able to get the index value of the row using the syntax below. I
tried the importRow but the state is set to unchanged! Any suggestions.

A hack but it works!!! Thanks.

Hi,

You can trick the DataAdapter by updating one of the columns to its own
value. This way the RowState changes to Modified and hence your problem
should be solved!
Something like:

ds.Tables(0).Rows(0).Item(0) = ds.Tables(0).Rows(0).Item(0)


--
HTH,
Manoj G [.NET MVP]
http://www15.brinkster.com/manoj4dotnet

I am trying to force update a DataSet which I retrieve via a Web Service.
All the rows in the DataSetRowState are "unchanged". Since this property
is
read-only, I cannot use the DataAdapter.Update() method. How can I
override
the DataRowState Property since it is Read-Only???