.net提取数据库数据（最简单的方式）

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace 实例7_3
{
    public partial class Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            String sqlconn = "Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\data\\manage.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            SqlConnection myConnection = new SqlConnection(sqlconn);
            myConnection.Open();
            SqlCommand myCommand = new SqlCommand("select * from CustomerInfo", myConnection);
            SqlDataReader myReader;
            myReader = myCommand.ExecuteReader();
            Response.Write("<h3>使用SqlDataReader对象查询数据库</h3>");
            Response.Write("<table border=1 cellspacing=0 cellpadding=2>");
            Response.Write("<tr bgcolor=yellow>");
            for (int i = 0; i < myReader.FieldCount; i++)
            {
                Response.Write("<td>" + myReader.GetName(i) + "</td>");
            }
            Response.Write("</tr>");
             while(myReader.Read())
            {
                Response.Write("<tr>");
                for (int i = 0; i < myReader.FieldCount; i++)
                {
                    Response.Write("<td>" + myReader[i].ToString() + "</td>");
                }
                Response.Write("</tr>");
            }
            Response.Write("</table>");
            myConnection.Close();
           }
        }
    }