ASP.NET GridView无法显示SQL Server查询数据 求助

Hey there! Let's walk through why your GridView isn't showing data even though the SQL query is executing. Here are the most common fixes and checks to try:

• Don’t forget the critical DataBind() step
  It’s easy to call Fill() on your DataAdapter but skip binding the data to the GridView. Make sure after filling your DataTable/DataSet, you do both:

  SqlDataAdapter adapter = new SqlDataAdapter(yourQuery, yourConnection);
  DataTable dt = new DataTable();
  adapter.Fill(dt);
  
  // These two lines are non-negotiable!
  yourGridViewID.DataSource = dt;
  yourGridViewID.DataBind();
  

• Verify if Fill() actually returned data
  Add a quick debug check right after Fill() to confirm your DataTable has rows:

  System.Diagnostics.Debug.WriteLine($"Rows in DataTable: {dt.Rows.Count}");
  

  If the count is 0, your SQL query might be returning empty results—even though it executed. Try running the exact query from SQL Server Profiler directly in SSMS to see if it returns data. This could mean your TextBox input isn’t matching database records, or your WHERE clause is too restrictive.

• Check GridView configuration

  • Ensure AutoGenerateColumns="true" (if you’re not manually defining columns) or that your manually added columns match the DataTable’s field names exactly.
  • Double-check the GridView’s Visible property isn’t accidentally set to false.

• Catch hidden exceptions
  Wrap your Fill() call in a try-catch block to spot any silent errors that might be preventing data loading:

  try
  {
      adapter.Fill(dt);
  }
  catch (Exception ex)
  {
      System.Diagnostics.Debug.WriteLine($"Error filling data: {ex.Message}");
  }
  

• Fix page lifecycle conflicts
  If you’re binding data in the Button Click event, make sure you’re not overwriting it in Page_Load without checking for postbacks:

  protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          // Only run initial load logic here—don't bind query data here
      }
  }
  
  protected void YourSubmitButton_Click(object sender, EventArgs e)
  {
      // Put your query, Fill(), and GridView binding code here
  }
  

If none of these steps resolve the issue, sharing your full data-binding code and the ASPX markup for your GridView would help narrow things down further!

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