Forum Moderators: open

Message Too Old, No Replies

.net data grid

how to update when multiple key columns?

         

RossWal

11:58 pm on Jan 6, 2004 (gmt 0)

10+ Year Member



I have a datagrid that requires three columns to achieve uniqueness. The underlying data is XML. I can't figure out how to targtet the XML row for an update from the datagrid. Has anyone done this?

I guess I could create a single column with the concatenated vlues of the 3 columns, but that seems pretty lame.

Thanks,
Ross

aspdaddy

12:22 am on Jan 8, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



what is the syntax to update datagrids?
Can you use an sql style update

update grid
set field=value
where col1=x AND col2=y and col3=3

RossWal

5:49 pm on Jan 8, 2004 (gmt 0)

10+ Year Member



Sorry, I wasn't clear. The user types new values into the datagrid then I want to capture them and update the unberlying XML. All the references I've uncovered show how to do it when there is one key field for the underlying xml table, but not when there are multiple keys, though some do say multiple keys are possible.

For now I'm finding my XML row manually instead of having .net manage the update for me.

Thanks.