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
the gridview.

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
Product Table.

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.
"COMPLETED"

thanks guys,
Andrew