我想为我的asp.net获取一个SQL查询。

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

namespace YourNamespace
{
    public partial class YourPage : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            // 创建连接字符串
            string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";

            // 创建SQL查询语句
            string query = "SELECT * FROM YourTable";

            // 创建SqlConnection和SqlCommand对象
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    // 打开连接
                    connection.Open();

                    // 执行查询并获取结果
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // 遍历查询结果
                        while (reader.Read())
                        {
                            // 处理每一行数据
                            string column1Value = reader["Column1"].ToString();
                            string column2Value = reader["Column2"].ToString();

                            // 在页面上显示结果
                            Response.Write("Column1: " + column1Value + ", Column2: " + column2Value + "<br />");
                        }
                    }
                }
            }
        }
    }
}