a radgrid like excel sheet

2 posts, 0 answers
  1. saba
    saba avatar
    6 posts
    Member since:
    Aug 2010

    Posted 20 Sep 2010 Link to this post

    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.
  2. Radoslav
    Radoslav avatar
    1564 posts

    Posted 23 Sep 2010 Link to this post

    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,
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top