I need help in query builder c#- delete doesn't work!
<p>I have a small project in c# and ms-access. I use query builder to manage my tables in ms-access.</p>

<p>The problem is, select query works great, update query works great, but delete doesn't work and there is no error message!</p>

<p>Please help.</p>

<pre><code> public DataSet Update(DataSet ds)
        {
            using (cn)
            {
                OleDbDataAdapter adapter = new OleDbDataAdapter();
                string queryString = "SELECT [taskId],[resourceId] 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;
            }
</code></pre>

<p><hr></p>

<p>public DataSet Update(DataSet ds)
            {
                using (cn)
                {
                    OleDbDataAdapter adapter = new OleDbDataAdapter();
                    string queryString = "SELECT [taskId],[resourceId] 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;</p>

<pre><code>                OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);

                adapter.Update(ds.Tables["mytable";"]);

                return ds;
            }
        ==================================
</code></pre>
