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基礎 {
    /// <summary>
    /// Window1.xaml 的交互邏輯
    /// </summary>
    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 入學成績<570";
                    //cmd.CommandText = "select count(*) from student where 入學成績<570";
                    ////ExecuteScalar一般用來執行有且只有一行一列返回值的SQL語句。
                    //int i = (int)cmd.ExecuteScalar();
                    //MessageBox.Show(i+"人成績小于570分");
                    cmd.CommandText = "Insert into T_Student(Name,Age) output inserted.Id values('張顧',18);";
                    long i = (long)cmd.ExecuteScalar();
                    MessageBox.Show("Id為"+i);
                }
            }
            MessageBox.Show("執行完成");
        }
    }
}