62,244
社区成员




DataSet tempDt = new DataSet();
OleDbDataAdapter oDA = new OleDbDataAdapter(string.Format("Select * from [{0}$]", Property.TableName), conn);
OleDbCommandBuilder comm = new OleDbCommandBuilder(oDA);
comm.QuotePrefix = "[";
comm.QuoteSuffix = "]";
conn.Open();
int fillDs = oDA.Fill(tempDt, Property.TableName);
foreach (DataRow dr in dataTable.Rows)
{
tempDt.Tables[Property.TableName].Rows.Add(dr.ItemArray);
}
oDA.Update(tempDt, Property.TableName);