Hello,
I have a vb.net page and sql server 2008 back end.
I got an error: incorrect syntax near ','.
I have been researching and I tired different ways but no luck. Please point me to the right direction. I checked the syntax and it is correct to me.
Thanks.
I have a vb.net page and sql server 2008 back end.
I got an error: incorrect syntax near ','.
I have been researching and I tired different ways but no luck. Please point me to the right direction. I checked the syntax and it is correct to me.
Thanks.
Code:
Private Sub getCounts(ByRef GuestCount As Label, ByRef ReservationCount As Label, ByVal SqlDataSource1 As SqlDataSource)
Dim dv As DataView
dv = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView) [b]****Error here****[/b]
Dim dr As DataRow
Dim iReservationCount As Integer = 0
Dim iGuestCount As Integer = 0
For Each dr In dv.Table.Rows
iGuestCount = iGuestCount + dr("PartySize")
iReservationCount = iReservationCount + 1
Next
GuestCount.Text = iGuestCount.ToString()
ReservationCount.Text = iReservationCount.ToString()
End Sub