ASP.NET Discussion - Needs Help With Adding an If Statement

Print Page | Close Window

Needs Help With Adding an If Statement

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16834
Printed Date: 28 March 2026 at 5:58pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Needs Help With Adding an If Statement

Posted By: Misty
Subject: Needs Help With Adding an If Statement
Date Posted: 07 October 2005 at 1:52am

Please look at the code below. Please look at the bolded line of code. I'd like to add some code to let an event show up if the EventStartDate has a value and the EventEndDate doesn't have a value. For example, there may be some one day events. I am not sure how to do this. Could someone please help me with this? I got the following error message when there was just an one day event with the EventEndDate field null.

strSQL = " SELECT * FROM EVENTS WHERE (EventStartDate >= '" & datCalendarStart.ToString() & "' " & _
" AND EventStartDate <= '" & datCalendarEnd.ToString() & "') OR (EventEndDate >= '" & datCalendarStart.ToString() & "' " & _
" AND EventEndDate <= '" & datCalendarEnd.ToString() & "') OR (EventStartDate <= '" & datCalendarStart.ToString() & "' " & _
" AND EventEndDate >= '" & datCalendarEnd.ToString() & "') ORDER BY EventStartDate "

        myCommand = New SqlCommand( strSql, Conn)

        Conn.Open()

        myReader = myCommand.ExecuteReader()

lblDates.Text = " Events for the month of " & calCalendar.SelectedDate.ToString("MMMM yyyy") & " "

' Always call Read before accessing data.
 While myReader.Read()

 lblDates.Text &= myReader.GetDateTime(2).ToString("MM/dd/yy") & " - " & myReader.GetDateTime(3).ToString("MM/dd/yy") & " "

lblDates.Text &= "<a href=""DisplayEvent.aspx?EventID=" & myReader.GetInt32(0).ToString() & """ >" & myReader.GetString(1).ToString() & "</a> "
lblDates.Text &= myReader.GetString(5).ToString() & " "
End While

Replies:

Posted By: michael
Date Posted: 07 October 2005 at 10:18am

Without looking into your problem specifically, I have a Timesheet app I developed and all events that are startdate=enddate I set both fields with the same date, that would eliminate and NULL problems, you can set a rule on SQL Server that if the enddate IS NULL THEN endate=startdate

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Misty
Date Posted: 07 October 2005 at 10:28pm

I actually want it to show a date like 10/07/2005 if it's just an one day event. I've figured out how to do it.

Here's the code:

' Always call Read before accessing data.
While myReader.Read()

If myReader("EventStartDate").ToString.Length <> 0 AndAlso myReader("EventEndDate").ToString.Length = 0 Then
 lblDates.Text &= myReader.GetDateTime(2).ToString("MM/dd/yy") & " "
 Else

lblDates.Text &= myReader.GetDateTime(2).ToString("MM/dd/yy") & " - " & myReader.GetDateTime(3).ToString("MM/dd/yy") & " "
 End If
 lblDates.Text &= "<a href=""DisplayEvent.aspx?EventID=" & myReader.GetInt32(0).ToString() & """ >" & myReader.GetString(1).ToString() & "</a> "
 lblDates.Text &= myReader.GetString(5).ToString() & " "
 End While