Darkmatter5
New member
- Joined
- Mar 30, 2012
- Messages
- 1
- Programming Experience
- 1-3
Here's the statement
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:
Thanks in advance for any help!
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!