ADO.net 学习 01 向数据表中插入一行数据(ExecuteNonQuery、ExecuteScalar)

初次接触： 

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         }

 

转载于:https://www.cnblogs.com/hefu_cao/archive/2013/05/20/3087790.html