Database Structure SQl code to C# code

16 posts, 0 answers
  1. Jakub
    Jakub avatar
    2 posts
    Member since:
    Jul 2014

    Posted 09 Jul 2014 Link to this post

    Hi.
    I have a problem, because I want to change code SQL to code C#.

    I'm creating 2 Tables and.... 

    DataSet ds = new DataSet("Gantt");
            ds.Tables.Add(dt);
            ds.Tables.Add(gd);
            //RadGantt1.DataSource = ds;
            //RadGantt1.DataSourceID = null;
            //RadGantt1.Data
            //RadGantt1.DataSourceID = "GanttTasks";
            RadGantt1.DataSource = ds;
            //RadGantt1.DataSourceID = "GanttTasks";
            //RadGantt1.DependenciesDataSource = gd;
            //RadGantt1.DependenciesDataSourceID = "GanttDependencies";

    Actually problem:
    Telerik.Web.UI.Gantt.GanttDataSourceException: DependenciesDataSourceID may not be null in case of DataSource binding. So I changed last line, but I have another problem.
    What I should do now?







  2. Bozhidar
    Admin
    Bozhidar avatar
    1189 posts

    Posted 11 Jul 2014 Link to this post

    Hi Jakub,

    With the current beta version of the RadGantt binding directly through the DataSource property is not supported. You have to bind the Gantt either declaratively through the DataSourceID property, or through a provider:
    http://www.telerik.com/help/aspnet-ajax/gantt-data-binding-declarative-binding.html
    http://www.telerik.com/help/aspnet-ajax/gantt-data-binding-xml-provider.html

    We will do our best to provide support for this kind of binding in the upcoming Q3 release.

    Regards,
    Bozhidar
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. Khushboo
    Khushboo avatar
    10 posts
    Member since:
    Jan 2014

    Posted 16 Jul 2014 in reply to Bozhidar Link to this post

    Hi,

    will this not support in 2014.2.618.45 version of telerik.... i mean wen am binding from code behind:
    radgantt1.datasource=query;
    radgantt.DependenciesDataSource = company;
    radgantt1.Databind();

    its throwing same exception 
  4. Bozhidar
    Admin
    Bozhidar avatar
    1189 posts

    Posted 16 Jul 2014 Link to this post

    Hi,

    This is the same scenario, and as stated previously, it's currently not supported.

    Regards,
    Bozhidar
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  5. Khushboo
    Khushboo avatar
    10 posts
    Member since:
    Jan 2014

    Posted 16 Jul 2014 in reply to Bozhidar Link to this post

    hi,

    Can i have start and end field of other datatype than to have datetime only?? like i want to show as day 0,day 1,day 2..........
  6. Bozhidar
    Admin
    Bozhidar avatar
    1189 posts

    Posted 16 Jul 2014 Link to this post

    Hello,

    The Start and End fields must be of type DateTime, and binding them to other types is not supported.

    Regards,
    Bozhidar
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  7. Khushboo
    Khushboo avatar
    10 posts
    Member since:
    Jan 2014

    Posted 20 Jul 2014 in reply to Bozhidar Link to this post

    Hi Bozidhar,

    Can i use asp:ObjectDataSource control for binding radgantt?
  8. Khushboo
    Khushboo avatar
    10 posts
    Member since:
    Jan 2014

    Posted 21 Jul 2014 in reply to Bozhidar Link to this post

    Hi Bozidhar,

    In addition to radgantt demo columns i want few more columns like companyName but its not displaying

  9. Hristo Valyavicharski
    Admin
    Hristo Valyavicharski avatar
    975 posts

    Posted 23 Jul 2014 Link to this post

    Hi Khushboo,

    Yes the Gantt control can be bound to ObjectDataSource. 

    Custom Columns functionality is implemented and will be included in the upcoming Service Pack. It is expected to be released in the end of the week.

    Regards,
    Hristo Valyavicharski
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  10. Ray
    Ray avatar
    115 posts
    Member since:
    Mar 2009

    Posted 26 Jul 2014 in reply to Hristo Valyavicharski Link to this post

    "Yes the Gantt control can be bound to ObjectDataSource. 
    Custom Columns functionality is implemented and will be included in the upcoming Service Pack. It is expected to be released in the end of the week."

    Does not work, even after hacking code to match your objectdatasource!!!

  11. Dimitar Terziev
    Admin
    Dimitar Terziev avatar
    1268 posts

    Posted 31 Jul 2014 Link to this post

    Hi Ray,

    Attached is a sample project demonstrating how to bind the RadGantt to an ObjectDataSource component.

    Regarding the custom columns, could you clarify whether you experience any problems with them or the problems are related to the ObjectDataSource binding?

    Regards,
    Dimitar Terziev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  12. Ray
    Ray avatar
    115 posts
    Member since:
    Mar 2009

    Posted 01 Aug 2014 in reply to Dimitar Terziev Link to this post

    The columns are working, but the binding to the data source is not..
    Linqdatsource was working as well, but same old broken datasource bindings..

  13. Bozhidar
    Admin
    Bozhidar avatar
    1189 posts

    Posted 04 Aug 2014 Link to this post

    Hi Ray,

    Please clarify whether the sample is not working out of the box, or after making some changes to it. If so, please paste the exact changes so that we can investigate. I would also like to remind you that implementing the CRUD operations through the events is currently not supported and will be included in the next official release.

    Regards,
    Bozhidar
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  14. Tomasz Tarczewski
    Tomasz Tarczewski avatar
    10 posts
    Member since:
    Nov 2006

    Posted 15 Jun 2016 Link to this post

    Hi Bozhidar

    I know that this topic is old but are you currently support binding mentioned by Jacob two years ago?

    Regards

  15. Bozhidar
    Admin
    Bozhidar avatar
    1189 posts

    Posted 16 Jun 2016 Link to this post

    Hi,

    Yes, binding to a DataSet and using the Server events for CRUD operations is supported in the current version of the Gantt control.

    For convenience I'm also attaching a small sample page demonstrating how you can bind the Gantt to a Session stored list of objects.

    Regards,
    Bozhidar
    Telerik
  16. Tomasz Tarczewski
    Tomasz Tarczewski avatar
    10 posts
    Member since:
    Nov 2006

    Posted 16 Jun 2016 Link to this post

    Thank you very much Bozhidar. I appreciate your commitment.
Back to Top