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

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

jyakomor...

0 7

Reply
User: jyakomorossi
Replied: on Apr 13, 2024 04:31 AM
Report

Thanks for your feedback. I made the change to the method, making it Protected as well as Public. I'm still getting the 2 errors, not sure why since we are talking about 1 IMPORTS statement and 2 stateements consisting of SqlConnection and SqlCommand. I think there is something else causing these 2 errors, but I don't know what. Unless I hear otherwise, I'll start a new project, limiting the inital coding to these 3 statements (IMPORTS and SQLxxxx) . . . don't know what else to do. Any other suggestions? Thanks again for your help.

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