How to get the original value in dataset.
Posted on 2003-11-07
I have to get the previous value of a certain cell in a datagrid.
I used dataset.getchanges to get the rows that has changed.
On modified rows I will update the database using a stored procedure. It is impossible that I use the ds.update since the dataset table is not equal to the real database table.
What I did was, I used the sqlcommand object to call the stored proc.
My problem is, in passing parameters to an update procedure, you need to provide the primary key values of the table. But in my case, the primary column is also changeable. I need to know the original value of the row i am going to save.
Thanks in advance.