Creating Hyperlink in DataGrid Column

[epigram]

I'm using the DataGrid with AutoGenerateColumns set to false and choosing
which columns I want in the grid by using the <Columns> attribute. What I
want to do is to create a hyperlink out of one of the columns that I am
displaying, but in order to build this link, I need a value that is in my
SELECT clause, but is not being displayed via a BoundColumn.

Say I have a query: SELECT ID, Name FROM Companies

Here, ID is the PK. I am only displaying the Name column, but I want the
Name to be a hyperlink to a "details" page for the company. So, I want to
build a link such as "CompanyDetails.aspx?id=1234".

I know there is an event I can override to change how the Name cell in the
DataGrid is rendered. What I don't know is how I can programmatically
access the ID column from my query once I am in this event handler.

Thanks!

[Elton Wang]

Hi epigram,

You can use HyperLinkColumn. And create url in
datagrid_ItemDataBound event:

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

HTH

Elton Wang
el********@hotmail.com

-----Original Message-----
I'm using the DataGrid with AutoGenerateColumns set to false and choosingwhich columns I want in the grid by using the <Columns> attribute. What Iwant to do is to create a hyperlink out of one of the columns that I amdisplaying, but in order to build this link, I need a value that is in mySELECT clause, but is not being displayed via a BoundColumn.
Say I have a query: SELECT ID, Name FROM Companies

Here, ID is the PK. I am only displaying the Name column, but I want theName to be a hyperlink to a "details" page for the company. So, I want tobuild a link such as "CompanyDetails.aspx?id=1234".

I know there is an event I can override to change how the Name cell in theDataGrid is rendered. What I don't know is how I can programmaticallyaccess the ID column from my query once I am in this event handler.
Thanks!
.

[A P]

How about in using VB.NET?
"Elton Wang" <an*******@discussions.microsoft.com> wrote in message
news:14****************************@phx.gbl...

Hi epigram,

You can use HyperLinkColumn. And create url in
datagrid_ItemDataBound event:

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

HTH

Elton Wang
el********@hotmail.com

-----Original Message-----
I'm using the DataGrid with AutoGenerateColumns set to

false and choosing

which columns I want in the grid by using the <Columns>

attribute. What I

want to do is to create a hyperlink out of one of the

columns that I am

displaying, but in order to build this link, I need a

value that is in my

SELECT clause, but is not being displayed via a

BoundColumn.

Say I have a query: SELECT ID, Name FROM Companies

Here, ID is the PK. I am only displaying the Name

column, but I want the

Name to be a hyperlink to a "details" page for the

company. So, I want to

build a link such as "CompanyDetails.aspx?id=1234".

I know there is an event I can override to change how the

Name cell in the

DataGrid is rendered. What I don't know is how I can

programmatically

access the ID column from my query once I am in this

event handler.

Thanks!
.

[Elton Wang]

Following is VB code

If e.Item.ItemType = ListItemType.Item OrElse
e.Item.ItemType = ListItemType.AlternatingItem Then
Dim drv As DataRowView = CType(e.Item.DataItem,
DataRowView)
Dim nameCell As TableCell = e.Item.Cells(nameIndex)
Dim link As HyperLink = CType(nameCell.Controls(0),
HyperLink)
link.NavigateUrl = "CompanyDetails.aspx?id=" + drv
("ID").ToString
End If

HTH

Elton Wang

-----Original Message-----
How about in using VB.NET?
"Elton Wang" <an*******@discussions.microsoft.com> wrote in messagenews:14****************************@phx.gbl...

Hi epigram,

You can use HyperLinkColumn. And create url in
datagrid_ItemDataBound event:

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

HTH

Elton Wang
el********@hotmail.com

>-----Original Message-----
>I'm using the DataGrid with AutoGenerateColumns set to

false and choosing

>which columns I want in the grid by using the <Columns>

attribute. What I

>want to do is to create a hyperlink out of one of the

columns that I am

>displaying, but in order to build this link, I need a

value that is in my

>SELECT clause, but is not being displayed via a

BoundColumn.

>
>Say I have a query: SELECT ID, Name FROM Companies
>
>Here, ID is the PK. I am only displaying the Name

column, but I want the

>Name to be a hyperlink to a "details" page for the

company. So, I want to

>build a link such as "CompanyDetails.aspx?id=1234".
>
>I know there is an event I can override to change how

the Name cell in the

>DataGrid is rendered. What I don't know is how I can

programmatically

>access the ID column from my query once I am in this

event handler.

>
>Thanks!
>
>
>.
>

.

[epigram]

Hi Elton,

I'm getting an error:

"System.ArgumentOutOfRangeException: Specified argument was out of the range
of valid values. Parameter name: index" with regard to the statement:

HyperLink link = (HyperLink) nameCell.Controls[0];

This cell is a BoundColumn. Any ideas what could be happening here?

