Hi,
OleDbConnection m_cnADONewConnection = new OleDbConnection();
OleDbDataAdapter m_daDataAdapter = new OleDbDataAdapter();
DataTable m_dtBackups = new DataTable();
// Connect:
string path = Application.StartupPath + @"\";
m_cnADONewConnection.ConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "backup.mdb";
m_daDataAdapter =
new OleDbDataAdapter("Select * From backups",m_cnADONewConnection);
OleDbCommandBuilder m_cbCommandBuilder = new
OleDbCommandBuilder(m_daDataAdapter);
m_daDataAdapter.Fill(m_dtBackups);
// trying to update:
for (int i=0; i < m_dtBackups.Rows.Count; i++)
{
m_dtBackups.Rows[i]["name"]= "test!";
// Problem here:
m_daDataAdapter.Update(m_dtBackups);
}
How correctly to update?