I have bug in deleting from db, update ,insert works fine

[Montezuma's Daughter]

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;*

 

[Joe Cool]

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;*

You need to include the code that builds the delete query.