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