itzumar
Posts: 88
|
Posted: 02/10/2014, 8:50 AM |
|
Dear All!
I want to hide row in my report on the basis of null value of specific column. I am using code chrage studio with php and mysql. can you guide me how can i do it??????????????
_________________
Umar |
|
|
eratech
Posts: 513
|
Posted: 02/10/2014, 4:03 PM |
|
Umar
My first suggestion is to not select the records with the NULL value, and they won't appear on the report.
If you are using the Grid or Editable Grid controls, there is an event 'Before Show Row' (see Manual) which you can use to handle things on a row-by-row basis. To hide the entire row though, I'm not sure - you might need to check for the null value and then do some kind of 'exit' or 'break' to exit the code before the row is output.
You could also perhaps set the class of the row ("Set Row Style" - there is also a manual item about changing them ('Use the Before Show Event to Alter Text Color') - so you could set the RowStyle to a class that has a CSS style set to 'display:none', but I have never tried that.
Back to the first suggestion - I simply wouldn't retrieve the rows if I wasn't going to show them. Quickest and simplest.
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
anthonyzz
Posts: 19
|
Posted: 05/22/2014, 9:22 PM |
|
I am also curious about the similar question, I found some materials towards the rows in grid, hope it can be somehow helpful:
http://www.kettic.com/winforms_ui/csharp_guide/gridview_get_started.shtml
http://www.kettic.com/winforms_ui/csharp_guide/gridview_row.shtml
_________________
no more |
|
|
|