這是datagridview里的資料
這是匯出的mdb檔案，可以看到上面圖中紅框內的行都沒有了。
我也不清楚什么情況下會出現這個問題，但不是每次匯出都有問題。求大佬幫忙看看，多謝了。
用的代碼：
private void datatableToMdb(string FileFullName)
{
//Import the datatable into the table in .mdb file
string strCon = " Provider = Microsoft.ace.OLEDB.12.0 ; Data Source =" + FileFullName;
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();
try
{
string name = "TS_Tags";//表的名字
string sql = "create table " + name;
string tableAttribute = "";
DataTable dt = clsGVar.dtTag;//datatable的名字
for (int i = 0; i < dt.Columns.Count; i++)
{
tableAttribute = tableAttribute + dt.Columns[i].ColumnName + " " + getType(dt.Columns[i].DataType.ToString());
if (i < dt.Columns.Count - 1)
{
tableAttribute += ",";
}
}
sql = sql + "(" + tableAttribute + ");";
OleDbCommand cmd = new OleDbCommand(sql, myConn);
cmd.ExecuteNonQuery();
string strCom = string.Format("select * from {0}", name);
OleDbDataAdapter da = new OleDbDataAdapter(strCom, myConn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da)
{
QuotePrefix = "[",
QuoteSuffix = "]"
};
DataSet midData = new DataSet();
da.Fill(midData, name);
foreach (DataRow dR in dt.Rows)
{
DataRow dr = midData.Tables[name].NewRow();
dr.ItemArray = dR.ItemArray;
midData.Tables[name].Rows.Add(dr);
}
da.Update(midData, name);
myConn.Close();
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
myConn.Close();
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/277934.html
標籤：C#