Dynamically setting datagrid column in code-behind?

[Roy]

Hey all,

On my html page I have a datagrid with the column:
<boundColumn datafield="xyz" visible = false>
</boundColumn>

In my code behind, within item data bound event, I dynamically set the
column text like so:
e.item.cells(10 ).text = mystring.trim

Why I'm doing this is because I'm essentially using the invisible
boundcolumn to store info for use by this datagrid column's hyperlink:

<templatecolumn >
<itemtemplate >
<hyperlink navigateurl="dn l.aspx?a=xyz"

e.item.cells(10 ) is being set properly and contains the data (or as
best as I can tell). However, the templatecolumn' s hyperlink never
changes and always displays the default data in the link.
It's almost as if the hyperlink info gets set prior to the boundcolumn.
How can I get around this?

Thanks.

[Grant Merwitz]

You can use the OnItemDataBound event.

if you set an ID for you HyperLink (or use its ordinal position), you can
modify from the code behind.

e.g.

private void DataGrid1_OnIte mDataBound(obje ct Sender,
System.Data.Dat aItemEventArgs e)
{
if(e.Item.ItemT emplate != ListItemType.He ader && e.Item.ItemTemp late !=
ListItemType.Fo oter)
{
((Hyperlink)e.I tem.FindControl ("Hyperlink1")) .NavigateUrl =
"dnl.aspx?a =" + [value goes here]; //This could be e.Item.Cells[0].Text for
example
}
}

hope that helps

"Roy" <ro**********@g mail.com> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. .

Hey all,

On my html page I have a datagrid with the column:
<boundColumn datafield="xyz" visible = false>
</boundColumn>

In my code behind, within item data bound event, I dynamically set the
column text like so:
e.item.cells(10 ).text = mystring.trim

Why I'm doing this is because I'm essentially using the invisible
boundcolumn to store info for use by this datagrid column's hyperlink:

<templatecolumn >
<itemtemplate >
<hyperlink navigateurl="dn l.aspx?a=xyz"

e.item.cells(10 ) is being set properly and contains the data (or as
best as I can tell). However, the templatecolumn' s hyperlink never
changes and always displays the default data in the link.
It's almost as if the hyperlink info gets set prior to the boundcolumn.
How can I get around this?

Thanks.

[Eliyahu Goldin]

If all you need is just to use the value of another field in the datarecord
without displaying it, you don't need to allocate a datagrid column for
that. Use property DataItem of the datagrid item in ItemDataBound event.
Typecast it to you record type and get the field value from there.

Eliyahu

"Roy" <ro**********@g mail.com> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. .

Hey all,

On my html page I have a datagrid with the column:
<boundColumn datafield="xyz" visible = false>
</boundColumn>

In my code behind, within item data bound event, I dynamically set the
column text like so:
e.item.cells(10 ).text = mystring.trim

Why I'm doing this is because I'm essentially using the invisible
boundcolumn to store info for use by this datagrid column's hyperlink:

<templatecolumn >
<itemtemplate >
<hyperlink navigateurl="dn l.aspx?a=xyz"

e.item.cells(10 ) is being set properly and contains the data (or as
best as I can tell). However, the templatecolumn' s hyperlink never
changes and always displays the default data in the link.
It's almost as if the hyperlink info gets set prior to the boundcolumn.
How can I get around this?

Thanks.

[Elton W]

Hi Roy,

The simple way is to use HyperLinkColumn :

<asp:HyperLinkC olumn DataTextField=" xyz" DataNavigateUrl Field="xyz"
DataNavigateUrl FormatString="d nl.aspx?a={0}" ></asp:HyperLinkCo lumn>

HTH

Elton
el********@hotm ail.com
"Roy" wrote:

Hey all,

On my html page I have a datagrid with the column:
<boundColumn datafield="xyz" visible = false>
</boundColumn>

In my code behind, within item data bound event, I dynamically set the
column text like so:
e.item.cells(10 ).text = mystring.trim

Why I'm doing this is because I'm essentially using the invisible
boundcolumn to store info for use by this datagrid column's hyperlink:

<templatecolumn >
<itemtemplate >
<hyperlink navigateurl="dn l.aspx?a=xyz"

e.item.cells(10 ) is being set properly and contains the data (or as
best as I can tell). However, the templatecolumn' s hyperlink never
changes and always displays the default data in the link.
It's almost as if the hyperlink info gets set prior to the boundcolumn.
How can I get around this?

Thanks.

[Roy]

Thanks for the tip Grant, I'll give it a whirl and get back to you.

*** Sent via Developersdex http://www.developersdex.com ***

[Roy]

Thanks for the post Eliyahu, I only wish it were so easy. :)

The field value is external to the datagrid.
*** Sent via Developersdex http://www.developersdex.com ***

[Roy]

Thanks for the post Elton, but the hyperlinkcolumn can only pass single
parameters. I need to pass 5, hence, the templatecolumn.

*** Sent via Developersdex http://www.developersdex.com ***

[Eliyahu Goldin]

I am afraid you missed the point. DataItem property refers to the data
record used for populating the grid. The record is not a part of the grid.
It is what the grid gets column values from.

Eliyahu

"Roy" <SP*******@gmai l.com> wrote in message
news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..

Thanks for the post Eliyahu, I only wish it were so easy. :)

The field value is external to the datagrid.
*** Sent via Developersdex http://www.developersdex.com ***

[Elton W]

In datagrid_ItemDa taBound event, you can also rebiuld hyperlinkcolumn 's url
and pass 5 parameters to it.

HTH

Elton

"Roy" wrote:

Thanks for the post Elton, but the hyperlinkcolumn can only pass single
parameters. I need to pass 5, hence, the templatecolumn.

*** Sent via Developersdex http://www.developersdex.com ***

[Elton W]

In datagrid_ItemDa taBound event, you can also rebiuld hyperlinkcolumn 's url
and pass 5 parameters to it.

HTH

Elton

"Roy" wrote:

Thanks for the post Elton, but the hyperlinkcolumn can only pass single
parameters. I need to pass 5, hence, the templatecolumn.

*** Sent via Developersdex http://www.developersdex.com ***