Question

OleDbConnection _connection = new OleDbConnection();
        StringBuilder ConnectionString = new StringBuilder("");
        ConnectionString.Append(@"Provider=Microsoft.Jet.OLEDB.4.0;");
        ConnectionString.Append(@"Extended Properties=Paradox 5.x;");
        ConnectionString.Append(@"Data Source=C:ClientsRailWheelsets;");
        _connection.ConnectionString = ConnectionString.ToString(); 
        _connection.Open();
        OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM Vehicles;", _connection);
        DataSet dsRetrievedData = new DataSet();
        da.Fill(dsRetrievedData);   
        OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
        da.InsertCommand = builder.GetInsertCommand();
        ////Insert new row
        DataRow rowNew = dsRetrievedData.Tables[0].NewRow();
        rowNew[dsRetrievedData.Tables[0].Columns[0].ColumnName] = "978";
        rowNew[dsRetrievedData.Tables[0].Columns[1].ColumnName] = "222";
        rowNew[dsRetrievedData.Tables[0].Columns[4].ColumnName] = "999";
        rowNew[dsRetrievedData.Tables[0].Columns[5].ColumnName] = "999";
        rowNew[dsRetrievedData.Tables[0].Columns[6].ColumnName] = "999";
        dsRetrievedData.Tables[0].Rows.Add(rowNew);
        dsRetrievedData.Tables[0].AcceptChanges();
        dsRetrievedData.AcceptChanges();
        int result = da.Update(dsRetrievedData);

thats the code i use. as you can see i have a paradox table. and some how result = 0 at end of it all. any ideas what is my mistake?

亲爱。

-=Noam=

Answer 1

你们的加入是什么?

在拆除这两条线后,还试图拆除这条线。

dsRetrievedData.Tables[0].AcceptChanges();
dsRetrievedData.AcceptChanges();

您对数据表的所有改动都被接受,因此没有变化的行文,因此没有更新数据。

Answer 2

移至<代码>AcceptChanges():

dsRetrievedData.Tables[0].AcceptChanges();
dsRetrievedData.AcceptChanges();

根据MSDN :

Commits all the changes made to this DataSet since it was loaded or since the last time AcceptChanges was called.

这意味着,它标志着新增加的行文为<代码>而不是新的。

友情链接