How does update work

[PhilM]

I bind a Datagrid to a recordset obtained from a stored proc in SQL server.
DataGrid displays the recordset.
User updates some data on the grip, pushes update button.
Event code calls Datagrid1.Update ... but what should that do? I suppose it
executes the code stored in the Update command of the Dataset it is bound
to, but should I write a stored proc to update the database, and if I do how
does the data get to the stored proc?

 

[Brock Allen]

You need to fetch the row in the datagrid, find every cell, dig into the
cell, find the server control and fetch the value. Once you have all of the
values for all if your columns, then you use that data to do your update
in the DB. It's a PITA. As an aside, 2.0 makes thie much easier with 2-way
databinding.