DataSet基础

using (SqlConnection conn = new SqlConnection(
  "Data Source = .;Initial Catalog = DB1;User ID = sa;Password = zxcasd"))
{
    conn.Open();
    using (SqlCommand cmd = conn.CreateCommand())
    {
        //拼接字符串会有SQL注入漏洞,输入 1' or '1' = '1
        cmd.CommandText = "select * from T_student where Age > 20";
        //SqlDataAdapter是一个帮我们把SqlCommand查询结果填充到DataSet中的类
        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
        //DataSet相当与本地的一个复杂集合
        DataSet dataset = new DataSet();
        //填充，adapter把cmd的结果填充到dataset
        adapter.Fill(dataset);
        //可以同时执行多个select语句查出多个表，但一般只查一个表，所以是Table[0]
        DataTable dataTbl = dataset.Tables[0];
        DataRowCollection rows = dataTbl.Rows;   //行的集合
        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);

        }
    }
}