1 运用控件DataList或GridView
先定义一个数据绑定函数
void databind()
{
string sqlstr=""; //sql命令字符串
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ""; //设置连接字符串
SqlDataAdapter ad = new SqlDataAdapter(sqlstr, conn);
DataTable mydt = new DataTable();
ad.Fill(mydt);
DataList1.DataSource = mydt.DefaultView;
DataList1.DataBind();
}
在Page_Load事件中加载
protected void Page_Load(object sender, EventArgs e)
{
databind();
}
2 利用HTML元素显示数据
先定义HTML元素,必须加上"runat="server"".如<div id="box" runat="server"></div>
在cs文件中编写如下代码:
void databind()
{
string sqlstr=""; //sql命令字符串
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ""; //设置连接字符串
SqlDataAdapter ad = new SqlDataAdapter(sqlstr, conn);
DataTable mydt = new DataTable();
ad.Fill(mydt);
if (mydt.Rows.Count > 0)
{
box.InnerHtml = mydt.Rows[0]["列名"].ToString();
}
}