How query a command in SQLite with error report to MessageBox

Question

How do it? I spent 20 minutes searching it, but finded how to query a command, but is buggly. I use System.Data.SQLite

try 
{ 

    SQLiteConnection cnn = new SQLiteConnection(label2.Text); 
    cnn.Open();//Error is here! 
    SQLiteCommand cmd = cnn.CreateCommand(); 
    cmd.CommandText = textBox1.Text; 
    cmd.ExecuteNonQuery(); MessageBox.Show("Query is good!"); 
    cnn.Close();

} 
catch (SQLiteException ee) 
{ 
    MessageBox.Show(ee.Message);
}

try { SQLiteConnection cnn = new SQLiteConnection(label2.Text); cnn.Open();//Error is here! SQLiteCommand cmd = cnn.CreateCommand(); cmd.CommandText = textBox1.Text; cmd.ExecuteNonQuery(); MessageBox.Show("Query is good!"); cnn.Close(); } catch (SQLiteException ee) { MessageBox.Show(ee.Message); } — GAMELASTER
– GAMELASTER, Commented Feb 23, 2013 at 19:52
ERROR: Invalid ConnectionString format for part "D:\myserver\resources\default\scriptfiles\server.db", no equal sign found but, i dont know, if try function :D — GAMELASTER
– GAMELASTER, Commented Feb 23, 2013 at 19:53

GʀᴜᴍᴘʏCᴀᴛ · Accepted Answer · 2016-08-04 14:36:52Z

2

You probably forgot the data source before your path

@"data source=C:\mydb.db"

edited Aug 4, 2016 at 14:36

GʀᴜᴍᴘʏCᴀᴛ

9,08620 gold badges91 silver badges165 bronze badges

answered Aug 4, 2016 at 13:56

Gammed

814 bronze badges

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

Comments

Derek · Accepted Answer · 2013-02-23 20:02:49Z

0

You just need to use the prefix @ character to rid issues of special characters, or you can just add escape caharacters :-

@"D:\myserver\resources\default\scriptfiles\server.db"



"D:\\myserver\\resources\\default\\scriptfiles\\server.db"

edited Feb 23, 2013 at 20:02

answered Feb 23, 2013 at 19:55

Derek

8,68813 gold badges61 silver badges94 bronze badges

1 Comment

GAMELASTER Over a year ago

But fixed! I must add before a url this: "URI=File:"

Collectives™ on Stack Overflow

How query a command in SQLite with error report to MessageBox

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related