Get RadGrid output as Dataset

[Pierre]

Hi,

I searching one solution to export current modified RadGrid in one dataset to use in some custom code c#. Thanks for u.help. 

[Sean]

No one can answer this question??

[Daniel]

Hello Sean,

You can traverse the items/columns and build the desired DataTable/DataSet if this is what you are after.

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);

    DataTable table = new DataTable();
    foreach (GridColumn col in RadGrid1.MasterTableView.RenderColumns)
    {
        if (col.Visible)
        {
            table.Columns.Add(col.UniqueName);
        }
    }

    foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
    {
        List<string> list = new List<string>();
        foreach (DataColumn column in table.Columns)
        {
            list.Add(item[column.ColumnName].Text);
        }
        table.Rows.Add(list.ToArray());
    }
}

Regards,
Daniel
Telerik