private void button5_Click( object sender, EventArgs e) |
02 |
{ |
03 |
if (MessageBox.Show( "确认删除该行吗?" , "删除" , MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes ) |
04 |
{ |
05 |
SqlConnection conn = new SqlConnection(); |
06 |
conn.ConnectionString = "Data Source=PC2012081514KSL\\MSSQL2008;Initial Catalog=db_book;Integrated Security=True" ; |
07 |
conn.Open(); |
08 |
int i = this .dataGridView1.SelectedRows.Count - 1; |
09 |
Debug.WriteLine( "AA={0}" , i); //调试语句 |
10 |
for ( int a = i; a >= 0; a--) |
11 |
{ |
12 |
Debug.WriteLine( "a={0}" , a); //调试语句 |
13 |
string sqlstring = "delete from tb_book where book_id='" +dataGridView1 .SelectedRows [a].Cells [0].Value .ToString ()+ "'" ; |
14 |
SqlCommand cmd = new SqlCommand(sqlstring ,conn ); |
15 |
cmd.ExecuteNonQuery(); |
16 |
} |
17 |
conn .Close (); |
18 |
conn .Open (); |
19 |
string sqlstring1= "select * from tb_book" ; |
20 |
SqlCommand cmd1= new SqlCommand (sqlstring1 ,conn ); |
21 |
SqlDataAdapter da= new SqlDataAdapter (cmd1); |
22 |
cmd1 .ExecuteNonQuery (); |
23 |
DataSet ds= new DataSet (); |
24 |
da.Fill (ds ); |
25 |
dataGridView1 .DataSource =ds .Tables [0]; |
26 |
conn .Close (); |
27 |
MessageBox .Show ( "删除成功!" ); |
28 |
} |
29 |
else |
30 |
{ |
31 |
return ; |
32 |
} |
33 |
} |