Query string and Parameter Passing Problem

[Paul Gray via DotNetMonster.com]

Hi

In the context of a Master/Detail scenario, I am having trouble figuring
out the correct syntax for passing a parameter in a query string in a
HyperLink Column, but the parameter is coming from a seperate bound column,
which is not visible and so cannot itself be used as the hyperlink column

If I want to pass the parameter from my Hyperlink column, it is fine,

DataNavigateUrlFormatString="detailsPage.aspx?ID={ 0}"


but how do I reference my invisible bound column, that is, the unique 'ID'
one,

<asp:BoundColumn HeaderText="ID" DataField="ID" Visible="False" />

and pass it as a parameter in the query string

DataNavigateUrlFormatString="detailsPage.aspx?ID={ 0}"

My Datagrid is as follows

<asp:DataGrid ID="dgrdMenu" Runat="Server"

AutoGenerateColumns="false">

<Columns>
<asp:BoundColumn HeaderText="ID" DataField="ID" Visible="False"
/>
<asp:BoundColumn HeaderText="Code" DataField="Code" />
<asp:HyperLinkColumn
HeaderText="Product Description"
DataNavigateUrlField="Description"
DataNavigateUrlFormatString="detailsPage.aspx?ID={ 0}"
DataTextField="Description"
Target="_new" />
<asp:BoundColumn HeaderText="Price" DataField="Retail"/>
</Columns>

</asp:DataGrid>

and my SQL string is "Select ID, Code, Description, Retail from
Pricelist0804 WHERE

Description LIKE '%' + @name + '%' ";

I would be grateful if anyone could give me the exact syntax

--
Message posted via [url]http://www.dotnetmonster.com[/url]

[Elton W]

Hi Paul,

If you want to pass ID rather than Description as query
string to hyperline, you can do it in
datagrid_ItemDataBound event:

if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem )
{
DataRowView drv = (DataRowView)e.Item.DataItem;
HyperLink link = (HyperLink)e.Item.Cells
[2].Controls[0];
link.NavigateUrl="detailsPage.aspx?ID=" + drv
["ID"].ToString();
}


HTH

Elton Wang
[email]elton_wang@hotmail.com[/email]

>-----Original Message-----
>Hi
>
>In the context of a Master/Detail scenario, I am having

trouble figuring

>out the correct syntax for passing a parameter in a query

string in a

>HyperLink Column, but the parameter is coming from a

seperate bound column,

>which is not visible and so cannot itself be used as the

hyperlink column

>
>If I want to pass the parameter from my Hyperlink column,

it is fine,

>
>DataNavigateUrlFormatString="detailsPage.aspx?ID= {0}"
>
>
>but how do I reference my invisible bound column, that

is, the unique 'ID'

>one,
>
> <asp:BoundColumn HeaderText="ID" DataField="ID"

Visible="False" />

>
>and pass it as a parameter in the query string
>
>DataNavigateUrlFormatString="detailsPage.aspx?ID= {0}"
>
>My Datagrid is as follows
>
><asp:DataGrid ID="dgrdMenu" Runat="Server"
>
> AutoGenerateColumns="false">
>
> <Columns>
> <asp:BoundColumn HeaderText="ID"

DataField="ID" Visible="False"

>/>
> <asp:BoundColumn HeaderText="Code"

DataField="Code" />

> <asp:HyperLinkColumn
> HeaderText="Product Description"
> DataNavigateUrlField="Description"
>

DataNavigateUrlFormatString="detailsPage.aspx?ID={ 0}"

> DataTextField="Description"
> Target="_new" />
> <asp:BoundColumn HeaderText="Price"

DataField="Retail"/>

> </Columns>
>
> </asp:DataGrid>
>
>and my SQL string is "Select ID, Code, Description,

Retail from

>Pricelist0804 WHERE
>
>Description LIKE '%' + @name + '%' ";
>
>I would be grateful if anyone could give me the exact

syntax

>
>--
>Message posted via [url]http://www.dotnetmonster.com[/url]
>.
>

[Paul Gray via DotNetMonster.com]

Thanks Elton, I will try that

--
Message posted via [url]http://www.dotnetmonster.com[/url]