Apr 08, 2012 10:22 PM|I-Weedy|LINK
My code below displays todays date and the month as a number (April = 4, May = 5 etc) in a label (Label4)
Dim myDateTime As DateTime = DateTime.Now
Dim month As String = myDateTime.Month.ToString()
Label4.Text = "<b>Todays Date:</b> " & DateTime.Now.ToLongDateString()
Label4.Text += "<br /><b>Period:</b>" & month
What I want to do is add the variable value output by the label into a select statement ( Where id = ' & month') however I'm met with an error '
Now I realise that my Id is an integer and the month is a string how can i get the value into my select statement without this error happening?