DataTable or DataSet for Updating Data?

  • Thread starter Thread starter Mike Wilson
  • Start date Start date
M

Mike Wilson

I have a heirarchical set of data that I need to read into a DataGrid. I'm
using SQL in the TableAdapter portion of the main table in the DataSet to
retrieve a set of rows which I bind to my DataGrid.

Should I bind a DataSet or a DataTable to the DataGrid? Which is the best
design choice, given the grid needs to be able to be edited and for the
changes to propogate to all the tables.

Thanks in advance for the n00bish question, I will get the hang of ADO.NET
eventually and might one day be helping you guys out :-)

Thanks,

Mike
 
Cor Ligthert said:
Mike,

Those application have mostly the name Master Detail (to make it able to
search for you for it)

Here is *one* of the samples about that on our website.
(I see now that we don't use that Master Detail but relations)

http://www.vb-tips.com/default.aspx?ID=3eafa9ea-a906-45ff-aece-e8335682ad3a

I hope this helps,
Click to expand...

Thank, you - that's helpful, but for now I was looking for something more
design-time oriented.

Warm Regards,

Mike
 
Mike said:
Thank, you - that's helpful, but for now I was looking for something more
design-time oriented.

Warm Regards,

Mike
Click to expand...
Mike, what specifically are you looking for?
 
Mike, what specifically are you looking for?
Click to expand...

Specifically an example of a working
DataSource<->BindingSource<->BindingNavigator form where the DataSource
contains multiple tables and relations (mostly lookup tables).

Shouldn't be too hard, but I'm stuck on two issues:

1. My current code doesn't save changes to the database

2. If I have a table (say "Customer") which has many foreign keys to other
tables (say "Customer_Type"), and I want to look up the "Customer_Type"
value for a dropdown list - do you know of any good examples for this?

Thanks in advance. I appreciate your help.

Mike
 
Back
Top