string connstr = "Provider=Microsoft.Jet.OleDb.4.0;";
connstr += @"Data Source=D:\Merger201503016caohuan\GEARCNC.mdb";//创建连接对象
OleDbConnection tempconn = new OleDbConnection(connstr);
tempconn.Open();
OleDbDataAdapter DressingWheelDA = new OleDbDataAdapter("select * from DressingWheel order by 修整轮名称", tempconn);
DataSet ds = new DataSet();
DressingWheelDA.Fill(ds, "DressingWheel");
OleDbCommandBuilder builder = new OleDbCommandBuilder(DressingWheelDA);
if (ds.HasChanges())
{
try
{
DressingWheelDA.Update(ds, "DressingWheel");
}
catch (Exception ex)
{
MessageBox.Show("修整轮名称重复", "信息提示");
}
}