Column data doesnt show when using SQLCeResultSet

4 posts, 0 answers
  1. RobbMurdock
    RobbMurdock avatar
    20 posts
    Member since:
    Oct 2006

    Posted 05 Apr 2008 Link to this post


    I am attempting to display rows from an SQLCeResultSet.

    The rows are clearly displaying; but no column data shows.  If I use a standard Windows DataGridView is shows fine.  

    The database has three rows; and the Telerik RadGridView shows that there are three rows displayed; but the column data is not present.  I have set the column names in the designer.

    I setup the Windows DataGridView in the same manner.  It shows the column data but the RadGridView does not.

    Any ideas why ?


    Robb Murdock

    Dim oConn As New SqlServerCe.SqlCeConnection
    oConn.ConnectionString = ConnectString
    Dim oCmnd As New SqlServerCe.SqlCeCommand("select * from tblMyData", oConn)MyRadGridView.DataSource =  oCmnd.ExecuteResultSet(SqlServerCe.ResultSetOptions.Updatable + SqlServerCe.ResultSetOptions.Scrollable)


  2. Julian Benkov
    Julian Benkov avatar
    1135 posts

    Posted 07 Apr 2008 Link to this post

    Hi Robb,

    Thank you for your question.

    The RadGridView control does not support SqlCeResultSet object for direct binding.

    The good news is that our new version of RadGridView will support the GridViewTemplate object, which is used for loading data from IDataReader object. The loaded data can then be used in new unbound mode. You can test this functionality through the LoadFrom() API function in the beta edition of new RadGridView here.

    The official version of RadGridView is expected in two weeks.

    I hope this was helpful. If you have additional questions, please contact us.

    Sincerely yours,
    Julian Benkov
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. Vic
    Vic avatar
    36 posts
    Member since:
    Aug 2012

    Posted 13 May 2012 Link to this post

    Is it still the case that the wpf RadGridView does not support direct binding to SqlCeResultSet?
  4. Stefan
    Stefan avatar
    2906 posts

    Posted 16 May 2012 Link to this post


    This forum concerns RadGridView for WinForms rather than RadGridView for WPF. Please address your question in the appropriate forums in order to get adequate response.
    the Telerik team
    RadControls for WinForms Q1'12 release is now live! Check out what's new or download a free trial >>
Back to Top