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;*
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.