datagrid

[Narmada Gosula]

i have a datagrid which was bound to ado datacontrol....at run time i will change the data in the datagrid.now i want to insert the changed record set in to the other table.....how can i do this.....will u please help me in doing this....
i want the code to insert the manipulated record of datagrid into other table.

[phunkydude]

Depending on the DBMS you're using, it will be easier to use an INSERT trigger to perform the task. Otherwise, check out the events for the ado object and insert the necessary code at the correct event.

Hope this points in the right direction