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"

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

What database? Post more of your code.