By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Calendar

P: n/a
I'm having a problem

I would like to display data to a datagrid
I using a Calendar
When i klik to a calendar i will put a begin date and an end date into a textbox(txtBeginDate And txtEndDate)
The code is: txtBeginDate.Text = Calendar.SelectionStart And txtEndDate.Text = Calendar.SelectionEn

I have made a OleDBDataAdapter And a SQL statement like this: It does not wor
Dim objADa As New OleDbDataAdapter
("SELECT User, ID, Date FROM Work WHERE Date BETWEEN txtBeginDate.text And txtEndDatetext", objConn

objADa .Fill(objDataset

DataGrid.PreferredColumnWidth = 10
DataGrid.DataSource = objDataset.Tables(0

if I try this, it wil work
Dim objADa As New OleDbDataAdapter
("SELECT User, ID, Date FROM Work WHERE Date BETWEEN #1-01-2004# AND #21-01-2004#", objConn

Can somebady help me with this problem

Nov 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.