"How to make the DataGridView output only the data that I want?

Question

0.00/5 (No votes)

See more:

VS2010

Db: access
im using Visual studio 2010

what syntax to use for making the datagridview output only the data that is in the database only using for example Birthdate = date today not the year..

im making this bday reminder program, just a simply day to day reminder who will be having a birthday.

<img src="http://i.imgur.com/fVqPfse.jpg" title="source: imgur.com" />

I already coded the insert data, now i just want to view the data that has birthday with the same date (not including the year) just by using the Month and Date.

Posted 30-Oct-14 17:48pm

Member 11194404

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Robert Welliever · Answer 1 · 2014-10-30T18:26:00

I'm not sure I have the syntax correct as I don't want to open Access and find out, but the idea is that you use the DatePart function in Access. You can compare parts of dates with it. Try something like:

SQL

SELECT * FROM BIRTHDAY_TABLE
WHERE DatePart ("m", [BDAY_FIELD]) = DatePart("m",Date()) AND
DatePart("d",[BDAY_FIELD]) = DatePart("d",Date())

(There might be a DatePart arg that allows comparison for month and day without the year in a single comparison)

Member 11194404 · Answer 2 · 2014-10-30T20:29:00

kinda confused on this part.. =/

VB

If Not con.State = ConnectionState.Open Then
            con.Open()
        End If

        Dim da As OleDb.OleDbDataAdapter
        Dim Sql As String

        Sql = "SELECT * FROM bene_records where b_date" ''<---This part....I dont know what to do next..
        da = New OleDb.OleDbDataAdapter(Sql, con)

        Dim dt As New DataTable
        da.Fill(dt)

        con.Close()

"How to make the DataGridView output only the data that I want?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0