如何在从数据库中恢复后绑定到gridview之前编辑列值？

// 从数据库中检索数据
string connectionString = "YourConnectionString";
string query = "SELECT * FROM YourTable";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);

// 将数据绑定到GridView
GridView1.DataSource = dataTable;
GridView1.DataBind();

// 编辑列值
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        // 获取需要编辑的列的控件
        TextBox textBox = (TextBox)e.Row.FindControl("YourTextBox");

        // 获取当前行的数据
        DataRowView rowView = (DataRowView)e.Row.DataItem;
        string columnValue = rowView["YourColumn"].ToString();

        // 修改列的值
        textBox.Text = "Modified Value";
    }
}

// 保存修改后的数据到数据库
protected void SaveButton_Click(object sender, EventArgs e)
{
    foreach (GridViewRow row in GridView1.Rows)
    {
        // 获取需要保存的数据
        string columnValue = ((TextBox)row.FindControl("YourTextBox")).Text;
        string primaryKeyValue = GridView1.DataKeys[row.RowIndex].Value.ToString();

        // 更新数据库中的数据
        string updateQuery = "UPDATE YourTable SET YourColumn = @ColumnValue WHERE PrimaryKey = @PrimaryKey";
        SqlCommand updateCommand = new SqlCommand(updateQuery, connection);
        updateCommand.Parameters.AddWithValue("@ColumnValue", columnValue);
        updateCommand.Parameters.AddWithValue("@PrimaryKey", primaryKeyValue);
        connection.Open();
        updateCommand.ExecuteNonQuery();
        connection.Close();
    }
}