VB.net, SQLite & designer mode

Comments

• alex@moons.nl

  August 2015 edited 7:00PM

  Never mind, I found the solution in a readme.txt in the folder: FRNetConnections\Extras\Connections\FastReport.SQLite\readme.txt
  

  wrote:

  SQLite data connection for FastReport.Net

  ---

  
  
  How to compile:

  ---

  
  - you need the SQLite .Net Data Provider to be installed. Obtain it
  at [url="http://sqlite.phxsoftware.com;"; ] http://sqlite.phxsoftware.com;[/url]
  - open the .sln file;
  - fix the "FastReport.dll" reference. By default, this dll is located in the
  "C:\Program Files\FastReports\FastReport.Net Demo" folder;
  - check that "System.Data.SQLite.dll" reference is correct.
  If Visual Studio complains about it, fix this reference as well;
  - compile the project. You will get the "FastReport.SQLite.dll" file.
  
  
  How to register this dll in FastReport:

  ---

  
  You can do it in several ways:
  
  1) register using the FastReport IDE
  - open the report designer;
  - go "View|Options..." menu;
  - on the "Plugins" tab, add the FastReport.SQLite.dll;
  - restart FastReport. If you are working in the Visual Studio IDE, restart
  it as well;
  
  2) edit manually the FastReport.config file
  - by default, this file is located in the "C:\Documents and Settings\user_name\
  Local Settings\Application Data\FastReport" folder;
  - close any running instances of FastReport.Net;
  - open the config file in any text editor and modify it in the following way:
  <?xml version="1.0" encoding="utf-8"?>
  <Config>
  ...
  <Plugins>
  <Plugin Name="c:\.....\FastReport.SQLite.dll"/>
  </Plugins>
  </Config>
  
  3) register the dll programmatically
  - add the "FastReport.SQLite.dll" reference to your project;
  - execute the following code once at the application start:
  FastReport.Utils.RegisteredObjects.AddConnection(typeof(SQLiteDataConnection));
  
  
  How to use it:

  ---

  
  - now you should be able to create a new SQLite data source in the
  "Data|Add Data Source..." menu.