Error SqlConnection and SQLCommand is not defined

Hi jyakomorossi,

What namespaces (IMPORTS) are you inheriting?

For SqlConnection and SqlCommand you need to import the following namespace.

C#

using System.Data.SqlClient;

VB.Net

Imports System.Data.SqlClient

Kindly share your code.

These are the 7 statements at the beginning of the .vb file:

Option Explicit On

Optioin Strict On

Imports System

Imports System.COnfiguration

Import System.Data

Import System.Data.SqlClient

Imports System.Windows.Forms

I've eliminated all of my previous code and simply included the snippet that I pasted from this web-site. And I'm still getting the 2 errors. Is there something else that I need to do?  See below for code snippet:

Private Sub YesButton_Click(sender As Object, e As EventArgs) Handles YesButton.Click
    '
    '  If here, then Alert the HOH Volunteer
    '     TBD Temporary

    Dim name As String = "Mudassar Khan"
    Dim city As String = "Pune"
    Dim constring As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As New SqlConnection(constring)
        Using cmd As New SqlCommand("UPDATE Persons SET City = @City WHERE Name = @Name", con)
            cmd.CommandType = CommandType.Text
            cmd.Parameters.AddWithValue("@Name", name)
            cmd.Parameters.AddWithValue("@City", city)
            con.Open()
            Dim rowsAffected As Integer = cmd.ExecuteNonQuery()
            con.Close()
        End Using
    End Using
End Sub     ' YesButton_Click

----- The 2 errors below ---- Severity Code Description Project File Line Suppression State Error BC30002 Type 'SqlCommand' is not defined. HOHAdminWin D:\HOHAdminWin\HOHAdminWin\Alert.vb 54 Active Error BC30002 Type 'SqlConnection' is not defined. HOHAdminWin D:\HOHAdminWin\HOHAdminWin\Alert.vb 53 Active

Hi jyakomorossi,

I checked your sample code and also included the directives you are using.

Two corrections I have made and Its working perfectly fine.

1. Make sure you write syntax of Namespaces and Directives correctly as below.

Option Explicit Off
Option Strict On

Imports System
Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient
Imports System.Windows.Forms

2. I changed the access modifier to Protected.

Why are you using Private? It needs to be acessible for event handling. So either you use Public or Protected.

Hope this will help you.