C# - Access SQLite database for WPF application

Question

I have create Set up file for WPF application and the database is SQLite DB. After the installation the SQLite DB is located this path in C folder,

C:\Program Files (x86)\myCompany\myScanApp.

Then I have written connection string like this way for establishing a connection to SQLite DB,

static SQLiteConnection dbConnection = new SQLiteConnection(@"Data Source=C:\Program Files (x86)\myCompany\myScanApp\test.s3db;");

Then I have created a Setup file again and then run this application on another PC. But, it is failing to run in the PC. How can I access DB in application?

What does “failing to run” mean? It's throwing an exception? You need to tell us the exception. Also, `C:\Program Files (x86)` is typically not a place the user can or wants to change; if you expect users to change your database you should copy it to a place the user can change. — Dour High Arch
– Dour High Arch, Commented Aug 16, 2020 at 20:49

Community · Accepted Answer · 2020-08-16 20:38:07Z

3

using(SQLiteConnection conn= new SQLiteConnection(@"Data Source=C:\Program Files (x86)\myCompany\myScanApp\test.s3db;"))
{
    conn.Open();

    SQLiteCommand command = new SQLiteCommand("Select * from yourTable", conn);
    SQLiteDataReader reader = command.ExecuteReader();

    while (reader.Read())
       Console.WriteLine(reader["YourColumn"]);

 
    reader.Close();
}

Something like this should work. Here whole article Getting started with SQLite in C#

edited Aug 16, 2020 at 20:38

CommunityBot

11 silver badge

answered Nov 12, 2016 at 10:04

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

lashja Over a year ago

Hi I have also written this connection sting, but it caused error when I am trying to run applications after installation. How can I ?

mybirthname Over a year ago

@AbhilashJA Causing error doesn't mean anything to me. connectionstrings.com/sqlite here article about connection strings. Don't use static connection string also ! The whole code here is part of a Method.

lashja Over a year ago

Yes. Right... it's working. I did write connection string like this:- public SQLiteConnection dbConnection = new SQLiteConnection(@"Data Source=C:\Program Files (x86)\hedronix\qScan\test.s3db;"); Thanks.

mybirthname Over a year ago

@AbhilashJA okay if it is working make the answer correct

Collectives™ on Stack Overflow

C# - Access SQLite database for WPF application

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related