connect to SQLite

[Puffeltje]

Have someone tried to connect the ganttview with a SQLite database?

[Hristo]

Hi ,

Thank you for writing.

RadGanttView utilizes the standard WinForms data binding mechanism. In our documentation, we have an example of binding to 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: 

• http://www.c-sharpcorner.com/UploadFile/5d065a/how-to-use-and-connect-sqlite-in-a-window-application/
• http://stackoverflow.com/questions/5786817/how-to-embed-sqlite-in-a-windows-form-application
  

I hope this helps. Please let me know if you need further assistance.

Regards,
Hristo Merdjanov
Telerik

[Puffeltje]

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.

[Hristo]

Hello ,

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