数据库删除的两种方法

 方法一：

try
             {

                 //using (SqlConnection conn1 = new SqlConnection(connectionString))
                 //{
                 //    conn1.Open();
                 //    using (SqlCommand command = conn1.CreateCommand())
                 //{  
                 string Temtext = "delete from Student3 where Id=@Id";
                 SqlParameter paras = new SqlParameter("@Id", textBox1.Text);
                 int i = SqlHelper.ExecuteNonQuery(Temtext, CommandType.Text, paras);
                 if (i > 0)
                     MessageBox.Show("数据已删除");

                 if (MessageBox.Show("是否继续删除？", "删除对话框", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                 {
                     textBox1.Text = "";
                 }
                 else
                 {
                     this.Close();
                 }
                 // }

                 // }
             }
             catch (Exception exp)
             {
                 MessageBox.Show(exp.Message);
             }
         }

方法二：

//if (this.dataGridView1.SelectedRows.Count > 0)
             //{
             //    DataGridViewRow row = this.dataGridView1.SelectedRows[0];
             //    #region 删除数据库中的数据
             //    string sqlserstr = "Data Source=IDEA-PC;Initial Catalog=BookDB;User ID=sa;Password=abcdef";
             //    SqlConnection conn = new SqlConnection(sqlserstr);
             //    conn.Open();
             //    SqlCommand cmd = new SqlCommand();
             //    cmd.Connection = conn;

             //    cmd.CommandText = "delete from Student3 where Id=@id";
             //    cmd.Parameters.AddWithValue("@id", row.Cells[0].Value.ToString());
             //    cmd.ExecuteNonQuery();
             //    cmd.Dispose();
             //    conn.Close();
             //    conn.Dispose();
             //    MessageBox.Show("删除成功");
             //    //获取当前选中的行，返回值为DataGridViewRow

             //    this.dataGridView1.Rows.Remove(row);
             //    #endregion

             //}