Is it Possible to Bind One DataSet Table to Multiple DataGrids?

[andrea96]

I have a form with several TabPages that need to display different order line information from the same database table. For example, the first TabPage has order line number (read-only), part number (editable), price (editable), and qty (editable). The second TabPage has order line number (read-only), part number (read-only), and account code (editable). Is there anyway to do this with one DataSet table, or will I have to create one DataSet table for each DataGrid and pull the information back together for the database update/insert?

Thanks,
Andrea

 

[chrissie1]

I think you can do it with one dataset table. But You need to make sure that the record in the one datagrid isn't the same as the record in datagrid two (or is it?) because then you need to make sure you check if they didn't edit the partnumber in one datagrid an put another one in the other datagrid.

just my 2cents worth.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[andrea96]

Thanks for your reply. I was getting a databinding error, that I thought was because of the datagrids, but it looks like it was on a bound textbox on the form, instead.