Thammarat charoenchai. wrote:
Hi.
I'm newbie to asp.net
now i can use gridview to show data from sqldatasource.
But I wonder How to show lookup field data.
like
get parameter from querystring name "pid" (ProductID) and show
ProductName in webpage to user?
Use SQL.
Make a JOIN query with both tables.
If you don't know how to do this, I guess you're using Access?
Go into query design, add both tables, link them, select the fields you want
to show in the gridview, and then choose View - Sql View.
Access will have built the SQL query you need.
You can do the same thing from Visual Studio or Visual Web Developer with
the Query Builder.
--
Riki