------ 去掉以一些 注释掉的代码 ---------------
internal static void InsertDataToMainDB(string theMainDBFileName, DataTable newMainTbl)
{
SetConnString(theMainDBFileName);
string sqlSelectCmd = "SELECT * FROM categories WHERE (1 <> 1)";
OleDbConnection connection = new OleDbConnection(connectionString);
OleDbDataAdapter dbAdapter = new OleDbDataAdapter(sqlSelectCmd, connection);
DataSet theDataSet = new DataSet();
OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(dbAdapter);
connection.Open();
dbAdapter.Fill(theDataSet, "categories");
theDataSet.Tables["categories"].Merge(newMainTbl,false);
dbAdapter.Update(theDataSet, "categories");
theDataSet.AcceptChanges();
connection.Close();
}
internal static void InsertDataToMainDB(string theMainDBFileName, DataTable newMainTbl)
{
SetConnString(theMainDBFileName);
string sqlSelectCmd = "SELECT * FROM categories WHERE (1 <> 1)";
OleDbConnection connection = new OleDbConnection(connectionString);
OleDbDataAdapter dbAdapter = new OleDbDataAdapter(sqlSelectCmd, connection);
DataSet theDataSet = new DataSet();
OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(dbAdapter);
connection.Open();
dbAdapter.Fill(theDataSet, "categories");
theDataSet.Tables["categories"].Merge(newMainTbl,false);
dbAdapter.Update(theDataSet, "categories");
theDataSet.AcceptChanges();
connection.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货