Deleting data SQLServer using C# application

Question

I need to make a button that delete rows from my dataset in C#, but I want datagridview selected rows to be deleted, how do I do that?

This is what was in the professor instructions, but unfortunatelly this isn't working for me.

            int lineNum = int.Parse(lineDelete.Text.ToString());
        SqlConnection sqlConn = new SqlConnection(ConnectionString);
        sqlConn.Open();
        string deleteSqlQuery = "select * from Clientes order by ID";
        SqlDataAdapter deleteDA = new SqlDataAdapter(deleteSqlQuery, sqlConn);
        DataSet deleteDS = new DataSet();
        deleteDA.Fill(deleteDS, "Clientes");
        deleteDS.Tables["Clientes"].Rows[lineNum].Delete();
        SqlCommandBuilder deleteCB = new SqlCommandBuilder(deleteDA);
        deleteDA.Update(deleteDS, "Clientes");
        deleteDA.Dispose();
        deleteDS.Dispose();
        deleteCB.Dispose();
        sqlConn.Close();
        CliCadForm_Load(null, null);
        CustTBoxID.Text = "";
        CustTBoxNome.Text = "";
        CustTBoxDDD.Text = "";
        CustTBoxTel.Text = "";
        CustTBoxEnde.Text = "";
        CustTBoxENum.Text = "";
        CustTBoxEComp.Text = "";
        CustTBoxEBai.Text = "";
        CustTBoxEUF.Text = "";
        CustTBoxECid.Text = "";
        CustTBoxECEP.Text = "";
        lineDelete.Text = "";

Gleb · Accepted Answer · 2014-11-14 08:39:50Z

1

If I understand you, you can use something like this:

    private void DeleteSelectedRows()
    {
        using (SqlConnection con = new SqlConnection(ConnectionString))
        {
            con.Open();

            foreach(DataGridViewRow row in dataGridView.SelectedRows)
            {
                SqlCommand cmd = new SqlCommand("DELETE FROM Clientes WHERE ID="+row.Cells["ID"].Value, con);
                cmd.ExecuteNonQuery();
            }

            con.Close();
        }
    }

answered Nov 14, 2014 at 8:39

Gleb

1,4321 gold badge24 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Deleting data SQLServer using C# application

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related