<%@ Page Language="c#"%>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.SqlClient"%>
<%@ Import Namespace="System.Web.UI.HtmlControls"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>最原始的ASPX填充表从数据库取值</title>
</head>
<body>
<script language="c#" runat="server">
SqlConnection con;
SqlDataAdapter sda;
//HtmlTable au_table;
DataTable dt = new DataTable("author");
protected override void OnLoad(EventArgs ea)
{
con = new SqlConnection("Data Source=.;User ID=sa;Password=;Initial catalog=pubs");
con.Open();
sda = new SqlDataAdapter("select * from author", con);
sda.Fill(dt);
sda.Dispose();
con.Close();
}
public void GetAuthor(object sender, EventArgs args)
{
int rowcount = dt.Rows.Count;
int colcount = dt.Columns.Count;
HtmlTableRow htr = null;
HtmlTableCell htc = null;
for (int i = 0; i < rowcount; i++)
{
htr = new HtmlTableRow();
for (int j = 0; j < colcount; j++)
{
htc = new HtmlTableCell("td");
htc.InnerText = dt.Rows[i][j].ToString();
htr.Cells.Add(htc);
}
au_table.Rows.Add(htr);
}
au_table.Border = 1;
}
</script>
<form id="form1" runat="server">
<div>
<input type="button" value="Click" runat="server" onserverclick="GetAuthor" />
<table id="au_table" runat="server">
</table>
</div>
</form>
</body>
</html>