使用SqlDataReader读取数据示例-优快云博客

<% @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>