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

初次接触： 

1:　　using(类型 d ＝new ....)

　　　　{.......}

 2:　　cmd.CommandText="";

　　　　cmd.ExecuteNonQuery();

 

★ExecuteNonQuery一般用来执行Upadate\Delete\Insert语句

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            using(SqlConnection con=new SqlConnection(
                "data source=.;server=chf-pc\\SQL2008;Initial Catalog=MyDataBase;User id=sa;Password=123;Integrated Security=SSPI;") )
                {
                MessageBox.Show("1111！");
                con.Open();
                using (SqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandText = "INSERT INTO Movies(CategoryId,Title,Director,DateReleased) VALUES('5','myBook','hefu','2007-06-21 00:00:00.000')";
                    cmd.ExecuteNonQuery();
                }
                
                }
            MessageBox.Show("插入数据完成！");
        }

 

 

 

★ExecuteScalar一般用来执行有且只有一行一列返回值的SQL语句

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //ExecuteScalar一般用来执行有且只有一行一列返回值的SQL语句
            using (SqlConnection conn= new SqlConnection("data source=.;server=chf-pc\\SQL2008;Initial Catalog=MyDataBase;User id=sa;Password=123;Integrated Security=SSPI;"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT COUNT(*) FROM dbo.Movies WHERE DateReleased<'2000-1-1'";
                    int i= (int)cmd.ExecuteScalar();
                    MessageBox.Show(i+"条数据！");
                }
            }
        }