<% @Import namespace="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %>
<html>
<HEAD>
<title>使用 SqlDataReader 读取数据示例</title>
<script language="C#" runat="server">
void Page_Load(object sender, System.EventArgs e)
{ string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
string Sql = "SELECT LastName, FirstName FROM Employees";
sqlconnection thisConnection = new SqlConnection(ConnectionString);
SqlCommand thisCommand = new SqlCommand(Sql, thisConnection);
thisCommand.CommandType = CommandType.Text;
try { // 打开数据库连接 thisCommand.Connection.Open(); // 执行SQL语句，并返回DataReader对象
SqlDataReader dr = thisCommand.ExecuteReader(); // 以粗体显示标题
myLabel.Text = "<b>LastName FirstName</b><br>"; // 循环读取结果集
while(dr.Read()) { // 读取两个列值并输出到Label中
myLabel.Text = dr["LastName"] " " dr["FirstName"] "<br>"; }
// 关闭DataReader dr.Close(); }
catch(SqlException ex)
{ // 异常处理 Response.Write(ex.ToString()); }
finally { // 关闭数据库连接 thisCommand.Connection.Close(); } }
</script>
</HEAD>
<body><form id="Form1" method="post" runat="server">
<h3>使用 SqlDataReader 读取数据示例</h3>
显示内容：<br>
<asp:Label id="myLabel" runat="server"></asp:Label> </form></body></HTML>
