I am going to create a report to show all the computer names that in a provided IP range.
On the report, user will find two input boxes that ask for the ip range.
e.g. input box 1 = 192.168.001.001, input box 2 = 192.168.001.100.
The report will show me the computer names within this ip range.
My question is how can I add two parameters in the query? If there is only one parameter, I can use 'Address LIKE ?',
but how about two parameters? 'Address BETWEEN LIKE ? and ?' ?
Yes, it exactly the way to do it.
You need to create 2 parameters (input 1 and input 2), then declare both of them in your DataSet.
The order of declaration of the parameters is important here ! Because the 1st parameter will be the 1st "?" in your query, and the 2nd one will be the 2nd "?".
Then your query should be something like :
"select .... from ... where Addresse BETWEEN ? AND ?"
The result should be someting like this