如何在网格视图asp.net中读取特定列中的所有行并在绑定前进行更改

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDataBound="GridView1_RowDataBound" OnDataBinding="GridView1_DataBinding">
    <Columns>
        <asp:TemplateField HeaderText="Column1">
            <ItemTemplate>
                <%# Eval("Column1") %>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Column2">
            <ItemTemplate>
                <%# Eval("Column2") %>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // 设置GridView的数据源，例如从数据库中读取数据
        GridView1.DataSource = GetDataFromDatabase();
        GridView1.DataBind();
    }
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        // 修改特定列的值，例如将Column1的文本改为大写
        Label column1Label = e.Row.FindControl("Column1Label") as Label;
        if (column1Label != null)
        {
            column1Label.Text = column1Label.Text.ToUpper();
        }
    }
}

protected void GridView1_DataBinding(object sender, EventArgs e)
{
    // 在绑定前对数据进行最后一次更改，例如将Column2的值加上前缀
    foreach (GridViewRow row in GridView1.Rows)
    {
        Label column2Label = row.FindControl("Column2Label") as Label;
        if (column2Label != null)
        {
            column2Label.Text = "Prefix " + column2Label.Text;
        }
    }
}