Hi,
   I created a ce database and upgraded it using VS2008. I added a
datasource to a C# windows application and created all of the default
DataSets and TableAdapters. I've populated some of the tables and I'm trying
various different methods of usefully extracting that data.

   I'm probably missing steps here but having dropped a combobox onto a
form I set its databinding properties to:

DataSource = TableAdapter
DisplayMember = Name Field
DisplayValue = ID Field

When I preview the data the recordset is returned correctly. On form load
however the combobox remains empty. I figure I probably have to call GetData
or Fill somewhere on the TableAdapter but I can't figure out where.

I then initialised an instance of the TableAdapter and DataTable in code.
Doing so means that I can assign the records returned from the GetData method
of the TableAdapter to the instance of the DataTable. Then I can iterate
through the DataRow objects in the DataTable and manually add them
individually to the combobox. This method works so the underlying structure
should be fine.

Is there any way of doing this visually through the ide or how many things
am I doing wrong above. How should controls be bound to underlying dataset?

Also should I have the entire database as a single dataset with
TableAdapters for each table or should I use seperate datasets or does it
depend on other factors too complex for a concise answer? I have done some
research into the benefits of one system compared to another but I can't
really get a handle on it. Should I be trying to use Linq for this?

Any help or pointers greatfully accepted. I'm creating all of this from
scratch so if need be I can use an entirely different approach.

Stephen