通过下拉列表选中值更新GridView，绑定数据失败求助

Hey there! Let's get that GridView working properly with your DropdownList selection. Since you already have the table names showing up in the DropdownList, here's a step-by-step solution to bind the selected table's columns and data to your GridView:

1. Enable AutoPostBack on the DropdownList #

First, make sure your DropdownList triggers a postback when a selection is made. Update your ASP.NET markup:

<asp:DropDownList ID="DropDownListTables" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownListTables_SelectedIndexChanged">
</asp:DropDownList>

This tells the page to send a request to the server whenever the user picks a new table name.

2. Add the SelectedIndexChanged Event Handler #

In your code-behind, create the event handler that will fetch and bind the table data:

protected void DropDownListTables_SelectedIndexChanged(object sender, EventArgs e)
{
    string selectedTable = DropDownListTables.SelectedValue;
    
    // Skip if no table is selected
    if (string.IsNullOrWhiteSpace(selectedTable))
    {
        GridView1.DataSource = null;
        GridView1.DataBind();
        return;
    }

    // Replace with your actual connection string from web.config
    string connString = ConfigurationManager.ConnectionStrings["YourDatabaseConnection"].ConnectionString;
    
    using (SqlConnection connection = new SqlConnection(connString))
    {
        // Query to get all data from the selected table
        string query = $"SELECT * FROM {selectedTable}";
        SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connection);
        DataTable tableData = new DataTable();
        
        // Fill the DataTable with table schema and data
        dataAdapter.Fill(tableData);
        
        // Bind the DataTable to the GridView
        GridView1.DataSource = tableData;
        GridView1.DataBind();
    }
}

3. Protect Initial DropdownList Population #

Make sure your existing code to populate the DropdownList only runs on the first page load (not on postbacks). Otherwise, the DropdownList will reset every time you select a table:

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // Your existing code to load table names into DropdownList goes here
        LoadDatabaseTableNames();
    }
}

4. Critical: Prevent SQL Injection #

Since you're using user-selected table names directly in a query, you need to validate the selection to avoid security risks. Add a check to ensure the selected table name is actually present in your database:

// Inside DropDownListTables_SelectedIndexChanged
// Assume you have a method that returns all valid table names from your database
List<string> validTables = GetAllDatabaseTableNames();

if (!validTables.Contains(selectedTable))
{
    // Invalid selection - clear GridView and show error if needed
    GridView1.DataSource = null;
    GridView1.DataBind();
    // Optional: LabelError.Text = "Invalid table selection";
    return;
}

// Proceed with binding if table is valid

Common Issues to Check #

• Connection String: Double-check that your connection string in web.config is correct and points to the right database.
• GridView Properties: Ensure your GridView doesn't have hardcoded columns (unless you want to mix auto-generated and custom columns). If you want auto-generated columns, set AutoGenerateColumns="True" in the GridView markup:

  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="True"></asp:GridView>
  

• Permissions: Make sure the database user in your connection string has read access to all the tables you're trying to display.

内容的提问来源于stack exchange，提问作者Leon James