0

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;*
2
Contributors
1
Reply
3
Views
8 Years
Discussion Span
Last Post by DdoubleD
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.