hi
i am a vb with datagrid view on it displays all the data from my database
however i want to put a option to add where the user can select the date from when to when and it displays the data.

at the monet i have use this code but when i click it after selecting the date nothing happens
Dim sqlQuery As String = "SELECT * FROM MyTable WHERE DateColumn BETWEEN @param1 AND @param2"
Thanks

Recommended Answers

All 4 Replies

Are you using SQL or MS Access DB? For MS Access, you need to prefix and suffix # symbol like #10/10/2014#

Both also got once i use the SQl and another time i use the local database created using vb under create a new databse

I ned help on this can anyone help me pls

What database? Post more of your code.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.