THIS IS MY CODE.... bUt i am not getting the data between the given dates IN THE DATAGRID VIEW
Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= C:\Users\Anand\Documents\db.accdb"

    Dim dfrom As DateTime = DateTimePicker2.Value
    Dim dto As DateTime = DateTimePicker1.Value

    Dim SQLString As String = "SELECT * FROM cc WHERE Produced Between '" & DateTimePicker2.Value.Date & "' AND '" & DateTimePicker1.Value.Date & "'"

    Dim OleDBConn1 As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConnString)
    Dim DataSet1 As New DataSet()
    Dim OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(SQLString, OleDBConn1)
    OleDbDataAdapter1.Fill(DataSet1, "cc")
    DataGridView1.DataSource = DataSet1.Tables("cc")

    Dim total As Integer
    For Each row As DataGridViewRow In DataGridView1.Rows
        total += row.Cells("Total").Value
    TextBox2.Text = total

    Dim trejects As Integer
    For Each row As DataGridViewRow In DataGridView1.Rows
        trejects += row.Cells("TRejects").Value
    TextBox1.Text = trejects

End Sub
ROBBIN MCHINZI commented: The first thing you need to do is to make sure that your data field is specified ad date and then your code should look like. e.g select* from cc where date= datetimer1 between datetimer2 +0

Recommended Answers

All 2 Replies

Your first problem is, this is the wrong forum. You want the VB.NET forum.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.