如何在gridview中使用dropdownlist改变数据库绑定？

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
    <Columns>
        <asp:BoundField DataField="ID" HeaderText="ID" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:TemplateField HeaderText="Status">
            <ItemTemplate>
                <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                    <asp:ListItem Text="Active" Value="1"></asp:ListItem>
                    <asp:ListItem Text="Inactive" Value="0"></asp:ListItem>
                </asp:DropDownList>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        BindGridView();
    }
}

private void BindGridView()
{
    // 绑定GridView的数据源
    DataTable dt = GetDataFromDatabase();
    GridView1.DataSource = dt;
    GridView1.DataBind();
}

private DataTable GetDataFromDatabase()
{
    // 从数据库中获取数据
    // 这里假设数据源是一个DataTable
    DataTable dt = new DataTable();
    // 假设有两列：ID和Name
    dt.Columns.Add("ID", typeof(int));
    dt.Columns.Add("Name", typeof(string));
    // 添加一些示例数据
    dt.Rows.Add(1, "John");
    dt.Rows.Add(2, "Jane");
    return dt;
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    // 获取选中的DropDownList所在行的数据
    DropDownList ddl = (DropDownList)sender;
    GridViewRow row = (GridViewRow)ddl.NamingContainer;
    int rowIndex = row.RowIndex;
    int id = Convert.ToInt32(GridView1.DataKeys[rowIndex].Value);
    string name = GridView1.Rows[rowIndex].Cells[1].Text;

    // 更新数据库中的数据
    UpdateDataInDatabase(id, name, ddl.SelectedValue);
}

private void UpdateDataInDatabase(int id, string name, string status)
{
    // 更新数据库中的数据
    // 这里假设使用ADO.NET来操作数据库
    // 假设有一个名为"YourTable"的表，包含ID、Name和Status三列
    string connectionString = "YourConnectionString";
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        string query = "UPDATE YourTable SET Status = @Status WHERE ID = @ID AND Name = @Name";
        SqlCommand command = new SqlCommand(query, connection);
        command.Parameters.AddWithValue("@Status", status);
        command.Parameters.AddWithValue("@ID", id);
        command.Parameters.AddWithValue("@Name", name);
        connection.Open();
        command.ExecuteNonQuery();
    }
}