Data Binding - ASP 2.0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dm1608 - 13 Feb 2006 22:17 GMT

I'm binding a column to a datagrid and would like to convert the column to
uppercase.

I notice that if I edit the GridView column, I can add formatting such as
{0:d} and {0:c} to the data item.

How can I convert this item to Uppercase?

I suppose I could do it via SQL, but I want to know how to do it using code.

Thanks

Reply to this Message

Flinky Wisty Pomm - 14 Feb 2006 09:22 GMT

If you want formatting that isn't covered by the format strings, your
best bet is to handle the databinding events of your GridView.

<code>

protected void MyGridView_RowDataBound(object sender,
GridViewRowEventArgs e)
{
const myUppercaseColumnIndex = 1;
// don't handle headers or footers
if(e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[myUppercaseColumnIndex].Text =
e.Row.Cells[myUp..].ToUpper();
}
}

</code>

Reply to this Message

dm1608 - 14 Feb 2006 15:06 GMT

Thanks for the response.

I have a couple issues though --

1) It didn't like the const line. Something about the = sign and receiving
an "no identifier" message. I simply hardcoded the column for now.

2) Apparently the ToUpper() function is not part of the Cell class or
whatever. No worky??

Also, where did you obtain the Grid events info, etc? Are there any books
that reference how to do all these things.

This is really cool stuff.

Thanks

> If you want formatting that isn't covered by the format strings, your
> best bet is to handle the databinding events of your GridView.
[quoted text clipped - 14 lines]
>
> </code>

Reply to this Message

Data Binding - ASP 2.0

Free Magazines