asp.net查询数据库代码

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
        string query = "SELECT * FROM Employees";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    // 处理每一行数据
                    string name = reader["Name"].ToString();
                    int age = Convert.ToInt32(reader["Age"]);
                    // ... 其他字段的处理
                }

                reader.Close();
            }
            catch (Exception ex)
            {
                // 处理异常
                Response.Write("Error: " + ex.Message);
            }
        }
    }
}

<connectionStrings>
    <add name="MyConnectionString" connectionString="Data Source=.;Initial Catalog=MyDatabase;User ID=myUsername;Password=myPassword;" providerName="System.Data.SqlClient"/>
</connectionStrings>