hello,i'm a new sqlite study,
i have problem in system.data.sqlite of C#
the data source has connected ,
but sqlcom.ExecuteReader() there has error : no such table:dsz_insured; but
i have this table in the test.db
the code is :
public SQLiteConnection GetCon()
{
string strFilePath = @"Data Source=E:\sqlite3\test.db";
string strCon = strFilePath +
";Pooling=true;FailIfMissing=false";
SQLiteConnection sqliteCon = new SQLiteConnection(strCon);
return sqliteCon;
}
private void button1_Click(object sender, EventArgs e)
{
SQLiteConnection conn = GetCon();
conn.Open();
string sqlc = "select clausetype from dsz_insured where
amount='50000'";
SQLiteCommand sqlcom = new SQLiteCommand(sqlc, conn);
//System.Data.SQLite.SQLiteDataReader reader =
sqlcom.ExecuteReader();
SQLiteDataReader reader = sqlcom.ExecuteReader();
label1.Text = reader.ToString();
}
<http://sqlite.1065341.n5.nabble.com/file/n74698/20140325091101.jpg>
sorry i'm poor in english.
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/no-such-table-error-tp74698.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
