PC Review


Reply
Thread Tools Rate Thread

DataTable or DataSet for Updating Data?

 
 
Mike Wilson
Guest
Posts: n/a
 
      5th Jan 2006
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


 
Reply With Quote
 
 
 
 
Cor Ligthert [MVP]
Guest
Posts: n/a
 
      6th Jan 2006
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?...e-e8335682ad3a

I hope this helps,

Cor


 
Reply With Quote
 
Mike
Guest
Posts: n/a
 
      7th Jan 2006
"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?...e-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


 
Reply With Quote
 
W.G. Ryan
Guest
Posts: n/a
 
      7th Jan 2006
Mike wrote:
> "Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>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?...e-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
>
>

Mike, what specifically are you looking for?
 
Reply With Quote
 
Mike
Guest
Posts: n/a
 
      7th Jan 2006
"W.G. Ryan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> 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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
add new rows of data to a datatable of a dataset =?Utf-8?B?QW5kcmV3?= Microsoft ASP .NET 4 24th Mar 2006 09:10 AM
How to reteive data amongst different datatable within a dataset =?Utf-8?B?TGkgUGFuZw==?= Microsoft ADO .NET 2 1st Sep 2005 10:03 PM
Updating DataSet/DataTable Steve Schroeder Microsoft ADO .NET 6 18th Apr 2005 09:54 PM
Reading Xml into a dataset then updating the sqlce datatable causes castexception Tom Microsoft Dot NET Compact Framework 1 20th Jan 2004 11:05 PM
Updating a DataTable as opposed to a DataSet Nick Zdunic Microsoft ADO .NET 3 17th Sep 2003 01:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:18 PM.