c# - 如果下一行相同，如何仅删除 1 行

Question

private void button3_Click(object sender, EventArgs e)
{               
    con.Open();
    SqlDataAdapter SAD = new SqlDataAdapter("DELETE FROM Table1 WHERE ID_='"+textBox4.Text.ToString() + "'", con);
    SAD.SelectCommand.ExecuteNonQuery();
    MessageBox.Show("DELETE ALREADY!");
    string query = "SELECT * FROM Table1";
    SqlDataAdapter SDA = new SqlDataAdapter(query, con);
    DataTable dt = new DataTable();
    SDA.Fill(dt);
    dataGridView1.DataSource = dt;
    con.Close();                     
}

标签： c#visual-studio-2015

Answer 1

我想你想删除重复但只保留一个。你能试试这个吗？

DELETE FROM Table1
    WHERE ID_ NOT IN
    (
    SELECT ID_
    FROM Table1
    )