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.
    thanks.
  2. Radoslav
    Admin
    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,
    Radoslav
    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top