DataSet Question

[ted]

Hi,

I have a dataset that is filled with data from the db. The user has
modified that data in one of the tables where some of fields should now be
null. I have played around with delete the row and adding a new row but
have problems with the update. Do you think I should just reset the row by
looping through the row and setting all the values to null before I update
changes to the row?

Thanks

 

[W.G. Ryan - MVP]

Ted:

What specifically is the problem? If you delete the row and call Update, if
the adapter is configured properly, then the row should disappear from the
db b/c it's deleted. The Adapter should do that for you on Update. If you
just need the values in the dataRow to be null, then yes, just setting them
locally should do it for you. Let me make sure I understand the problem
before proceeding though.

 

[ted]

Thanks for the post. See I do not update until after I delete the row and
add the new row. The dataset is quite large with multiple tables and there
is alot of changes going into all of the tables. I think it is better if I
just set the row values to null.

Thanks

 

[Cor Ligthert [MVP]]

Ted,

Are you sure that you use a "delete" method to delete row and not a "remove"
method.

The "remove" methods removes everything from the datatable. The "delete"
signs the row to be deleted by the next update or by an acceptchanges.

I hope this helps,

Cor