jeudi 13 août 2015

How to insert data into Sqlite database using c#

I want to insert data into sqlite database in c#. I am using Win Forms. I got an Exception 'FileLoadException'.

SQLiteConnection con = new SQLiteConnection(@"Data Source=c:\\sqlite\\mySqliteDb.sqlite;Version=3;New=True;Compress=True;");



private void InsBtn_Click(object sender, EventArgs e)
{
            try
            {

                con.Open();
                string Query = "insert into sqliteDb values('"+this.textBox1.Text + "','" + this.textBox2.Text + "')";

                SQLiteCommand cmd = new SQLiteCommand(Query,con);
                cmd.ExecuteNonQuery();
                con.close();
            }
            catch (Exception ex) 
            {
                MessageBox.Show(ex.Message);
            }
}

Aucun commentaire:

Enregistrer un commentaire