初次接触:
1: using(类型 d =new ....)
{.......}
2: cmd.CommandText="";
cmd.ExecuteNonQuery();
★ExecuteNonQuery一般用来执行Upadate\Delete\Insert语句
1 private void button1_Click(object sender, RoutedEventArgs e) 2 { 3 using(SqlConnection con=new SqlConnection( 4 "data source=.;server=chf-pc\\SQL2008;Initial Catalog=MyDataBase;User id=sa;Password=123;Integrated Security=SSPI;") ) 5 { 6 MessageBox.Show("1111!"); 7 con.Open(); 8 using (SqlCommand cmd = con.CreateCommand()) 9 { 10 cmd.CommandText = "INSERT INTO Movies(CategoryId,Title,Director,DateReleased) VALUES('5','myBook','hefu','2007-06-21 00:00:00.000')"; 11 cmd.ExecuteNonQuery(); 12 } 13 14 } 15 MessageBox.Show("插入数据完成!"); 16 }
★ExecuteScalar一般用来执行有且只有一行一列返回值的SQL语句
1 private void button1_Click(object sender, RoutedEventArgs e) 2 { 3 //ExecuteScalar一般用来执行有且只有一行一列返回值的SQL语句 4 using (SqlConnection conn= new SqlConnection("data source=.;server=chf-pc\\SQL2008;Initial Catalog=MyDataBase;User id=sa;Password=123;Integrated Security=SSPI;")) 5 { 6 conn.Open(); 7 using (SqlCommand cmd = conn.CreateCommand()) 8 { 9 cmd.CommandText = "SELECT COUNT(*) FROM dbo.Movies WHERE DateReleased<'2000-1-1'"; 10 int i= (int)cmd.ExecuteScalar(); 11 MessageBox.Show(i+"条数据!"); 12 } 13 } 14 }