PRivate void Button_Click(object sender, RoutedEventArgs e)        {            //ADO.NET 連接方式查詢數(shù)據(jù)庫 ExcuteReader執(zhí)行查詢            //1.創(chuàng)建連接對象            using (SqlConnection conn = new SqlConnection(SQLHelper.ConnectionString))            {                //2.創(chuàng)建命令對象                using (SqlCommand scmd = new SqlCommand())                {                    //3.打開鏈接                    conn.Open();                    //4. 發(fā)送命令                    scmd.CommandText = "select * from Student";                    scmd.CommandType = CommandType.Text;                    scmd.Connection = conn;                    //執(zhí)行命令                    using (SqlDataReader reader = scmd.ExecuteReader())                    {                        //5.處理數(shù)據(jù)                        while (reader.Read())                        {                            string name = reader["s_Name"].ToString();                            int age = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("s_Age")));                            MessageBox.Show(string.Format("name={0}, age={1}", name, age));                        }                        //6.關閉連接                        //備注：因為這里使用了using代碼塊，會自動進行資源回收。就不用手動關閉連接了。datareader讀取的結果集，還是存放在數(shù)據(jù)庫中。                    }                }            }        }