Browse by Tags

Crystal reports from SQLITE in Visual Studio

I am having some old crystal reports using ODBC MS Acess connection. Now I want to update my crystal report to use SQLITE database. which driver to use? which connection to use? Please Help !!!!

Posted to General (Forum) by San on 12-01-2011
Re: strange Error : no such table : ....

The same error occurs in the following situation too: You add .db file to your project. Then when you run your c# project with debugger, empty db. file is copied into bin/debug folder of the project folder. Your running application looks for tables in the empty database and returns error: "no such...

Posted to General (Forum) by sevenkul on 08-19-2011
Code First - Create Delete Database

SQLite seems to gain popularity with "Entity Framework Code First" because is the easiest ans fastest way to unit test a DbContext. But the problem is that the "Database.Delete" is not supported and the "Database.Create" does not create table. In the near futur will the...

Posted to Entity Framework (Forum) by Jimmy on 01-10-2011
Odd Select performance characteristics

As part of our application we use a SQLite database to store information about messages that are sent through Exchange. I am trying to track down some odd performance degradation. As the number of records in a particular table of the database gets into the thousands (and the database size approaches...

Posted to General (Forum) by NickHall on 01-29-2010
Creating A New Database and Structure

Hey in my program it is necessary to create a new sqlite db in the applications start up code depending on some configuration variables. So this leaves me wondering how to create the database and its internal structure such as tables and their data using .net code, either vb.net or c# .net. Also i need...

Posted to General (Forum) by alex21 on 01-14-2010
MethodMissingException Can't Find PInvoke 'SQLite3.dll'

Hello friends, i have already downloaded sqlite3 dll and placed the same in my application folder and also in my windows folder but not seem to be great. i am still getting error "MethodMissingException Can't Find PInvoke 'SQLite3.dll'" i am using sqlite3 dll but dont know why this...

Posted to General (Forum) by yrb.yogi on 05-05-2009
Using Scripts in SQLite

I have created a database and have created tables in them. I need to know how i can use scripts to query the database. Also to insert, update and delete data from those tables using scripts. i was not able to execute simple createfile as given by robert in http://sqlite.phxsoftware.com/forums/p/77/267...

Posted to General (Forum) by arunkumar.s on 11-04-2008
SQLite Database

Hi all I am totally new to SQLite. i have downloaded the necessary files from the SQLite website. I would like to know the steps to create a database. I checked a few sites, and they have mentioned $ sqlite3 test.db SQLite version 3.0.8 Enter ".help" for instructions sqlite> .quit The problem...

Posted to General (Forum) by arunkumar.s on 10-30-2008

Page 1 of 1 (8 items)