DataSet图解

thisDataSet.Tables["Cutomers"].Rows[n]["CompanyName"]

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace DataContrast
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load( object sender, EventArgs e )
        {

            SqlConnection conn = new SqlConnection( "Data Source=zhengchenhan;Initial Catalog=zchtest;Integrated Security=True" );

            //conn.Open();

            //SqlCommand cmd = conn.CreateCommand();

            //cmd.CommandText = "select Name,Pwd from Users";

            //SqlDataReader DR = cmd.ExecuteReader();
            SqlDataAdapter adpter = new SqlDataAdapter( "select Name,Pwd from Users", conn );
          
            DataSet DS = new DataSet();

            adpter.Fill( DS, "Users" );//这里的 Users不是指数据库中的表名 ，是指DS中药创建的填充数据的DataTable对象名称
            foreach ( DataRow theRow in DS.Tables["Users"].Rows )
            {
                Response.Write( theRow["Name"] + "</br>" + theRow["Pwd"] );
            }
            conn.Close();
        }
           

        //    while(DR.Read())
        //    {
        //        Response.Write( DR["Name"] + "</br>" + DR["Pwd"] + "</br>" );
        //    }
        //    DR.Close();
        //    conn.Close();
        //}




       
    }
}

---

发芽网 © 2008 By 半瓶墨水 ( 发芽网开发日志 ) | Twitter: @realfun | 友情链接 | Powered By Django | Hosted on Bluehost