頁面效果
Paste_Image.png
imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
cs頁面代碼
protected void Page_Load(object sender, EventArgs e)
{
//數(shù)據(jù)庫地址
string sqlPath = "server =; database =; uid =; pwd =";
//創(chuàng)建數(shù)據(jù)庫對象
SqlConnection con = new SqlConnection(sqlPath);
//數(shù)據(jù)庫命令
string sqlcmd = "select xm,xb,pxdd from userlist order by id";
//執(zhí)行sql語句
SqlDataAdapter sqlda = new SqlDataAdapter(sqlcmd,con);
//創(chuàng)建Dataset對象
DataSet dataSet = new DataSet();
//填充數(shù)據(jù)集
sqlda.Fill(dataSet);
//綁定數(shù)據(jù)
GridView1.DataSource = dataSet;
GridView1.DataBind();
}
aspx頁面代碼
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
</div>
</form>
</body>
