用控件绑定数据库,但是现实不出来
代码如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Default3 : System.Web.UI.Page
{
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void Page_Load(object sender, EventArgs e)
{
string ConnectionString = "server=(local);uid=sa;pwd=123456;DataBase=newsdb";
SqlConnection conn = new SqlConnection(ConnectionString);
conn.Open();
string selectSQL = "select * from db_Admin";
SqlDataAdapter sda = new SqlDataAdapter(selectSQL, conn);
DataSet ds = new DataSet();
sda.Fill(ds, "table");
GridView1.DataSource = ds.Tables["table"];
conn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
}