Column values of a sql table as Headers in RadGrid

[Naveen kumar]

How to show a column values of a sql table as headers in radgrid ?

[Shinu]

Hi,

I'm not quite sure about your requirement. Please take a look into the sample code snippet I tried to show Customer id as the Header of the columns in RadGrid.

ASPX:

<telerik:RadGrid ID="RadGrid1" Width="95%" runat="server" OnItemCreated="RadGrid1_ItemCreated"
    OnNeedDataSource="RadGrid1_NeedDataSource1"></telerik:RadGrid>

C#:

public DataTable GetDataTable(string query)
{
    String ConnString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString3"].ConnectionString;
    SqlConnection conn = new SqlConnection(ConnString);
    SqlDataAdapter adapter = new SqlDataAdapter();
    adapter.SelectCommand = new SqlCommand(query, conn);

    DataTable myDataTable = new DataTable();

    conn.Open();
    try
    {
        adapter.Fill(myDataTable);
    }
    finally
    {
        conn.Close();
    }

    return myDataTable;
}

public DataTable PivotTable(DataTable source)
{
    DataTable dest = new DataTable("Pivoted" + source.TableName);

    dest.Columns.Add(" ");

    foreach (DataRow r in source.Rows)
        dest.Columns.Add(r[0].ToString());

    for (int i = 0; i < source.Columns.Count - 1; i++)
    {
        dest.Rows.Add(dest.NewRow());
    }

    for (int r = 0; r < dest.Rows.Count; r++)
    {
        for (int c = 0; c < dest.Columns.Count; c++)
        {
            if (c == 0)
                dest.Rows[r][0] = source.Columns[r + 1].ColumnName;
            else
                dest.Rows[r][c] = source.Rows[c - 1][r + 1];
        }
    }
    dest.AcceptChanges();
    return dest;
}

protected void RadGrid1_NeedDataSource1(object source, GridNeedDataSourceEventArgs e)
{
    RadGrid1.DataSource = PivotTable(GetDataTable("SELECT TOP 5 CustomerID, CompanyName, ContactName, ContactTitle, Address, PostalCode, City, Country FROM Customers"));
}
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        (e.Item as GridDataItem)[(RadGrid1.MasterTableView.AutoGeneratedColumns[0] as GridBoundColumn).UniqueName].Font.Bold = true;
        (e.Item as GridDataItem)[(RadGrid1.MasterTableView.AutoGeneratedColumns[0] as GridBoundColumn).UniqueName].BackColor = System.Drawing.SystemColors.Control;
        (e.Item as GridDataItem)[(RadGrid1.MasterTableView.AutoGeneratedColumns[0] as GridBoundColumn).UniqueName].BorderColor = System.Drawing.Color.White;
    }
}

Thanks,
Shinu.