Viewing DataAdapter in Dataset at design time

[Eric]

Hello,

I have a simple DataGrid displaying data in my DataSet, which is loaded in
two DataAdapters.

It works fine where I fill the DataSet using the DataAdapters. It displays
the data, can be updated, etc.

Now here's the question.

I have a simple PK/FK relation between the tables, and I was hoping to use
the design tools to easily create this relation.

In design time, I apparently need to manually define the tables in the
tables collection and create the relation in the relations collection. Is
there an easier way to load the DataAdapter definitions into the dataset
during design time, so I can easily create the PK/FK constraint?

Also, what is the easiest way to create a dropdown list in the datagrid for
the FK table?

Thanks,

eric

 

[Eric]

NEWBIE

I figured it out. I right-clicked on the Data Adapter and selected
"Generate Dataset."

Then on the generated dataset, I right-clicked and chose View Schema, and
created the PK/FK relation.

Eric