<% @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 method="post" runat="server"> <h3>使用 SqlDataReader 读取数据示例</h3> 显示内容：<br> <asp:Label runat="server"></asp:Label> </form></body></HTML>
