Click here to Skip to main content
15,559,491 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I want to show data from ms access in datagrid where a certain data is greater than 14

What I have tried:

ElseIf GunaComboBox1.SelectedItem = "Overdue" Then
MyConnection1.ConnectionString = connString1
dbds = New DataSet
tables = dbds.Tables
dbda = New OleDbDataAdapter("Select [Borrowingnumber],[Lname],[Fname],[Section],[BookID],[Bookname],[Dateborrow],[Timeborrow] from Numdaysq Where Days='" > 14"'", MyConnection1)
dbda.Fill(dbds, "Numdaysq")
Dim view As New DataView(tables(0))
source.DataSource = view
GunaDataGridView1.DataSource = view
End If
Updated 6-Jun-22 19:04pm

1 solution

dbda = New OleDbDataAdapter("Select [Borrowingnumber],[Lname],[Fname],[Section],[BookID],[Bookname],[Dateborrow],[Timeborrow] from Numdaysq Where Days > 14", MyConnection1)
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900