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: 1921

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

steven

0 1

Reply
User: steven
Replied: on Apr 12, 2024 01:07 AM
Report

Hi jyakomorossi,

What namespaces (IMPORTS) are you inheriting?

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

using System.Data.SqlClient;

VB.Net

Imports System.Data.SqlClient

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