该博客介绍了一种方法，通过ASP.NET页面加载事件获取数据库中的Customers表所有数据，利用SqlConnection、SqlCommand和SqlDataAdapter填充DataTable，然后将数据转换为HTML表格格式，最终将表格内容显示在网页的div元素中。
protected void Page_Load(objectsender, EventArgs e)
{if (!IsPostBack)
{string conString = ConfigurationManager.ConnectionStrings["DemosDatabaseConnectionString"].ConnectionString;string query = "SELECT * FROM Customers";using (SqlConnection con = newSqlConnection(conString))
{using (SqlCommand cmd = newSqlCommand(query))
{using (SqlDataAdapter sda = newSqlDataAdapter())
{
cmd.Connection=con;
sda.SelectCommand=cmd;using (DataTable dt = newDataTable())
{
sda.Fill(dt);
StringBuilder str= newStringBuilder();
StringBuilder str1= newStringBuilder();
str.Append("
str.Append("
");for (int k = 0; k < dt.Columns.Count; k++){
str.Append("
");str.Append(dt.Columns[k].ColumnName);
str.Append("
");}
str.Append("
");str.Append("");
str.Append("
");str.Append("
");for (int i = 0; i < dt.Rows.Count; i++){
str.Append("
");for (int k = 0; k < dt.Columns.Count; k++){
str.Append("
");str.Append(dt.Rows[i][k]);
str.Append("
");}
str.Append("
");str.Append("");
str.Append("
");str.Append("
");}
str.Append("
");str.Append("
str.Append("
");for (int k = 0; k < dt.Columns.Count; k++){
str.Append("
");str.Append("Head");
str.Append("
");}
str.Append("
");for (int i = 0; i < dt.Rows.Count; i++){
str.Append("
");for (int k = 0; k < dt.Columns.Count; k++){
str.Append("
");str.Append("Test");
str.Append("
");}
str.Append("
");}
str.Append("
");divUsers.InnerHtml=str.ToString();
}
}
}
}
}
}
1055
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
