2,209
社区成员
发帖
与我相关
我的任务
分享
SQLiteConnection conn = new SQLiteConnection("Data Source =" + DB_PATH + "");
try
{
conn.Open();
SQLiteDataAdapter dataadapter1 = new SQLiteDataAdapter("Select * From " + tableName + " where id=" + prjID, conn);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, tableName);
DataRow datarow1;
datarow1 = dataset1.Tables[tableName].Rows[0];
//表进行更新
datarow1["name"] = prjName;
datarow1["mark"] = prjMark;
datarow1["size"] = prjSize;
datarow1["path_dlg"] = dlgPath;
datarow1["path_dom"] = domPath;
datarow1["path_dem"] = demPath;
datarow1["date_create"] = DateTime.Now.ToString();
datarow1["path_mxd"] = mxdPath
SQLiteCommandBuilder cb = new SQLiteCommandBuilder(dataadapter1);
dataadapter1.Update(dataset1, tableName);//就是这一句,到这就报错!
SQLiteConnection conn = new SQLiteConnection("Data Source =" + ms + "");
try
{
conn.Open();
SQLiteDataAdapter dataadapter1 = new SQLiteDataAdapter("Select * From " + tableName + " where id=" + 4048, conn);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, tableName);
DataRow datarow1;
datarow1 = dataset1.Tables[tableName].Rows[0];
datarow1["name"] = "prjName";
datarow1["mark"] = "prjMark";
datarow1["size"] = "1000";
datarow1["path_dlg"] = "dlgPath";
datarow1["path_dom"] = "domPath";
datarow1["path_dem"] = "demPath";
datarow1["name_files"] = "files";
datarow1["path_mxd"] = "mxdPath";
datarow1["date_create"] = DateTime.Now.ToString();
SQLiteCommandBuilder cb = new SQLiteCommandBuilder(dataadapter1);
dataadapter1.Update(dataset1, tableName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示");
}
finally
{
conn.Close();
}