Updating Database from combobox in datagrid

[redwebgeek]

Hi,

I've been searching this one for two days so thought I give this a
shot again. I have two datasets Dataset1 and Dataset2

Dataset1 populates a datagrid and dataset2 populates a combobox within
the datagrid. When I try using SqlCommandBuilder it doesn't work
since I am using two datasets. So am I looking for a way to update
the table for dataset1 using a field from the combobox.

Can I somehow specify each table and row to update based on the
dataset I need.

OR is there a better way?
TIA,

Red

[Cor Ligthert]

RedWebGeek,

In this situation as you describe you are mostly using in the combobox a
dataset that is not needed to update (would be very strange because it
serves as a choosebox for the datagridcolumn).

Because when it is right is the column to be updated binded to the value of
that combobox. And therefore you needs only to update the dataset1 (assuming
that is the datagrid1).

You can look at this sample I once made with as basic the combobox class
that is on syncfusion (There are some optimizing changes in it).

http://www.google.com/gr************...TNGP11.phx.gbl

I hope this helps?

Cor