How to show lookup text in asp.net

[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

 

[Riki]

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.

 

[Guest]

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

This would help you
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/gridview.aspx