SqlDataAdapter和SqlDataReader

SqlDataAdapter 的使用

   private void Form1_Load(object sender, EventArgs e)
        {
            DataTable dt=new DataTable();
            using (SqlDataAdapter sda=new SqlDataAdapter("select * from TblStudent","Data Source=xy-pc;Initial Catalog=MyItcast;Integrated Security=True"))
            {
                sda.Fill(dt);
            }
            dataGridView1.DataSource = dt;
        }

SqlDataReader 的使用 

         List<DeskInfo> list = new List<DeskInfo>();
            string sql = "select deskid,deskname,desknum, desknamepinyin from DeskInfo where DeskDelFlag=0";
            SqlDataReader reader= SqlHelper.ExecuteReader(sql);
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    DeskInfo desk = new DeskInfo();
                    desk.DeskId = Convert.ToInt32(reader["DeskId"]);
                    desk.DeskName = reader["DeskName"].ToString();
                    desk.DeskNamePinYin = reader["DeskNamePinYin"].ToString();
                    desk.DeskNum = reader["DeskNum"].ToString();
                    list.Add(desk);
                }
            }