Advanced Data Binding Data Formatting

[Tim]

Dear All,

I'm using

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            RadGrid1.DataSource = GridDataSource;            
        }


to bind the grid, and in the front page (aspx) it's like

<telerik:RadGrid ID="RadGrid1" runat="server" MasterTableView-CommandItemDisplay="Top" OnNeedDataSource="RadGrid1_NeedDataSource" AllowPaging="True" AllowSorting="True" AllowFilteringByColumn="True" ShowGroupPanel="True" PageSize="20" Skin="WebBlue">
                        <ClientSettings AllowDragToGroup="True">
                            <Scrolling AllowScroll="True" UseStaticHeaders="True"></Scrolling>
                        </ClientSettings>
                    </telerik:RadGrid>

I'd just like to ask how can I set the dataformatstring = "{0:d}" to certain columns for example?

Thanks

[Princy]

Hi Tim,

I guess you are having AutoGeneratedColumns in your grid. Please try the following code snippet to set DataFormatString for columns according to their type.

C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
  foreach(GridColumn column in RadGrid1.MasterTableView.AutoGeneratedColumns)
  {
    //To set format for DateTime column
    if (column.ColumnType == "GridDateTimeColumn")
    {
     (column as GridDateTimeColumn).DataFormatString = "{0:d}";
    }
  }
  RadGrid1.Rebind();
}

Thanks,
Princy

[Tim]

Thank you very much Princy that's the solution.