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 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

On Aug 5, 5:45 pm, "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?
>
> anyone help me & thanksyou
>
> sorry about my english :D


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