lundi 14 mars 2016

SQLite3 Error: Unable Open Databese File

This is my first application with sqlite3 i am using finishar.sqlite everything perfect but i realesed my app's beta version. Users reported this error. "unable to open database."

But some user's computers and my computer working clearly with app.

I tried this,

  public static DataTable veriAl(string sqliteKomut)
    {
        DataTable dt = new DataTable();
        using (SQLiteConnection sqlCon = new SQLiteConnection("Data Source=" + Application.StartupPath + "\\Veri\\tkt.db;Version=3;New=False;Compress=True;UTF8Encoding=True;DateTimeFormat=CurrentCulture"))
        {
            sqlCon.Open();
            sqlDa = new SQLiteDataAdapter(sqliteKomut, sqlCon);
        }
        sqlDa.Fill(dt);
        return dt;
    }

and this style codes

 SQLiteConnection sqlCon = new SQLiteConnection("Data Source=" + Application.StartupPath + "\\Veri\\tkt.db;Version=3;New=False;Compress=True;UTF8Encoding=True;DateTimeFormat=CurrentCulture");
 public static DataTable veriAl(string sqliteKomut)
    {
        DataTable dt = new DataTable();

        sqlCon.Open();
        sqlDa = new SQLiteDataAdapter(sqliteKomut, sqlCon);
        sqlCon.Close();

        sqlDa.Fill(dt);
        return dt;
    }

Aucun commentaire:

Enregistrer un commentaire