Thanks.
"Elton Wang" <an*******@discussions.microsoft.com> wrote in message
news:14****************************@phx.gbl...

Hi epigram,

You can use HyperLinkColumn. And create url in
datagrid_ItemDataBound event:

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

HTH

Elton Wang
el********@hotmail.com

-----Original Message-----
I'm using the DataGrid with AutoGenerateColumns set to

false and choosing

which columns I want in the grid by using the <Columns>

attribute. What I

want to do is to create a hyperlink out of one of the

columns that I am

displaying, but in order to build this link, I need a

value that is in my

SELECT clause, but is not being displayed via a

BoundColumn.

Say I have a query: SELECT ID, Name FROM Companies

Here, ID is the PK. I am only displaying the Name

column, but I want the

Name to be a hyperlink to a "details" page for the

company. So, I want to

build a link such as "CompanyDetails.aspx?id=1234".

I know there is an event I can override to change how the

Name cell in the

DataGrid is rendered. What I don't know is how I can

programmatically

access the ID column from my query once I am in this

event handler.

Thanks!
.

[Elton Wang]

As I mentioned you should make the column as
HyperLinkColumn rather than BoundColumn. It's like

<Columns>
<asp:HyperLinkColumn DataTextField="Name"
HeaderText="Name"></asp:HyperLinkColumn>
other columns, in any
</Columns>

BTW, you should also use datatable, (or dataview, or
dataset) as datagrid's data source. Otherwise
DataRowView drv = (DataRowView)e.Item.DataItem

doesn't work.

HTH

Elton Wang

-----Original Message-----
Hi Elton,

I'm getting an error:

"System.ArgumentOutOfRangeException: Specified argument was out of the rangeof valid values. Parameter name: index" with regard to the statement:
HyperLink link = (HyperLink) nameCell.Controls[0];

This cell is a BoundColumn. Any ideas what could be happening here?
Thanks.
"Elton Wang" <an*******@discussions.microsoft.com> wrote in messagenews:14****************************@phx.gbl...

Hi epigram,

You can use HyperLinkColumn. And create url in
datagrid_ItemDataBound event:

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

HTH

Elton Wang
el********@hotmail.com

-----Original Message-----
I'm using the DataGrid with AutoGenerateColumns set to

false and choosing

which columns I want in the grid by using the <Columns>

attribute. What I

want to do is to create a hyperlink out of one of the

columns that I am

displaying, but in order to build this link, I need a

value that is in my

SELECT clause, but is not being displayed via a

BoundColumn.

Say I have a query: SELECT ID, Name FROM Companies

Here, ID is the PK. I am only displaying the Name

column, but I want the

Name to be a hyperlink to a "details" page for the

company. So, I want to

build a link such as "CompanyDetails.aspx?id=1234".

I know there is an event I can override to change how

the Name cell in the

DataGrid is rendered. What I don't know is how I can

programmatically

access the ID column from my query once I am in this

event handler.

Thanks!
.

.

[Elton Wang]

As I mentioned you should make the column as
HyperLinkColumn rather than BoundColumn. It's like

<Columns>
<asp:HyperLinkColumn DataTextField="Name"
HeaderText="Name"></asp:HyperLinkColumn>
other columns, in any
</Columns>

BTW, you should also use datatable, (or dataview, or
dataset) as datagrid's data source. Otherwise
DataRowView drv = (DataRowView)e.Item.DataItem

doesn't work.

HTH

Elton Wang

-----Original Message-----
Hi Elton,

I'm getting an error:

"System.ArgumentOutOfRangeException: Specified argument was out of the rangeof valid values. Parameter name: index" with regard to the statement:
HyperLink link = (HyperLink) nameCell.Controls[0];

This cell is a BoundColumn. Any ideas what could be happening here?
Thanks.
"Elton Wang" <an*******@discussions.microsoft.com> wrote in messagenews:14****************************@phx.gbl...

Hi epigram,

You can use HyperLinkColumn. And create url in
datagrid_ItemDataBound event:

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

HTH

Elton Wang
el********@hotmail.com

-----Original Message-----
I'm using the DataGrid with AutoGenerateColumns set to

false and choosing

which columns I want in the grid by using the <Columns>

attribute. What I

want to do is to create a hyperlink out of one of the

columns that I am

displaying, but in order to build this link, I need a

value that is in my

SELECT clause, but is not being displayed via a

BoundColumn.

Say I have a query: SELECT ID, Name FROM Companies

Here, ID is the PK. I am only displaying the Name

column, but I want the

Name to be a hyperlink to a "details" page for the

company. So, I want to

build a link such as "CompanyDetails.aspx?id=1234".

I know there is an event I can override to change how

the Name cell in the

DataGrid is rendered. What I don't know is how I can

programmatically

access the ID column from my query once I am in this

event handler.

Thanks!
.

.