Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Datagrid or Datalist with Lookup Tables

Thread Tools

Datagrid or Datalist with Lookup Tables

Posts: n/a
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

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.

Reply With Quote

Thread Tools

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
dictionnaries and lookup tables Python 6 10-12-2005 12:45 AM
XSLT Lookup Tables Help. Adrian Charteris XML 4 10-18-2004 08:58 AM
Setting up a datalist control - Item_DataBound for a datalist in a datalist Nevyn Twyll ASP .Net 8 09-09-2004 10:13 PM
using XSLT to do "medium-heavy" data transformations with lookup tables Jack Java 0 04-20-2004 10:29 PM
Function lookup tables? John Collyer C++ 12 10-06-2003 12:37 PM