I'm trying to update changes made in a dataset to an existing .dbf file. But I can't figure it out. I connect to the file via ODBC connection and the updates to the DataSet works fine but then i can't save the changes to the dbf. My code is shown below.
Expand|Select|Wrap|Line Numbers
- m_connstr = @"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;dBQ=" + filedirectory;
- OdbcConnection conn = new OdbcConnection(m_connstr);
- conn.Open();
- OdbcDataAdapter DataAdapter = new OdbcDataAdapter(@"SELECT * FROM DBFfile" ,conn);
- DataSet VariableSet = new DataSet();
- DataAdapter.Fill(VariableSet);
- VariableSet.AcceptChanges();
Expand|Select|Wrap|Line Numbers
- OdbcCommandBuilder cmd = new OdbcCommandBuilder(DataAdapter);
- DataAdapter.UpdateCommand = cmd.GetUpdateCommand();
- DataAdapter.Update(VariableSet);
If i try to make my own update command i fail aswell. I think it shuold look something like this
Expand|Select|Wrap|Line Numbers
- string updateString = @"UPDATE variable SET NAME = hi, TYPE = hello WHERE NAME = Test";
- OdbcCommand cmd = new OdbcCommand(updateString,conn);
- DataAdapter.UpdateCommand = cmd;
- DataAdapter.Update(VariablSet);