Does anyone know how to retrieve all dates from a selectionrange :

I would like to select from 11/1/2003 to 11/7/2003 now I can put the Stop and End dates in text boxes. But I would like to place the dates 11/2, 11/3, 11/4 , 11/5, 11/6 into a Database. This will help me with certain Queries I have to create.


txtStart.Text = MonthCalendar1.SelectionRange.Start.ToShortDateStr ing
txtEnd.Text = MonthCalendar1.SelectionRange.End.ToShortDateStrin g

Please Help

Thank you everyone help,

I have figured it out...

How do I format a field from Access Database which is placed in a Datafield. The result of my Dataset fill returns a full date, for the 'StartTime' and 'EndTime' when all I want is the time? * Please note that in Access I have the field properties shown correctly..

Dim conStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\DATA\ACCESS\NameDatabase"
            Dim strSQL As String = "SELECT [ItemName], [StartDate],[Requests].[StartTime],[EndDate],[EndTime],[Name] FROM(Requests) "
            strSQL = strSQL & "WHERE (([ItemName]= '" & nItem & "')"
            strSQL = strSQL & "AND (([StartDate])"
            strSQL = strSQL & "BETWEEN #" & kStart & "#"
            strSQL = strSQL & "AND #" & kStop & "#));"

            Dim conn As OleDbConnection = New OleDbConnection(conStr)
            conn.Open()
            Dim da As OleDbDataAdapter = New OleDbDataAdapter(strSQL, conn)

            Dim ds As DataSet = New DataSet()
            da.Fill(ds, "Requests")
            Dim dv As DataView = ds.Tables("Requests").DefaultView
            DataGrid1.DataSource = dv
            conn.Close()