The connection string is currently, is this the correct way to go about it.
Dim connstring As String = "Data Source=BM-PC;Initial Catalog=EMS;Integrated Security = True;TrustedConnection=YES;User Id=u;Password=p;
I have a vb.net application, which I want to access a sql server 2005 from a remote workstation.
When I run the application I get the following exception
System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'.
I have the following class definition
Public Class Car
Public ReadOnly MaxSpeed As Integer
Private CurrSpeed As Integer
Public Sub New()
Public Sub New(ByVal max As Integer)
MaxSpeed = 55
Public Property Speed() As Integer
Bolds and Arrows is another part of the criteria - each selection must have at least 1 bold and 1 arrow hence the > 1 but as this is easier to implement I've only just mentioned it.
I'll look at adding race = @race as you suggested, at the moment however from the main screen they select if they...
Both SELECT * FROM VsrData WHERE (B IN (SELECT MAX(B) FROM VsrData)) AND (FDB IN (SELECT MIN(FDB) FROM VsrData)) and bolds > 1 and arrows > 1 and SELECT * FROM VsrData WHERE (B IN (SELECT MAX(B) FROM VsrData)) AND (FDB IN (SELECT MIN(FDB) FROM VsrData)) and bolds > 1 and arrows > 1 ORDER BY...
Yes that is the expected behaviour, as a result the number of times the selection criteria is met for the daily analysis can vary and on some occasions there may not even be any selections.
The reason I highlighted that table was because your previous code identified a wrong selection.
I believe the last query example you provided me with was
SELECT TOP(3) * FROM VsrData ORDER BY (B - FDB) DESC
I modified your code as follows - Dim sql As String = "SELECT * FROM VsrData where bolds > 1 and arrows > 1 ORDER BY (b-fdb) desc, Jockey DESC, TRAINER desc"
When I run that as a...
Actually its B the highest and FDB the lowest, so the first example (5-2) would indicate a selection and the others would be disregarded.
B - FDB
5 - 2
4 - 3
3 - 4
2 - 5
The majority of the time we will always produce the 3 best, the only exception is on the rare occasion where there are only...
The screen captures I provided are from a daily racing analysis we provided, we have two sets of criteria used to identify different types of bets.
We only bet if the criteria highlights selections on the first or second row of each group of 3.
One of the common factors for all selections is...
I am looking at criteria which will help me identify the two examples as illustrated in the screen capture below.
There are two types of selection criteria but both requre highest B and lowest fdb values.