DataTable or DataSet for Updating Data?

[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 [MVP]]

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,

Cor

 

[Mike]

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,

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

Warm Regards,

Mike

 

[W.G. Ryan]

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

Warm Regards,

Mike

Mike, what specifically are you looking for?

 

[Mike]

Mike, what specifically are you looking for?

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