Updating DataGridView

[systemwolf]

I'm new to SQL and I'm having problems getting a search function to work with the data grid view. I've got a form set up for the search function with multiple text boxes for the user to enter information and a function that performs that search via the table adapter. My search function looks like this:

SELECT     Amount, Date, Department, PO_Numbers, Requester
FROM         PO
WHERE     (Amount = 'txtSearchAmount.Text') OR
                      (Requester = 'txtSearchRequester.Text') OR
                      (Department = 'txtSearchDepartment.Text') OR
                      (PO_Numbers = 'txtSearchPO.Text')
ORDER BY PO_Numbers DESC

I can't figure out how to get that result to display in the data grid view though. Any suggestions as to how to resolve this, or a better way to achieve the same result would be greatly appreciated. Thanks in advance.

Edit: Forgot to mention I'm using visual studio 2005, and sql server 2005.

[brucevde]

When creating a dynamic sql string you need to append the Values of the textboxes to the string.

Dim strSQL as String = "SELECT Amount, Date, Department, PO_Numbers, 
Requester FROM PO WHERE  (Amount = " & txtSearchAmount.Text & ") Or (Requester = '" & txtSearchRequester.Text & "') Or ..."

Also, do not delimit numeric values within single quotes.

[systemwolf]

Thanks for the help! I got that updated, but how do I set the data grid viewer to show that result? I thought it would be:

Me.DataGridView1.DataSource = POTableAdapter.Search

but no such luck.