I want to select data from of next coming 15 days from database

Question

0.00/5 (No votes)

See more:

.NET4.5

i am making an app for gate pass expiry
so in main form i put one data grid view the data grid view will show the data of expiring gate passes in next 1 month

i write the below code but it is showing the list of gate passes which are going to expire in next 2 months also

please help

What I have tried:

Private Sub MDIParent1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
expiryalert()
End Sub
Public Sub expiryalert()
Try
Dim da As New SqlDataAdapter
Dim ds As New DataSet
Dim cmd As SqlCommand
connection()
cmd = New SqlCommand("select * from gatepassdetails where expiry > '" & Format(Today.AddMonths(1), "MM/dd/yyyy") & "'", connsql)
da.SelectCommand = cmd
da.Fill(ds, "gatepassdetails")
data_expired.DataSource = ds
data_expired.DataMember = "gatepassdetails"
Catch ex As Exception
MsgBox(ex.Message.ToString)
connsql.Close()
End Try
End Sub

Posted 1-Dec-16 1:52am

sufyankadri

Updated 1-Dec-16 2:24am

Add a Solution

Comments

ZurdoDev 1-Dec-16 8:10am

Don't you want where expiry is < ?

sufyankadri 1-Dec-16 8:13am

thanks for your help.

King Fisher 1-Dec-16 8:18am

use between operator:
select * from gatepassdetails where expiry between 'today' and 'endDate'

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)

ZurdoDev · Accepted Answer · 2016-12-01T02:17:00

Solution 1

As mentioned in the comments, what you really want to use is less than. If you translate it into English, what you currently have is where the expiry date is later than a month from now. What you really want is what is less than a month from now. I'm not sure if your system needs it or not but you may want to include and greater than or equal to today's date.

Posted 1-Dec-16 2:17am

ZurdoDev

Comments

sufyankadri 1-Dec-16 8:21am

thanks
i need i should get alert before one month of expiry
again thanks for your solution.

OriginalGriff · Accepted Answer · 2016-12-01T02:24:00

Solution 2

Rather than using AddMonths and Format (plus a string concatenation) consider using DATEADD:

VB

cmd = New SqlCommand("SELECT * FROM gatepassdetails WHERE expiry < DATEADD(mm, 1, GETDATE())", connsql)

Which keeps it all inside SQL.

Posted 1-Dec-16 2:24am

OriginalGriff