{
OleDbConnection?con?=?new?OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data?source=Data.MDB;Persist?Security?Info=False;Jet?OLEDB:Database?Password=");
try
{
con.Open();
OleDbDataAdapter?Bada?=?new?OleDbDataAdapter("SELECT?*?FROM?TotalData?where?1?=2",?con);//建立壹個DataAdapter對象
OleDbCommandBuilder?cb?=?new?OleDbCommandBuilder(Bada);//這裏的CommandBuilder對象壹定不要忘了,壹般就是寫在DataAdapter定義的後面
cb.QuotePrefix?=?"[";
cb.QuoteSuffix?=?"]";
DataSet?ds?=?new?DataSet();//建立DataSet對象
Bada.Fill(ds,?"demo");//填充DataSet
foreach?(DataRow?tempRow?in?temp.Rows)
{
DataRow?dr?=?ds.Tables["demo"].NewRow();
dr.ItemArray?=?tempRow.ItemArray;//行復制
ds.Tables["demo"].Rows.Add(dr);
}
Bada.Update(ds,?"demo");//用DataAdapter的Update()方法進行數據庫的更新
}
catch?(Exception?ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
con.Close();
}
}