Binding LookUp Tables to Gridview/DataGrid - 08-11-2006 , 04:39 PM
I've been working with sqlDatasource for a while now and whenever i
want to bind a table that contains lookup fields i've always combined
them in the stored procedure i've used to link the sqldatasource up to
Recently i've tried to use the vs2005 built-in xsd generator for my
data access layer. I'm having a hard time figuring out how to add
lookup fields to a gridview when binding with an object data source.
Basically if i had a table, lets call it Product, and one of the fields
is StatusID , Another table Status has fields StatusID and
StatusDescription. How do i make the status description field show up
in the gridview when i'm binding using the object datasource of my
Of course i don't want the gridview to show "3" under that statusID
field, i want it to show StatusDescripton for statusid = "3" .. i.e.
|Thread Tools||Search this Thread|