473,378 Members | 1,619 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

SQlConnection

H

I'm just getting started with vb.net standard and I'm a bit confused. I'm just trying to create a SQLConnection object in a procedure in one of my forms. I get the error 'Type SQLConnection' not defined, even tho I have the System.Data assembly refrenced in my project??

Any Ideas please??
Jul 21 '05 #1
5 3686
Hi Alan,

It is SqlConnection and not SQLConnection.

HTH,
--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Alan" <an*******@discussions.microsoft.com> wrote in message
news:D3**********************************@microsof t.com...
Hi

I'm just getting started with vb.net standard and I'm a bit confused. I'm just trying to create a SQLConnection object in a procedure in one of my
forms. I get the error 'Type SQLConnection' not defined, even tho I have the
System.Data assembly refrenced in my project??
Any Ideas please??

Jul 21 '05 #2
Cor
Hi Miha,

It is VB.net

VB is not case sensetive.

:-)

Cor

It is SqlConnection and not SQLConnection.

Jul 21 '05 #3
Cor
Hi Alan,

You can set an import to system.data.SqlClient or put for every SQL
statement

SqlClient.SqlConnection.

I hope this helps,

Cor

I'm just getting started with vb.net standard and I'm a bit confused. I'm just trying to create a SQLConnection object in a procedure in one of my
forms. I get the error 'Type SQLConnection' not defined, even tho I have the
System.Data assembly refrenced in my project??
Any Ideas please??

Jul 21 '05 #4
type this statement at the top

Imports System.Data.SqlClient
--
With Regards,
Deepak
[I code, therefore I am]
http://deepakictim.blogspot.com
"Alan" <an*******@discussions.microsoft.com> wrote in message
news:D3**********************************@microsof t.com...
Hi

I'm just getting started with vb.net standard and I'm a bit confused. I'm just trying to create a SQLConnection object in a procedure in one of my
forms. I get the error 'Type SQLConnection' not defined, even tho I have the
System.Data assembly refrenced in my project??
Any Ideas please??

Jul 21 '05 #5
Hi Cor,

"Cor" <no*@non.com> wrote in message
news:ei*************@tk2msftngp13.phx.gbl...
Hi Miha,

It is VB.net

VB is not case sensetive.

:-)


The blind spot covered the text where it was written vb.net :)
What's vb.net, anyway? ;-)

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
Jul 21 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Donnie Darko | last post by:
I'm trying to understand SqlConnection(), SqlCommand() For example. I use SqlConnection() as a parameter when I create a new SqlCommand. Then I open SqlConnection(), then I execute the...
0
by: Nayt Grochowski | last post by:
Does anyone see any problem with the loading a SqlConnection into the System.Web.HttpContextCurrent.Items collection in a Page's Constructor. Then Closing and Disposing of it the OnUnload method? ...
4
by: Lenin Vyas | last post by:
hi I would like to know whats better--- To declare a SQLConnection variable as a Static member of a Class containing functions to MakeConnection and CloseConnection, or should I just declare it...
4
by: The Coolest Dolphin | last post by:
Hi all, I have a question/problem concerning usage of my sqlconnection throughout my program. In my main form (frmMain) I defined an sqlconnection (I've set the connection public so that I can...
17
by: LP | last post by:
Hello, Here's the scenario: Object A opens a Sql Db connection to execute number of SqlCommands. Then it needs to pass this connection to a constructor of object B which in turn executes more...
1
by: Mark | last post by:
I have an SqlConnection object defined as a member of main form. I also have a thread that creates an SqlDataReader but uses the same SqlConnection object. The SqlDataReader simple loops round for...
4
by: Steve Richter | last post by:
I really miss c++ .... I have an SqlConnection object within my Web.UI.Page object. The thinking is that the connection to the database server is opened once when the page starts to do its...
9
by: Roman | last post by:
Hello I have a component built in VB.2003. It has the following property: Public Shared mCONN As SqlConnection Public Property Connection() As SqlConnection Get Return mCONN End Get...
1
by: jinfeng_Wang | last post by:
hi, I have a question about the difference between SqlConnection.IDisposable.Dispose() and SqlConnection.Dispose(). Both of them realize the function of releasing the connection to the...
4
by: Victor | last post by:
Hi Guys I have a problem here. I want to improve the performance for a website. When I looked into the system, I have found that the system made the "SqlConnection Object" static. That mean only...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.