Reading bounded DataItem expression text from control inside template field

Question

I have a custom gridview and I use that grid in too many pages and I want to set the SortExpression text for all columns inside that grid in code behained ; as you see in the following code I have do that by overriding the OnRowDataBound eventhandler .

The problem is I can't access the evaluated datafield expression text ("START_WORK_DATE" in my case) for template Fields like what I did in BoundField

<eska:GridView ID="gvEmployees" runat="server" CssClass="new-grid" PageSize="20"
    AllowSorting="true" AllowPaging="True" 
    AutoGenerateColumns="False" Width="100%"
    GridContainer="tdEmployees" DataKeyNames="ID" 
    RowHoverCssClass="HoverRow" ShowCheckBox="True"
    OnPageIndexChanging="gvEmployees_PageIndexChanging" 
    OnSelectedIndexChanged="gvEmployees_SelectedIndexChanged" 
    meta:resourcekey="gvEmployeesResource1">

    <PagerSettings FirstPageImageUrl="~/App_Themes/Images/First.gif" LastPageImageUrl="~/App_Themes/Images/last.gif"
        Mode="NextPreviousFirstLast" NextPageImageUrl="~/App_Themes/Images/Next.gif"
        PreviousPageImageUrl="~/App_Themes/Images/prev.gif"></PagerSettings>
    <SelectedRowStyle CssClass="SelectedRow"></SelectedRowStyle>
    <Columns>
        <asp:BoundField meta:resourcekey="BoundFieldResource1">
            <ItemStyle Width="2%" />
            <HeaderStyle Width="2%" />
            <FooterStyle Width="2%" />
        </asp:BoundField>

        <asp:BoundField  DataField="EMP_NO"  HeaderText="Employee No"
            meta:resourcekey="BoundFieldResource3">
            <HeaderStyle Width="10%"></HeaderStyle>
            <ItemStyle Width="10%"></ItemStyle>
            <FooterStyle Width="10%" />
        </asp:BoundField>

        <asp:BoundField DataField="NAME" HeaderText="Name"  meta:resourcekey="BoundFieldResource4">
            <HeaderStyle Width="34%"></HeaderStyle>
            <ItemStyle Width="34%"></ItemStyle>
            <FooterStyle Width="34%" />
        </asp:BoundField>
        <asp:TemplateField  HeaderText="Hiring Date"  meta:resourcekey="TemplateFieldResource1">

            <ItemTemplate>
<asp:Label runat="server"Text='<%# Convert.ToDateTime(DataBinder.Eval(Container,
"DataItem.START_WORK_DATE")).ToString("dd-MM-yyyy") %>'
                    ID="lblHiringDateGrid"></asp:Label>
            </ItemTemplate>
            <HeaderStyle Width="10%"></HeaderStyle>
            <ItemStyle Width="10%"></ItemStyle>
            <FooterStyle Width="10%" />
        </asp:TemplateField>

        <asp:BoundField DataField="PHONE1" HeaderText="Phone 1"
        meta:resourcekey="BoundFieldResource5">
            <HeaderStyle Width="10%"></HeaderStyle>
            <ItemStyle Width="10%"></ItemStyle>
            <FooterStyle Width="10%" />
        </asp:BoundField>
        <asp:BoundField DataField="Position_Name" HeaderText="Position"
        meta:resourcekey="BoundFieldResource6">
            <HeaderStyle Width="20%"></HeaderStyle>
            <ItemStyle Width="20%"></ItemStyle>
            <FooterStyle Width="20%" />
        </asp:BoundField>

        <asp:BoundField DataField="STATUS_DESC" HeaderText="Status"
        meta:resourcekey="BoundFieldResource7">
            <HeaderStyle Width="12%"></HeaderStyle>
            <ItemStyle Width="12%"></ItemStyle>
            <FooterStyle Width="12%" />
        </asp:BoundField>

        <asp:BoundField meta:resourcekey="BoundFieldResource8">
            <ItemStyle Width="2%" />
            <HeaderStyle Width="2%" />
            <FooterStyle Width="2%" />
        </asp:BoundField>

    </Columns>
</eska:GridView>

Code behind:

protected override void OnRowDataBound(GridViewRowEventArgs e)
    {

            if (e.Row.RowType == DataControlRowType.Header)
            {
                for (int i = 0; i < this.Columns.Count; i++)
                {

                    if (this.Columns[i] is BoundField)
                    {
                        if (((BoundField)(this.Columns[i])).DataField != string.Empty)
                        {
                            this.Columns[i].SortExpression = ((BoundField)(this.Columns[i])).DataField;
                        }
                    }
                    else if (this.Columns[i] is TemplateField)
                    {
                       // ???


                     }
                 }
             }

}

Jalpesh Vadgama Jalpesh Vadgama · Accepted Answer · 2014-04-09T10:10:59

You can do some thing like this. Set a header template with link button.

<asp:TemplateField>
        <HeaderTemplate>
            <asp:LinkButton ID="LinkButtonEmpName" runat="server" Text="Employee Name" CommandName="Sort" CommandArgument="Employees">
            </asp:LinkButton>
        </HeaderTemplate>
        <ItemTemplate>
            <asp:Label ID="LabelEmployee" runat="server" Text='<%# Bind("Employees") %>'/>
        </ItemTemplate>
        <FooterTemplate>
            <asp:TextBox ID="TextBoxEmployee" runat="server"/>
        </FooterTemplate>

And in row command event find command like this.

protected void grd_RowCommand(object sender, GridViewCommandEventArgs e){
if (e.CommandName.Equals("Sort"))
{
    FilterExpression = e.CommandArgument.ToString() + " LIKE '%" + txtCaseNumber.Text + "%'";
    BindGridView();
}}

See the complete example here.

http://www.codeproject.com/Questions/528664/HowplustoplusapplyplussortingplusinplusTemplateplu

Reading bounded DataItem expression text from control inside template field

1 Answers