Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query through VB.Net

Status
Not open for further replies.
richself

richself

Technical User
Jun 27, 2005
37
US
I'm searching a Access DB through a windows form. It's pretty simple but it's not returning anything if I don't fill in both fields. Here's my code.

OleDbDataAdapter1.SelectCommand.Parameters("Shift").Value = shiftTextBox.Text
OleDbDataAdapter1.SelectCommand.Parameters("Equipment").Value = equipmentTextBox.Text
DsReport1.Clear()
OleDbDataAdapter1.Fill(DsReport1)

I have the ? 's in the critera in the Query Builder.
I'm just filling a DataGrid at the moment.
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
909
Andrzejek
Andrzejek
f0rg3tfu1
  • Locked
  • Question
circular reference caused by alias in query definition
Replies
7
Views
330
strongm
strongm
sal21
  • Locked
  • Question
have error in get query, why?
Replies
1
Views
355
strongm
strongm
edenhope
  • Locked
  • Question
NAS query
Replies
5
Views
109
dilettante
dilettante
PaulBarter
  • Locked
  • Question
Conditional Compile query 1
Replies
2
Views
104
PaulBarter
PaulBarter

Part and Inventory Search

Sponsor

Back
Top