I need help figuring out why my LINQ to SQL statement won't work

Darkmatter5

New member
Joined
Mar 30, 2012
Messages
1
Programming Experience
1-3
Here's the statement

VB.NET:
[COLOR=#000000][FONT=verdana]Dim jobs = From job In db.jobs[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Join client In db.clients On job.ClientID Equals client.ClientID[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Join employee In db.employees On job.EmployeeID Equals employee.EmployeeID[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Join area In db.areas On job.JobID Equals area.JobID[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Select job.JobID, job.ClientID, job.EmployeeID, _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]job.JobNumber, Description = job.JobDescription, Location = job.JobLocation, Memo_info = job.JobMemo_info, _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]FirstName = client.ClientFirst_name, LastName = client.ClientLast_name, Company = client.ClientCompany_name, _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]EmpLastName = employee.EmployeeLast_name, EmpFirstName = employee.EmployeeFirst_name, _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]area.Area
[/FONT][/COLOR][COLOR=#000000][FONT=verdana]Where (Description.Contains(tbSrcTextString.Text)) _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Or (Location.Contains(tbSrcTextString.Text)) _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Or (LastName.Contains(tbSrcTextString.Text)) _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Or (FirstName.Contains(tbSrcTextString.Text)) _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Or (Company.Contains(tbSrcTextString.Text)) _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Or (EmpLastName.Contains(tbSrcTextString.Text)) _[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Or (EmpFirstName.Contains(tbSrcTextString.Text))[/FONT][/COLOR]

If I search for a string that is known to be in the database, why am I getting zero results?

Here's my sub routine code:

VB.NET:
Private Sub btnSrcTextString_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSrcTextString.Click
        Dim db As New byrndbDataContext
        pbSearch.Value = 0
        incProgressBar(25)


        'SEARCH BY JOB NUMBER OR TEXT STRING OR ACERAGE RANGE
        Dim jobs = From job In db.jobs
                   Join client In db.clients On job.ClientID Equals client.ClientID
                   Join employee In db.employees On job.EmployeeID Equals employee.EmployeeID
                   Join area In db.areas On job.JobID Equals area.JobID
                   Select job.JobID, job.ClientID, job.EmployeeID, _
                   job.JobNumber, Description = job.JobDescription, Location = job.JobLocation, Memo_info = job.JobMemo_info, _
                   FirstName = client.ClientFirst_name, LastName = client.ClientLast_name, Company = client.ClientCompany_name, _
                   EmpLastName = employee.EmployeeLast_name, EmpFirstName = employee.EmployeeFirst_name, _
                   area.Area
                   Where (Description.Contains(tbSrcTextString.Text)) _
                   Or (Location.Contains(tbSrcTextString.Text)) _
                   Or (LastName.Contains(tbSrcTextString.Text)) _
                   Or (FirstName.Contains(tbSrcTextString.Text)) _
                   Or (Company.Contains(tbSrcTextString.Text)) _
                   Or (EmpLastName.Contains(tbSrcTextString.Text)) _
                   Or (EmpFirstName.Contains(tbSrcTextString.Text))
                   Order By JobNumber Ascending
        incProgressBar(50)


        With dgvSrcResults
            .DataSource = jobs
            .Columns("JobID").Visible = False
            .Columns("ClientID").Visible = False
            .Columns("EmployeeID").Visible = False
        End With
        incProgressBar(75)


        lbSrcResults.Text = jobs.Count() & " record(s) found"
        incProgressBar(100)
    End Sub

Thanks in advance for any help!
 
Back
Top