DataSet读取数据用法

动软用的是DataSet我一般用的List<>

 备忘！

 

     BLL.CarSun cs = new Maticsoft.BLL.CarSun();
          DataSet ds = new DataSet();
        ds = cs.GetAllList();//指定数据来源
         DataTable dt = new DataTable();
           dt = ds.Tables[0];
           Response.Write(dt.Rows.Count);//一共多少条
            for (int i = 0; i < rows; i++) {
           Response.Write(dt.Rows[i]["CarSun_Name"].ToString()+"<br/>");
          }
          
           
           
            //ForEach遍历
           // foreach (DataTable dt in ds.Tables)
           //{
           //    Response.Write(dt.TableName);//DataTable名称
           //    foreach (DataRow dr in dt.Rows)
           //    {

           //        foreach (DataColumn dc in dt.Columns)
           //        {
           //            Response.Write(dc.ColumnName);
           //            Response.Write(dr[dc]);
           //        }
           //        Response.Write("<br/>");
           //    }
           //}