Adding a Data Source

[Jonathan Wood]

I'm fairly new to using a SQL Server data source in a C# Windows Forms
application.

I want to use several tables on several of my forms--and probably a couple
of data grids. So, from the Data Sources windows, I selected Add New Data
Source.

This pops up the Data Source Configuration Wizard, which allows me to select
which database objects I "want in my dataset."

I'm not clear on if I should select all the objects I want to use in my
application, or if I should just choose those objects I want to use on the
current form (and then do this again for other forms).

Can someone help point me in the right direction?

Thanks.

Jonathan

 

[sloan]

Most times you want to pick the "smaller version of your world"....where the
"world" is your entire database.

So if you wanted to Edit an Employee............and an Employee was able to
be in one department. You would pick the

dbo.Department
dbo.Employee

tables.
Then you could edit the employee AND populate a dropdown box that had all
the departments listed in it.


That's my advice. It becomes very unruly if you put every table into one
dataset(definition).

 

[Jonathan Wood]

Okay, so I guess this means I create another data source when I need to work
with, for example, products data.

Thanks.

Jonathan