Unable to open the database file

2012-01-17 02:12:44 522 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SQLite3: Unable to Open Database File db 文件夹也要有写权限原文如下： http://jaux.net/2008/12/18/sqlite3-unable-to-open-database-file/ Recently, I’m working on my Skypiea project which is powered by SQLite3 and Python (as CGI script). Ye... 阅读详情

/// <summary>
/// 获取当前系统程序根目录的路径
/// </summary>
/// <returns></returns>
public static string GetRootPath()
{
string DataPath = "";
if (Environment.OSVersion.Platform.ToString() == "WinCE")
{
DataPath = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
}
else if (Environment.OSVersion.Platform.ToString() == "Win32NT")
{
DataPath = Directory.GetCurrentDirectory();
}
return DataPath;
}
/// <summary>
/// 连接字符串
/// </summary>
/// <returns></returns>
private SQLiteConnection GetConn()
{
//string connString = "data source=" + Path.GetDirectoryName(Assembly.GetExecutingAssembly ().GetName().CodeBase) + @"\Data\StudentDB.xml";
string connString = "data source=" + GetRootPath() + @"\Data\employeeinfo.xml";
SQLiteConnection conn = new SQLiteConnection(connString);
return conn;
}

这是我的连接数据库代码

下面的conn.Open();是报错的地方
/// <summary>
/// DataTable断开式读取
/// </summary>
/// <param name="sql">传sql语句</param>
/// <returns>返回dataTable对象</returns>
public DataTable ExecDataTable(string sql)
{
SQLiteConnection conn = GetConn();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}

SQLiteDataAdapter sda = new SQLiteDataAdapter(sql, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return dt;
}

请各位大虾帮我看看问题出在哪里？

...全文