dataTable可从datareader中读取数据

public  partial  class  _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
           GridView1.DataSource= getDate();
           GridView1.DataBind();
        }
    }

    public DataTable getDate()
    {
        DataTable dt;
         string conString="server=server01;database=test;uid=sa;pwd=sql";
         using (SqlConnection con = new SqlConnection(conString))
         { 
             con.Open();
             using(SqlCommand cmd = new SqlCommand("select * from tab",con))
             {
                using(SqlDataReader reader=cmd.ExecuteReader())
                {
                    dt = new DataTable();
                    //填充数据
                    dt.Load(reader, LoadOption.OverwriteChanges);
                }
             }
         }
         return dt;
         
    }
}

转载于:https://www.cnblogs.com/jame-peng1028/archive/2007/05/17/749741.html