I have a small project in c# and ms-access
I use query builder to manage my tables in ms-access.
the problem is, select qeury works great, update query works great,
delete doesn't work , and there is no error msg!!!!!!1 please help!!
OleDbDataAdapter adapter = new OleDbDataAdapter();
string queryString = "SELECT [Id],[Name] FROM
[myTable]";
cn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _conStrName + ";User
Id=admin;Password=;";
OleDbConnection connection = new OleDbConnection
(cn.ConnectionString);
adapter.SelectCommand = new OleDbCommand
(queryString, connection);
adapter.SelectCommand.CommandText = queryString;
OleDbCommandBuilder builder = new
OleDbCommandBuilder(adapter);
adapter.Update(ds.Tables["myTable"]);
return ds;*