Updating Database from combobox in datagrid

R

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
 
C

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/[email protected]

I hope this helps?

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top