Data is not showing up (blank grid) in MS SQL, MySql, or other database

If the grid is empty with only the header, no data displayed, you should look into the followings:

  1. First of all, check the SERVER_ROOT value in conf.php and make sure the value is set to a correct path.
    More reading:  

  2. Check if the session is working on your web server .e.g. Apache, IIS, Tomcat. Make sure the session path is set to a valid path and given written permission. Run phpinfo() to find out and look for  session.save_path 

    <?php phpinfo();?>

  3. Lastly, check the database column name including SELECT statement, primary key, foreign key, which could be case-sensitive on some systems.

  4. If you are using IIS as the web server, check your app pool setting. If it defaults to a classic ASP app pool, Switched it to another one could do the trick as pointed out by one of the our users.

Datagrid Display

  1. Cannot display datagrid in IE8, but works in Firefox
  2. Display Icon/Image In a Virtual Column
  3. Change date display format
  4. Collapse Datagrid on Initial Display
  5. Microsoft SQL Server (MSSQL) Collation and Unicode Support
  6. Data is not showing up (blank grid) in MS SQL, MySql, or other database
  7. Display datagrid somewhere else on the page
  8. Foreign characters display
  9. How to wrap text a cell?
  10. I have 3 different status (1,2 and 3) - I want to assign values to each.. active, inactive and archived .. how do I do this? If I set conditional statement , only the latest value works
  11. I want checkbox columns to display as checkboxes, not 1's and 0's.
  12. Refresh without post
  13. set_locale not working
  14. Customize Edit Form Layout
  15. How to sort phpGrid Data on two columns
  16. Column Order Position
  17. How to "crop" text so that the text won't wrap
  18. How to format text capitalization and other formats
  19. Always Display Integrated Search Toolbar When Page Load
  20. Can Virtual Column Be Used to Create New Column for Database Table?
  21. How to change the height of a row (not header row but data row)?
  22. Replacing Hyperlinks with Images
  23. Fix group sum floating (decimal) issue
  24. Resize Grid According to Current Screen Size
  25. Format UNIX Timestamp to Human Readable Time Format Using Custom Formatter
  26. Change Master Detail Grid Layout e.g. side by side
  27. Remove Duplicate Values in Group Summary
  28. Set Row Height
  29. Display a value in a cell that references a value in another table
  30. Mergy Multiple Columns in A Single Column
  31. Column Color
  32. Set the grid width to the parent DIV
  33. Make Change to phpGrid Default CSS stylesheet
  34. grid width issue
  35. PHPGrid to go to a specific page during load
  36. Example not working
  37. I just want to be able to adjust hours and minutes.
  38. Data bar solid color?
  39. Conditional format - compare two cells
  40. Escape HTML characters in datagrid
  41. Elongated grid when theme is set
  42. How to display total sum of a column of ALL the records in the footer?
  43. Set datagrid to the width of its parent DIV
  44. Display group summary without any detail records
  45. Remove horizontal scroll when set_autowidth() is set to true
  46. Displaying Header vertically
  47. HTML source is displayed with WYSIWYG

Feedback and Knowledge Base