How to perform functions upon 'bound' data? (asp .net)

[murdock]

Is there a way to perform functions upon databound data that is to be
used in a GridView? For example, in the following code where I am using
a GridView to display a resulting asp:SqlDataSour ce

<asp:GridView ID="GridView1" runat="server" AllowPaging="Tr ue"
AutoGenerateCol umns="False" CellPadding="4"
DataSourceID="S qlDataSource1" ForeColor="#333 333"
GridLines="None " Height="402px" Width="612px" AllowSorting="T rue"
PageSize="50">
<FooterStyle BackColor="#990 000" Font-Bold="True"
ForeColor="Whit e" />
<Columns>
<asp:BoundFie ld DataField="Fiel d1"
HeaderText="Fie ld1" SortExpression= "Field1" />
<asp:BoundFie ld DataField="Fiel d2"
HeaderText="Fie ld2" SortExpression= "Field2" />
<asp:BoundFie ld DataField="Fiel d3"
HeaderText="Fie ld3" SortExpression= "Field3" />
<asp:BoundFie ld DataField="Fiel d4"
HeaderText="Fie ld4" SortExpression= "Field4" />
<asp:BoundFie ld DataField="Fiel d5"
HeaderText="Fie ld5" SortExpression= "Field5" />
</Columns>
<SelectedRowSty le BackColor="#FFC C66" ForeColor="Navy "
Font-Bold="True" />
<PagerStyle BackColor="#FFC C66" ForeColor="#333 333"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#990 000" Font-Bold="True"
ForeColor="Whit e" />
<AlternatingRow Style BackColor="Whit e" />
<RowStyle BackColor="#FFF BD6" ForeColor="#333 333" />
</asp:GridView>

Is there something in Visual Studio 2005 Express Edition on the control
itself (somewhere in the properties) to perform an 'action' on a field
prior to insertion?

For example, if you have something formatted oddly in the dataset, and
you have a string Field1 in format "abcdefg" and you wanted to strip
"efg" before putting it into the gridview in the appropriate column.

Regards,
MurdockSE

[NathanJ]

I am not totally sure about using functions in a gridview. You can
however use functions for your bound data in a datagrid or datalist.
<%# Function(contai ner.dataitem("F ield1"), myParam) %like so. Not
sure if this helps.

-Nathan

[brians[MCSD]]

Hello MurdockSE,

You should be able to add an event handler for the RowDataBound event of the
GridView control to access row data after it is bound and before it is
rendered. Something like this:

void CustomersGridVi ew_RowDataBound (Object sender, GridViewRowEven tArgs e)
{

if(e.Row.RowTyp e == DataControlRowT ype.DataRow)
{
// Display the company name in italics.
e.Row.Cells[1].Text = "<i>" + e.Row.Cells[1].Text + "</i>";

}

}

--
enjoy - brians
http://www.limbertech.com
"mu*****@nc.rr. com" wrote:

Is there a way to perform functions upon databound data that is to be
used in a GridView? For example, in the following code where I am using
a GridView to display a resulting asp:SqlDataSour ce

<asp:GridView ID="GridView1" runat="server" AllowPaging="Tr ue"
AutoGenerateCol umns="False" CellPadding="4"
DataSourceID="S qlDataSource1" ForeColor="#333 333"
GridLines="None " Height="402px" Width="612px" AllowSorting="T rue"
PageSize="50">
<FooterStyle BackColor="#990 000" Font-Bold="True"
ForeColor="Whit e" />
<Columns>
<asp:BoundFie ld DataField="Fiel d1"
HeaderText="Fie ld1" SortExpression= "Field1" />
<asp:BoundFie ld DataField="Fiel d2"
HeaderText="Fie ld2" SortExpression= "Field2" />
<asp:BoundFie ld DataField="Fiel d3"
HeaderText="Fie ld3" SortExpression= "Field3" />
<asp:BoundFie ld DataField="Fiel d4"
HeaderText="Fie ld4" SortExpression= "Field4" />
<asp:BoundFie ld DataField="Fiel d5"
HeaderText="Fie ld5" SortExpression= "Field5" />
</Columns>
<SelectedRowSty le BackColor="#FFC C66" ForeColor="Navy "
Font-Bold="True" />
<PagerStyle BackColor="#FFC C66" ForeColor="#333 333"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#990 000" Font-Bold="True"
ForeColor="Whit e" />
<AlternatingRow Style BackColor="Whit e" />
<RowStyle BackColor="#FFF BD6" ForeColor="#333 333" />
</asp:GridView>

Is there something in Visual Studio 2005 Express Edition on the control
itself (somewhere in the properties) to perform an 'action' on a field
prior to insertion?

For example, if you have something formatted oddly in the dataset, and
you have a string Field1 in format "abcdefg" and you wanted to strip
"efg" before putting it into the gridview in the appropriate column.

Regards,
MurdockSE