I have a problem with the code below.
I have a table that has a column called REGISTRO. Some times i have two or more lines with the same value in the column REGISTRO.
I want to remove all lines in the table with an specific value. For example all lines with REGISTRO value equals MNRJ02.
The program executes all of the commands and dont show me any error.
In the end when I open the table to verify the alterations, the lines had not been excluded and still they are in the table.
If somebody will be able to help me
Thanks

My code Below

thisAdapter = new OleDbDataAdapter ("SELECT * FROM lig_det ORDER BY registro", dbBanco.thisConnection);

                thisBuilder = new OleDbCommandBuilder (thisAdapter);

                thisDataSet = new DataSet ();

                thisAdapter.Fill (thisDataSet, "lig_det");

                //percorrendo toda a tabela LIG_DET para achar os registros que devem
                //ser eliminados
                for (int i = 0; i < thisDataSet.Tables ["lig_det"].Rows.Count; i++)
                {
                    if (registroSgc == thisDataSet.Tables ["lig_det"].Rows [i]["registro"].ToString ())
                    {

                        thisDataSet.Tables ["lig_det"].Rows [i].Delete ();

                        MessageBox.Show ("Estado do registro na tabela " +thisDataSet.Tables ["lig_det"].Rows [i].RowState.ToString ());

                    }//final do if
                }//final do FOR

                thisDataSet.Tables ["lig_det"].AcceptChanges ();

                thisAdapter.Update (thisDataSet, "lig_det");

                MessageBox.Show ("Registro "+registroSgc+" excluído com Sucesso",
                    "HARPIA - REGISTRO EXCLUÍDO",MessageBoxButtons.OK, MessageBoxIcon.Information);

Hi Thomaz.

I'm no expert, but here's my $0.02:

First, is registroSgc is a string, you might want to use the .Equals method to check for equality. Using == should be true only if registroSgc and the reference in the row you are looping on point to the same location.

Secondly, I would try and move the call to AcceptChanges in the inner loop (right after the call to Delete). I don't think this should make any difference, but if all else fails, I'd try that.

Hope this helps.

:D
To solve this trouble i use the SQL DELETE command like below.
The DataSet does not work well without a primary key in the table.

The code:

thisAdapter = new OleDbDataAdapter ("DELETE FROM histor WHERE registro = '"+registroSgc+"'", dbBanco.thisConnection);

thisBuilder = new OleDbCommandBuilder (thisAdapter);

thisDataSet = new DataSet ();

thisAdapter.Fill (thisDataSet, "refer");

If you want to let the user remove lines in the table after the query has been ran then you would need to iterate through the dataset checking for a match, and then delete the line. However I haven't gone into detail with this because I am assuming you want to exclude rows with a certain value prior to running the query.

If so you could do it in the SQL by adding a WHERE clause, e.g.:

thisAdapter = new OleDbDataAdapter ("SELECT * FROM lig_det ORDER BY registro WHERE registro <> 'MNRJ02'", dbBanco.thisConnection);

Please be aware that the use of <> conditions within a WHERE clause can reduce performance as every line must be read to check that the value IS NOT the exclusion value. I think in your case you should be ok.

Skin