Error SqlConnection and SQLCommand is not defined

jyakomor...

SOLVED CLOSED ACTIVE ANSWERED
User: jyakomorossi
Posted: on Apr 11, 2024 10:36 PM
Forum: ASP.Net Web Forms
Replies: 9
Views: 1919

Article: ExecuteNonQuery: Insert Update and Delete examples in C# and VB.Net

Hello, I'm in the process of converting VBA to VB.NET with SQL statements. One of the changes is utilizing th"e "ExecuteNonQuery. Sincee I'm still learning the syntax, I simply copied the VB.NEt statements above for the "UPDATE Persons SET CITY . . . ". But I'm getting 2 errors: #1. error "BC3002 Type 'SqlConnection' is not defined" and #2. error BC3002 Type 'SQLCommand' is not defined" when compiling using Visual Studio. And I included the 2 IMPORTS as well, but still these 2 compiler errors. What am I doing wrong? Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

mohammad...

0 6

Reply
User: mohammadumarsk684
Replied: on Apr 12, 2024 12:42 PM
Report

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.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Error SqlConnection and SQLCommand is not defined

Company

Explore

Follow us

Contact Us