A
Alan Baljeu
I have an SQL table with a 3 column key, PK = (a,b,c). I read that into a DataTable:
SELECT * from MYTABLE where a=1 AND b=2
I edit this in a grid, hiding columns 'a' and 'b'. During editing, column c values may
change, plus new records may be added. After editing, I fill in columns 'a' and 'b'
(values 1 and 2 respectively).
How do I send this data back to the server? Can I do this using a DataAdapter? In my
case, a CommandBuilder won't do the job.
The sticking point is how to write the UPDATE statement as it must use the original value
of column c of the row. I know how to write one update statement for one row, but I can't
figure out the procedure to use a DataAdapter.
If I can't use the DataAdapter, how can I do a full update manually?
SELECT * from MYTABLE where a=1 AND b=2
I edit this in a grid, hiding columns 'a' and 'b'. During editing, column c values may
change, plus new records may be added. After editing, I fill in columns 'a' and 'b'
(values 1 and 2 respectively).
How do I send this data back to the server? Can I do this using a DataAdapter? In my
case, a CommandBuilder won't do the job.
The sticking point is how to write the UPDATE statement as it must use the original value
of column c of the row. I know how to write one update statement for one row, but I can't
figure out the procedure to use a DataAdapter.
If I can't use the DataAdapter, how can I do a full update manually?