Fitlering in Visual Basic Report

[reycons]

I have a textboxt and which I input the lastname of a particular person like for example Cortez so all the record that has a lastname of cortez thats only it shows in the table

Can anyone give me a sample code in visual basic that filter the records in the table and that record that it filter thats the only record it shows in the report.

Thanks in advance....

 

[SkipVought]

Hi,

sSQL = "Select * "
sSQL = sSQL & "From YourTable "
sSQL = sSQL & "Where Customer='" & TextBox1.Text & "'"

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[johnwm]

If this is for a real-life application rather than an academic one, then search this site and google for 'sql injection'

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints