展开全部
后台拼接html错误!请楼主重新按照下面正确的拼写运行一次! 还有,62616964757a686964616fe4b893e5b19e31333332613737请确保是否能够连上数据库!
using System;
using System.Data.SqlClient;
public partial class selectData : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//使用connection,链接数据源
String strCon = "Data Source=PC-201304221209;DataBase=yy";
SqlConnection con = new SqlConnection(strCon);
//提供SQL,创建command对象
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select *from student";
//建立数据库的链接
con.Open();
//建立dataadapter 获取查询结果
SqlDataReader dr = cmd.ExecuteReader();
//显示标题
message.Text = "
学号 | 姓名 | 性别 |
//显示所有记录
while (dr.Read())
{
message.Text += "
";message.Text += "
" + dr["id"] + "";message.Text += "
" + dr["name"] + "";message.Text += "
" + dr["sex"] + "";message.Text += "
";}
message.Text += "
";//关闭数据源
con.Close();
}
}