Checking the field value to execute conditions

Question

1.00/5 (1 vote)

See more:

Hi everyone. I want to execute an Else If condition by checking the data in Table field in sql. for example.

If the value of TableField =1 Then
(condition here)
End if

I dont really know how to code that one. I been searching in the google similar to my problem but I didn't find it.

please help me. thanks.

What I have tried:

If Val(Select DataField from Tablename) =1 Then

Me. Hide()
Form2.Show()

End if

Posted 16-Dec-16 5:05am

Member 12905345

Updated 26-Dec-16 1:42am

Add a Solution

Comments

ZurdoDev 16-Dec-16 11:24am

Is this VBA or VB?

Look for ADO.Net examples. You'll want to use SqlConnection and SqlCommand objects.

Member 12905345 16-Dec-16 20:49pm

I am using a vb. net

1 solution

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)

RDBurmon · Answer 1 · 2016-12-26T01:06:00

VB

Dim myConn As SqlConnection
     Dim myCmd As SqlCommand
     Dim myReader As SqlDataReader
     Dim results As String

     myConn = New SqlConnection("Initial Catalog=MyDataBase;Data Source=SQLServerName\SqlServerInstance;Uid=MyUser;Pwd=Pass123;")

     myCmd = myConn.CreateCommand
     myCmd.CommandText = "Select DataField from Tablename"

     'Open the connection.
     myConn.Open()
     myReader = myCmd.ExecuteReader()
     myReader.Read()
     If myReader.GetValue(0) = 1 Then
        Me. Hide()
        Form2.Show()
     End If