【转载】C#:OleDbDataAdapter
OleDbDataAdapter类是对数据库系统运行各种操作的一个一般性的类,包括数据的插入、删除、更新等操作。
实例
strSQL = "select * from [Summary] where TFBH='" + strTFBH + "'";
OleDbDataAdapter DbDa = new OleDbDataAdapter(strSQL, myConnection);
OleDbCommandBuilder cb = new OleDbCommandBuilder(DbDa);
DbDa.InsertCommand = cb.GetInsertCommand();
DbDa.UpdateCommand = cb.GetUpdateCommand();
DbDa.DeleteCommand = cb.GetDeleteCommand();
DataTable dt = new DataTable();
DbDa.Fill(dt);
if (dt.Rows.Count == 0)
{
DataRow dr1 = dt.NewRow();
// Update data
dr1["TFBH"] = strTFBH;
dt.Rows.Add(dr1);
}
DataRow dr = dt.Rows[0];
if (dr != null)
{
.............
}