DataGrid control

Results 1 to 2 of 2

Thread: DataGrid control

  1. #1
    Join Date
    Dec 1969

    Default DataGrid control

    I am using a datagrid to populate data from a sql server database. I have a date field in tha table, when populating this column in the datagrid the value becomes &#039;1/1/1900&#039;, so I want to format this in the datagrid control to be converted to null value like ""<BR>this is the code line<BR><BR>&#060;asp:BoundColumn DataField="IssueDate" HeaderText="date" DataFormatString="{0:d}"&#062;&#060;/asp:BoundColumn&#062;<BR><BR>So I want to use something like:<BR>if date = &#039;1/1/1900&#039; then<BR>date = ""<BR>end if<BR><BR>How can I do this?

  2. #2
    Join Date
    Dec 1969

    Default RE: DataGrid control

    You can use IsNull function from your query or stored procedure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts