如何使用c#在网格视图中获取特定数据？

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)
        {
            if (!IsPostBack)
            {
                // 创建连接字符串
                string connectionString = "YourConnectionString";

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

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

                    // 执行查询并获取结果
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // 创建DataTable用于存储数据
                        DataTable dataTable = new DataTable();
                        dataTable.Load(reader);

                        // 绑定数据到网格视图
                        GridView1.DataSource = dataTable;
                        GridView1.DataBind();
                    }
                }
            }
        }
    }
}