adonet基础示例分享(adonet连接数据库)

usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows;
usingSystem.Windows.Controls;
usingSystem.Windows.Data;
usingSystem.Windows.Documents;
usingSystem.Windows.Input;
usingSystem.Windows.Media;
usingSystem.Windows.Media.Imaging;
usingSystem.Windows.Navigation;
usingSystem.Windows.Shapes;
usingSystem.Data.SqlClient;

namespaceADONET基础{
   ///<summary>
   ///Window1.xaml的交互逻辑
   ///</summary>
   publicpartialclassWindow1:Window
   {
       publicWindow1()
       {
           InitializeComponent();
       }

       privatevoidbutton1_Click(objectsender,RoutedEventArgse)
       {
           ////using()自动关闭数据库，回收资源。
           ////SqlConnection为建立和数据库连接的对象。
           //using(SqlConnectionconn=newSqlConnection("DataSource=.;InitialCatalog=myself;UserId=sa;Password=123;"))
           //{
           //   conn.Open();//打开连接
           //   //通过连接，创建一个向数据库发命令的对象SqlCommand
           //   using(SqlCommandcmd=conn.CreateCommand())//释放资源。
           //   {
           //       //CommandText为要执行的SQL的语句
           //       cmd.CommandText="Insertintostudent(学号,姓名)values(110,"张五")";
           //       //ExecuteNonQuery一般用来执行UpdateDeleteInsert语句。
           //       cmd.ExecuteNonQuery();//执行上面的SQL语句。
           //   }
           //}

           using(SqlConnectionconn=newSqlConnection("DataSource=.;InitialCatalog=MyTest;UserId=sa;Password=123;"))
           {
               conn.Open();
               using(SqlCommandcmd=conn.CreateCommand())
               {
                   //cmd.CommandText="selectcount(*)fromstudentwhere入学成绩<570";
                   //cmd.CommandText="selectcount(*)fromstudentwhere入学成绩<570";
                   ////ExecuteScalar一般用来执行有且只有一行一列返回值的SQL语句。
                   //inti=(int)cmd.ExecuteScalar();
                   //MessageBox.Show(i+"人成绩小于570分");
                   cmd.CommandText="InsertintoT_Student(Name,Age)outputinserted.Idvalues("张顾",18);";
                   longi=(long)cmd.ExecuteScalar();
                   MessageBox.Show("Id为"+i);
               }
           }
           MessageBox.Show("执行完成");
       }
   }
}