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;
using System.Data; using System.Configuration;

namespace _03.DataSet離線數(shù)據(jù)集
{
    /// <summary>
    /// Window1.xaml 的交互邏輯
    /// </summary>
    public partial class Window1 : Window
    {
        public Window1()
        {
            InitializeComponent();
        }

        private void btnDS_Click(object sender, RoutedEventArgs e)
        {
            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 * from T_Student where age<@age";
                    cmd.Parameters.Add(new SqlParameter("@age", 60));
                    //cmd.ExecuteReader();并沒有執(zhí)行，而是new了一個(gè)adapter來接受cmd。

                    //SqlDataAdapter是一個(gè)幫我們把SqlCommand的查詢結(jié)果填充到DataSet中的類
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);//SqlDataAdapter需要一個(gè)參數(shù)

                    //DataSet相當(dāng)于本地的一個(gè)復(fù)雜集合（List<int>）
                    DataSet dataset = new DataSet();//DataSet是數(shù)據(jù)集
                    adapter.Fill(dataset);//執(zhí)行cmd并且把SqlCommand查詢結(jié)果填充到DataSet

                    //DataTable是內(nèi)存中的數(shù)據(jù)表
                    DataTable table = dataset.Tables[0];//因?yàn)閿?shù)據(jù)庫中就一個(gè)表T_Student，所以就是[0].
                    DataRowCollection rows = table.Rows;//DataRowCollection是DataTable行的集合,這里的rows指查詢結(jié)果的行
                    for (int i = 0; i < rows.Count; i++)
                    {
                        DataRow row = rows[i];
                        int age = (int)row["Age"];
                        string name=(string)row["Name"];
                        MessageBox.Show(name+","+age);
                    }
                }
            }
        }

        private void btnDSS_Click(object sender, RoutedEventArgs e)
        {
            //采用ConfigurationManager.ConnectionStrings 屬性,只能讀取到app.config的配置信息。
            string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
            //項(xiàng)目根目錄添加一個(gè)"應(yīng)用程序配置文件",名字是App.config
            //App.config加節(jié)點(diǎn)，給add起一個(gè)name
            //項(xiàng)目添加對System.configuration的引用(理解為添加開發(fā)包,System.Data就是ADO.NET的開發(fā)包)
            //就能使用System.configuration里的ConfigurationManager類
            //asp.net里就變成了Web.config

            MessageBox.Show(connStr);
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from T_Student where age<@age";
                    cmd.Parameters.Add(new SqlParameter("@age",21));

                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    DataSet dataset = new DataSet();
                    adapter.Fill(dataset);

                    DataTable table=dataset.Tables[0];
                    DataRowCollection rows = table.Rows;
                    for(int i=0;i<rows.Count;i++)
                    {
                        DataRow row=rows[i];
                        string hobbit=(string)row["Hobbit"];
                        MessageBox.Show(hobbit);
                    }
                }
            }
        }
    }
}