html mysql 数据列表_将从数据库中获取的数据 ，以HTML表格的形式显示

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("