C# Asp.net Webforms简单的1行多列的SQL查询到变量

using System;
using System.Data.SqlClient;

namespace WebApplication
{
    public partial class Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串
            string query = "SELECT Column1, Column2 FROM YourTable"; // 替换为你的查询语句

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

                SqlDataReader reader = command.ExecuteReader();
                if (reader.Read())
                {
                    string column1Value = reader["Column1"].ToString();
                    string column2Value = reader["Column2"].ToString();

                    // 在这里可以对获取到的变量进行进一步处理或使用
                }

                reader.Close();
            }
        }
    }
}