-
<% @Import namespace="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %>
<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 = "LastName FirstName
";
// 循环读取结果集
while(dr.Read())
{
// 读取两个列值并输出到Label中
myLabel.Text += dr["LastName"] + " " + dr["FirstName"] + "
";
}
// 关闭DataReader
dr.Close();
}
catch(SqlException ex)
{
// 异常处理
Response.Write(ex.ToString());
}
finally
{
// 关闭数据库连接
thisCommand.Connection.Close();
}
}
</script>