How to view data between two dates in vb.net using the datetimepicker

Question

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
    Dim cn As New SqlConnection
    Dim ds As New DataSet
    Dim dt As New DataTable
    Dim dfrom As DateTime
    Dim dto As DateTime
    Dim da As New SqlDataAdapter

    dfrom = dtpicker1.Text
    dto = dtpicker2.Text

    cn.ConnectionString = "Data Source=JMI-PC\SQLEXPRESS;Initial Catalog=student_system;User Id=ian;Password=rockstar"
    cn.Open()
    Dim str As String
    Format(dtpicker1.Text, "yyyy-MM-dd")
    Format(dtpicker2.Text, "yyyy-MM-dd")
    str = "select Exam_Date from class1  where Exam_Date= '" & dtpicker1.Text & "' and Exam_Date='" & dtpicker2.Text & "'"

    da = New SqlDataAdapter(str, cn)
    da.Fill(dt)
    DataGridView1.DataSource = dt
    DataGridView1.DataSource = dt


End Sub

i am trying to view data between two dates using the datetimepicker and when i try to run this code i get an error aying " Conversion failed when converting date and/or time from character string." if anyone can show me how its done, i would really appreciate it

liquidsnake786 · Accepted Answer · 2013-11-29 13:15:37Z

2

You need to check your date range in your SQL statment

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click

Dim cn As New SqlConnection
Dim ds As New DataSet
Dim dt As New DataTable
Dim dfrom As DateTime = dtpicker1.Value
Dim dto As DateTime = dtpicker2.Value


cn.ConnectionString = "Data Source=JMI-PC\SQLEXPRESS;Initial Catalog=student_system;User Id=ian;Password=rockstar"
cn.Open()
Dim str As String = "select Exam_Date from class1  where Exam_Date >= '" & Format(dFrom, "MM-dd-yyyy") & "' and Exam_Date <='" & Format(dto, "MM-dd-yyyy") & "'"

Dim da As SqlDataAdapter = New SqlDataAdapter(str, cn)
da.Fill(dt)
DataGridView1.DataSource = dt

End Sub

edited Nov 29, 2013 at 13:15

answered Nov 28, 2013 at 11:17

liquidsnake786

4472 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gareth Over a year ago

I think it's nicer to use BETWEEN when getting a date range, what do you think? e.g. SELECT Exam_Date FROM class1 where Exam_Date BETWEEN x AND y. Also, your code seems to cause the error 'Value' is not a member of 'Date, remove the value bit

Collectives™ on Stack Overflow

How to view data between two dates in vb.net using the datetimepicker

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related