SQLite执行SQL出现IO异常
Mobile6 SQLite版本1.0.65,数据连接没问题.可以执行查询操作.但是更新或修改时就会抛出Some kind of disk I/O error occurred
disk I/O error异常,请知道这个问题的高手解读下.不胜感激.
sql= Update TELE_TASKDATA_POI SET X=0.672433519117736,Y=0.89950975677907,STATE=1 where id='200655000100002124';
这条语句单独到数据库中执行没有问题.
public int ExecuteSql(string SQLString)
{
using (SQLiteConnection connection = MenageDBConnect.GetConnection())
{
// using (SQLiteCommand cmd = new SQLiteCommand(SQLString, connection))
using (SQLiteCommand cmd = new SQLiteCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
connection.Close();
return rows;
}
catch (System.Data.SQLite.SQLiteException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}