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("修整轮名称重复", "信息提示");
}
}
catch中加上
MessageBox.Show(ex.Message)看下具体错误信息
是不是违法了约束,或者主键重复之类的错误
SQL2008里面 需要执行以下才能看到修改之后的数据, 不知道Microsoft.Jet.OleDb需不需要执行以下