asked on
Conversion from string "Timeofday" to type 'Integer' is not valid.
Conversion from string "Timeofday" to type 'Integer' is not valid.
dvholidays = New DataView(dtholidays, "Date = '" & CDate(e.Day.Date) & "' and Username = 'Perkinsj'", "", DataViewRowState.CurrentRows)
If dvholidays.Item("Timeofday").ToString IsNot "" Then
Dim iamoff As String = dvholidays.Item("Timeofday").ToString
' Dim iamoff As String = dateallreadybooked.havei(e.Day.Date, "Perkinsj")
Select Case iamoff
Case "Am"
am.ImageUrl = "Images/Dark_Blue_Button.jpg"
am.Enabled = True ' enable the button so the user can change this if they no longer want the day booked
Case "Pm"
pm.ImageUrl = "Images/Dark_Blue_Button.jpg"
pm.Enabled = True ' enable the button so the user can change this if they no longer want the day booked
Case "full"
full.ImageUrl = "Images/Dark_Blue_Buttonlarge.jpg"
full.Enabled = True ' enable the button so the user can change this if they no longer want the day booked
End Select
End If
Visual Basic.NETASP.NET.NET Programming
Last Comment
kaufmed
ASKER
dvholidays should reutn 1 row or null anyway
then you can save reukt in string variable
Dim myDRV As DataRowView
Dim timeofday As String
timeofday = ""
For Each myDRV In dvholidays
For i = 0 To myView.Table.Columns.Count
timeofday = myDRV(i)
Next
Next
then work on this variable
if you know exact column number , use that
For Each myDRV In dvholidays
timeofday = myDRV(1)
Next
Dim myDRV As DataRowView
Dim timeofday As String
timeofday = ""
For Each myDRV In dvholidays
For i = 0 To myView.Table.Columns.Count
timeofday = myDRV(i)
Next
Next
then work on this variable
if you know exact column number , use that
For Each myDRV In dvholidays
timeofday = myDRV(1)
Next
There is no overload of the Item property that takes a string (i.e. column name) as its parameter. You have to index by column position.
e.g.
Also, the IsNot should be a <> instead.
e.g.
If dvholidays.Item(0).ToString IsNot "" Then
Also, the IsNot should be a <> instead.
If dvholidays.Item(0).ToString <> "" Then
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@CodeCruiser
Thanks, I thought there was, but I couldn't find it for some reason when I searched. I must have found dated documentation, or something.
Thanks, I thought there was, but I couldn't find it for some reason when I searched. I must have found dated documentation, or something.
You need to specify the row for which you want to get the value.
like
For Each myDRV In myView
For i = 0 To myView.Table.Columns.Count
Console.Write(myDRV(i) & vbTab)
Next
Console.WriteLine()
Next
refer
http://msdn.microsoft.com/en-us/library/23a0aths(v=vs.71).aspx