Datagrid or Datalist with Lookup Tables

D

Demetri

I have two tables in sql server. Customer and State. Of
course the Customer table has data about the customer
such as name, address, and phone number. It also has a
field called state_id. The state table has all the state
names and abbreviations, as well as the state_id field.

I have populated a dataset with the customer information.
I have also populated the same dataset with the state
information.

The datagrid's datasource is the dataset which has the
two tables, Customer and State.

The datagrid has a template column in order to have not
the state_id displayed but rather the state name.

Here is where I am stuck. I can get the datagrid to show
the customer information when I call the databind method.
However, I can not for the life of me get it to show the
state name for each customer record.

Any idea how to do this? I am taking a visual approach,
using VS.Net's integrated drag drop capabilities for the
data adapters and dataset objects.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top