connect to SQLite

4 posts, 0 answers
  1. Puffeltje
    Puffeltje avatar
    3 posts
    Member since:
    Jun 2015

    Posted 19 Mar Link to this post

    Have someone tried to connect the ganttview with a SQLite database?
  2. Hristo
    Admin
    Hristo avatar
    716 posts

    Posted 21 Mar Link to this post

    Hi Puffeltje,

    Thank you for writing.

    RadGanttView utilizes the standard WinForms data binding mechanism. In our documentation, we have an example of binding to a SQL Server database: Binding to Database.

    With SQLite, it should not be any different as long as you have a connection to a proper database. I think you might find the following resources helpful: 
    I hope this helps. Please let me know if you need further assistance.

    Regards,
    Hristo Merdjanov
    Telerik
    Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Puffeltje
    Puffeltje avatar
    3 posts
    Member since:
    Jun 2015

    Posted 21 Mar in reply to Hristo Link to this post

    i don't managed to get it working. First i tried it with SQLite. After this i tried it with an microsoft access database file (weddingplanner.mdb (from http://www.telerik.com/forums/looking-for-weddingplanner-mdb)

    i managed to create a dataconnection in the server explorer (VB2010). When i fill 'datasource' with this dataconnection an dataset (weddingplannerdataset) and bindingsource (weddingplannerdatasetbindingsource) are created. Now i can fill 'linkdatamember' and taskdatamember' with the tablenames. But when i try to fill the other member (p.e. linkstartmember, linktypemember, linkendmember) i see no fieldnames in the dropdownlists.

     

    Because i have the same result with accessdatabase and SQLite database i think i am doing something wrong. I also tried it on an fresh installed version of windows with the same result.

  5. Hristo
    Admin
    Hristo avatar
    716 posts

    Posted 22 Mar Link to this post

    Hello Puffeltje,

    Thank you for writing back.

    It appears that the missing values in the drop-down are caused by a limitation of the designer in Visual Studio. RadGanttView will be working with two tables coming from the data source, and the designer cannot decide which fields to populate for each of the drop-downs.

    In order to achieve your task simply put the columns names in the editors. Since you are working with the database as per our documentation article, please make sure that you put the same fields as described here.

    I hope this helps. Should you have further questions please do not hesitate to write back.

    Regards,
    Hristo Merdjanov
    Telerik
    Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Back to Top