SQLite 2.0 and C#

Question

Hi I have one old database type of SQLite 2.0 and I need export data but I 've got no idea how to do it. Visual studio do not (or i did not find it) have a libary that can work with this type of database. Does anybody have a idea to solve this problem? thx

Kirtan Patel · Answer

Friend Mail me the DBFile i will let you know weather its working or not send the file in mail : kirtan007@gmail.com

Kirtan Patel · Answer

Friend its Very Hard to Find Version of SQl Lite Database and We Cant Connect it Using .net Still If data Is important for you then Access it using One Utility bu it has no data Inside the file you Provided Except One Table(Clanky) with No Data just Table Structure is There Utility to Open That Data base is Download Utility and Friend Please mark  Do you like this answer  :)

Tomas · Answer

Thx Kirtan I have installed  ADO.NET 2.0 Provider for SQLite I try to connect.. DbProviderFactory fact = DbProviderFactories.GetFactory(System.Data.SQLite); using (DbConnection cnn = fact.CreateConnection()) { cnn.ConnectionString = Data Source=poradca.sdb; cnn.Open(); } and result is an exception: File opened that is not a database file file is encrypted or is not a database but file is good And file is type sqlite 2.0 thx

Kirtan Patel · Answer

Here is SQLite connector for .net that will add new name-space in your Visual Studio Download SQLite Connector.net that is System.Data.SQLite; then you can fill the DataSet From the Database and Write All DataSet Tables Rows to Some other Database :) if my answer Helped you check  Do you like this answer  please :)