• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

ASP.net SQL Show Dates not filled in


I show the following SQL table contents on my ASP.net page, which shows the dates that
people have made entries into a database. I want to also highlight dates that haven't been entered. Not sure of the best way to achieve this. Should I perhaps have a second unbound
GridView and loop through the existing one to populate this?
Murray Brown
Murray Brown
2 Solutions
Carl TawnSystems and Integration DeveloperCommented:
I'm not 100% clear on what you are trying to achieve. But if you want to affect the display of your data based on the values in the row then you can use the RowDataBound event to customize to output.

Reference: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowdatabound.aspx
David ToddSenior DBACommented:

If the date column is a datetime column, then the value will be null

select *
from dbo.TableOfInterest
    DateColumn is null

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks for the help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now