Wince无法打开数据库
代码如下:
static string SysPath = @"\Application Data";
//指定数据库
static string ConnectionString = "DataSource=" + Path.Combine(SysPath ,"BetteryPDA.sdf");
private static int ExecuteNonQuery(string SQLString, bool isUseTrans)
{
int res = 0;
using (SqlCeConnection connection = new SqlCeConnection(ConnectionString))
{
if (isUseTrans)
{
using (SqlCeTransaction trans = connection.BeginTransaction())
{
using (SqlCeCommand cmd = new SqlCeCommand(SQLString, connection, trans))
{
try
{
connection.Open();
res = cmd.ExecuteNonQuery();
trans.Commit();
}
catch (SqlCeException se)
{
trans.Rollback();
connection.Close();
res = 0;
ExceptionMemo(se);
}
}
}
}
else
{
using (SqlCeCommand cmd = new SqlCeCommand(SQLString, connection))
{
try
{
connection.Open();
res = cmd.ExecuteNonQuery();
}
catch (SqlCeException se)
{
connection.Close();
ExceptionMemo(se);
}
}
}
}
return res;
}
执行到connection.Open();的时候,就跳出异常,数据库无法打开,异常信息是空的。啥都没有!
数据库的路径也正确。
另外需要说一点的是,用这个代码连上过数据库,做过插入操作!
请教高人,如何整?