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

namespace ADONET基础 {
    ///
    /// Window1.xaml 的交互逻辑
    ///
    public partial class Window1 : Window
    {
        public Window1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            ////using() 自动关闭数据库，回收资源。
            ////SqlConnection为建立和数据库连接的对象。
            //using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=myself;User Id=sa;Password=123;"))
            //{
            //    conn.Open();//打开连接
            //    //通过连接，创建一个向数据库发命令的对象SqlCommand
            //    using (SqlCommand cmd = conn.CreateCommand())//释放资源。
            //    {
            //        //CommandText为要执行的SQL的语句
            //        cmd.CommandText = "Insert into student(学号,姓名) values(110,'张五')";
            //        //ExecuteNonQuery一般用来执行Update Delete Insert 语句。
            //        cmd.ExecuteNonQuery();//执行上面的SQL语句。
            //    }
            //}

            using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=MyTest;User Id=sa;Password=123;"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    //cmd.CommandText = "select count(*) from student where 入学成绩