Hi All,
I am using a datagrid to display records from my database. I have one datagrid which displays all the records and this works fine. I also have a datagrid which only displays records where location is equal to "belgium", this also works fine. My problem however is that when displaying the belgium records there may only be one or 2 records yet the grid still takes up most of the page where the header and footer is enlarged ridiculously.
When there are many records that fill the grid it looks fine but when there is only one or 2 it resizes the column as such.
Could anyone please tell me why this happens??
Thanks alot for your help!