[vb.net] Oledb 날짜 범위내에서 데이타 조회

 

데이트타임픽커의 속성은 이걸로 수정 yyyy-MM-dd

DateTimePicker1.Format = DateTimePickerFormat.Custom

 

 

Dim con1 As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Users\accesslog.mdb")
Dim ds As New DataSet

Dim sql As String
sql = "select top 200 (ip),count(ip) from accesslog where date >= #" & DateTimePicker1.Text & "# and date <= #" & DateTimePicker2.Text & "# group by ip order by count(ip) desc"
Dim adapter As New OleDbDataAdapter(sql, con1)
Dim dt As New DataTable("accesslog")
adapter.Fill(dt)
DataGridView1.RowTemplate.Height = 24
DataGridView1.DataSource = dt