ODBCDataAdapter
-
Hello, I am facing a problem in updation of data to dBaseIII database. I have to append two dBaseIII databases and insert to third database(which all the table structures are same). I have merged two datasets and tried to update the third database by using ODBCDataAdapter, I was able to see that the two datasets are merged in debugging, but when it was updated by the command ODBCDataAdapter.Update(dsDataset); the new records are not reflecting the physical dBaseIII database. I was able to select the data from the database, but not able to insert new data through C# program. The following is the code I have tried! Can any one help me to resolve this problem. adSTOERUNG = new System.Data.Odbc.OdbcDataAdapter("SELECT * FROM xyzTable",cnnST ); System.Data.Odbc.OdbcCommandBuilder builder = new System.Data.Odbc.OdbcCommandBuilder(adSTOERUNG); adSTOERUNG.Fill(DSMain,"xyzTable"); DSMain.Merge(DS2Insert.Tables[0]); adSTOERUNG.Update(DSMain.Tables[0]); The following ODBC driver I have used for connection. CollatingSequence=ASCII;SafeTransactions=0;Threads=3;Statistics=0;MaxScanRows=8;DefaultDir=c:\xyz;FILEDSN=c:\xyz\xyztable.dbf.dsn;index=code; DriverId=21; UserCommitSync=Yes;FIL=dBase III;PageTimeout=0;Driver={Microsoft dBase Driver (*.dbf)};MaxBufferSize=10000;UID=admin" Regards, Kishore.