a radgrid like excel sheet

[saba]

hi there ,
i have a database with 2 tables on it,one of 'em is used for Rows(TRows) and onother for Columns(TColumns).one table for Values too.(TValues)
i want to radgrid to be like an excel sheet ,and i want to load columns from TColumns and rows from TRows.then set values from TValues.

can i do that?? is it possible?


if it has onother solution please help me.
thanks.

[Radoslav]

Hello Saba,

The RadGrid is a component that displays data obtained from a database or other data source. The data is presented in tabular view.
When binding a grid by setting the DataSource property, you can set the DataSource property to an instance of any of the following types:

• DataSet, DataTable, or DataView
• Array of DataRow
• Any object collection that implements the IListSource, IList, IEnumerable, or ICustomTypeDescriptor interface.

To achieve the desired functionality you could try using the Advanced Data-binding (using NeedDataSource event)  and create a new DataTable with Columns created from TColumn table, Rows from TRows table and values from TValues table. Then assign the new DataTable to the RadGrid.DataSource property.

I hope this helps.

All the best,
Radoslav
the Telerik team