954,515 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

retrieving record based on date

i want to retrieve record basing on date.
i have used backend as ms access and frontend as vb.net.
cmd = New OleDbCommand("select * from orders where qdate= '" + TextBox2.Text + "'", cn)

pavanikatari
Newbie Poster
2 posts since May 2008
Reputation Points: 10
Solved Threads: 0
 

plz help me

pavanikatari
Newbie Poster
2 posts since May 2008
Reputation Points: 10
Solved Threads: 0
 
cmd = New OleDbCommand("SELECT * FROM orders where YearBorn LIKE '%" & Trim(TextBox2.Text) & "%'")
Jx_Man
Nearly a Senior Poster
3,329 posts since Nov 2007
Reputation Points: 1,372
Solved Threads: 444
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You