need help in a piece of code

Question

1.50/5 (2 votes)

See more:

Hi all

VB

Dim type As String
        Try
            Type = "select joindate from employee where emp_id='" & TextBox1.Text & "'"
            If Type > Type + 6 Then

when i am executing this the if condition giving error like can't convert to double..
please tell the problem.
what i am doing is i m taking the joining date and checking it is greater then 6 months from date or not..

Posted 25-Sep-12 0:18am

Code-Hunt

Add a Solution

Comments

JF2015 25-Sep-12 6:24am

This code doesn't make sense - what do you want to achieve?

[no name] 25-Sep-12 6:39am

i want a condition where if the joindate crosses more then 6 months then i have to enable and disable some option...
i am fetching the joining date from database

3 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)

Joan M · Answer 1 · 2012-09-25T00:25:00

Well,

Type is a string.
Then you assign "select joindate from employee where emp_id='" & TextBox1.Text & "'" to the string itself.
And then you are checking if Type is > 6.

6 is a number, not a string, and inside the Type variable you have a string with text, which can't be compared to any number.

You should first execute the database query from which you want to get the joindate and after getting the return value from that query, assign it to a numeric variable that you should compare to the 6.

Good luck!

Kuthuparakkal · Answer 2 · 2012-09-25T00:27:00

Solution 2

SQL

SELECT CASE WHEN(DATEDIFF(MM, JOINDATE, GETDATE()) > 6) THEN 1 ELSE O END AS IsQualified
FROM employee
WHERE ....

Posted 25-Sep-12 0:27am

Kuthuparakkal

Comments

[no name] 25-Sep-12 6:29am

what is IsQualified..???

Kuthuparakkal 25-Sep-12 6:32am

u change it to anything... upto you

Aarti Meswania · Answer 3 · 2012-09-25T00:31:00

VB

Dim Dt As DateTime
        Try
            Dt = GetValueFromDB("select joindate from employee where emp_id='" & TextBox1.Text & "'")
            'To Access Month
            if monthDifference(Dt,system.DateTime.Date) > 6 then
               'Enable -disable controls as your requirement
            End if

VB

Public Function monthDifference(ByVal startDate As DateTime, ByVal endDate As DateTime) As Integer
    Dim t As TimeSpan = endDate - startDate
    Dim difference As Integer = t.Days
    Dim months As Integer = Math.Floor(difference / 30.475)
    Return months
End Function

where GetValueFromDB is some function that takes input Query and gives Output value (all sql functionality are handled inside) ,
and monthDifference is function that will return difference in months when we input two dates as parameter

Happy coding!
:)

need help in a piece of code

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0