求大神如何用GridView在页面显示数据库中的信息

Question

http://blog.csdn.net/mmhoo/article/details/8553801

Answer 1

http://developer.51cto.com/art/200907/139703.htm

Answer 2

前台：
 <h2>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </h2>
后台：
  string ConnString = "Data Source=.;Initial Catalog=data;User ID=sa;password=sa;Integrated Security=False";
        protected void Page_Load(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(ConnString))
            {
                SqlCommand cmd = conn.CreateCommand(); //数据库连接命令                
                cmd.CommandText = @"select top 5 * from newtable";
                cmd.CommandType = CommandType.Text;                
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.SelectCommand = cmd;
                da.Fill(ds, "newtable");
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataBind(); 
               
            }
        }