How to show lookup text in asp.net

  • Thread starter Thread starter Thammarat charoenchai.
  • Start date Start date
T

Thammarat charoenchai.

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?

anyone help me & thanksyou

sorry about my english :D
 
Thammarat said:
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?
Click to expand...

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.
 
Back
Top