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
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.