How do I verify if a record is posted

Question

1.00/5 (1 vote)

See more:

I am trying to make a button on a forms page that when clicked it will verify if the form has been filled out for that day returning a message saying that it is done or not done. Here is my code behind on the button click:

VB.NET

Protected Sub ButtonCheck_Click(sender As Object, e As EventArgs) Handles ButtonCheck.Click

        Dim Conn As New SqlClient.SqlConnection
        Conn = New SqlConnection("Data Source=VS15IIS01; Initial Catalog=Maintenance;User ID=sa;Password=Password;")
        Conn.Open()

        If ("SELECT TEST_DATE FROM GeneratorHealthCheck WHERE CONVERT(date,TEST_DATE) = CONVERT(date,getdate())") Then
            MsgBox("Done")
        Else
            MsgBox("Not Done")
        End If
        Conn.Close()
    End Sub

What I have tried:

I chave tried the above but I keep getting an error.

Posted 21-Mar-16 8:41am

Member 11598884

Updated 21-Mar-16 20:40pm

v2

Add a Solution

Comments

ZurdoDev 21-Mar-16 15:05pm

Please do not make us guess the error.

Richard Deeming 21-Mar-16 16:05pm

I hope that's not your real sa password that you've just posted to a public forum.

And why is your application connecting as sa anyway? You should be using an account which has only the permissions required for your application, not a god-level user which can be used to destroy your entire network.

2 solutions

Solution 1

~~Asking questions is a skill[^]~~
Weird things append here, This answer was intend to be a comment for another question and I did not edit the question. My reputation points even say that I reported the question.
I don't understand.

Posted 21-Mar-16 10:07am

Patrice T

Updated 21-Mar-16 10:36am

v2

Comments

Serkan Onat 21-Mar-16 16:55pm

Answering questions require same skills :)

Patrice T 21-Mar-16 16:58pm

I know :)

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)

Engr. S.M. Inuwa · Accepted Answer · 2016-03-21T20:40:00

you can do it in many ways. but try this one

VB

'create a variable
Dim result as string

'try connect to your database connections string as you did earlier
Dim Conn As New SqlClient.SqlConnection
Conn = New SqlConnection("Data Source=VS15IIS01; Initial Catalog=Maintenance;User ID=sa;Password=Password;")
        
Conn.Open()
'select the record to check if there is data,
Dim str as String = "SELECT TEST_DATE FROM GeneratorHealthCheck WHERE CONVERT(date,TEST_DATE) = CONVERT(date,getdate())"
'execute the command
Dim cmd as new sqlCommand(str, Conn)
'read the data
Dim dr as New SQLDataReader
dr = cmd.executeReader

'now check if the query return a value
if dr.hasRows then
    dr.read()
    result = dr("TEST_DATE").ToString
End If



'now! check if result has value

If result <> nothing Then
            MsgBox("Done")
        Else
            MsgBox("Not Done")
        End If
conn.close()

i am sure this would work for you.