The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add one to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
7  5562 
Which version of the .Net framework are you running? I took your code and
copied it and pasted it into a new class in VS2005, and it worked fine. I'm
using .Net 2.0.
Also, what version of SQLServer are you using?
Robin
<la*****@yahoo.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add one to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
Robin,
I'm using .Net 2.0 with SQL Server 2005.
RobinS wrote:
Which version of the .Net framework are you running? I took your code and
copied it and pasted it into a new class in VS2005, and it worked fine. I'm
using .Net 2.0.
Also, what version of SQLServer are you using?
Robin
<la*****@yahoo.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add one to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
Weird. This is my System.Data dll location and file name. Do you have the
same thing? I think System.Data.SqlTypes is included in the System.Data.dll.
Mine is dated 9/23/2005 7:28 AM.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Syst em.Data.dll
Also, I assume you're using VS2005? yes?
If you bring up the Object Browser in VS2005 and look under System.Data, do
you see System.Data.SqlTypes there?
Robin
<la*****@yahoo.comwrote in message
news:11*********************@e3g2000cwe.googlegrou ps.com...
Robin,
I'm using .Net 2.0 with SQL Server 2005.
RobinS wrote:
>Which version of the .Net framework are you running? I took your code and
copied it and pasted it into a new class in VS2005, and it worked fine.
I'm
using .Net 2.0.
Also, what version of SQLServer are you using?
Robin
<la*****@yahoo.comwrote in message
news:11**********************@f16g2000cwb.googleg roups.com...
The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add one to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
Yes, the file is there - System.Data.dll 2.0.50727.42 9/23/2005 6:28AM
I am using VS2005
And I can see System.Data.Sqltypes beneath System.Data in the Object
Browser!
RobinS wrote:
Weird. This is my System.Data dll location and file name. Do you have the
same thing? I think System.Data.SqlTypes is included in the System.Data.dll.
Mine is dated 9/23/2005 7:28 AM.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Syst em.Data.dll
Also, I assume you're using VS2005? yes?
If you bring up the Object Browser in VS2005 and look under System.Data, do
you see System.Data.SqlTypes there?
Robin
<la*****@yahoo.comwrote in message
news:11*********************@e3g2000cwe.googlegrou ps.com...
Robin,
I'm using .Net 2.0 with SQL Server 2005.
RobinS wrote:
Which version of the .Net framework are you running? I took your code and
copied it and pasted it into a new class in VS2005, and it worked fine.
I'm
using .Net 2.0.
Also, what version of SQLServer are you using?
Robin
<la*****@yahoo.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add one to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
Yes, the file is there - System.Data.dll 2.0.50727.42 9/23/2005 6:28AM
I am using VS2005
And I can see System.Data.Sqltypes beneath System.Data in the Object
Browser!
RobinS wrote:
Weird. This is my System.Data dll location and file name. Do you have the
same thing? I think System.Data.SqlTypes is included in the System.Data.dll.
Mine is dated 9/23/2005 7:28 AM.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Syst em.Data.dll
Also, I assume you're using VS2005? yes?
If you bring up the Object Browser in VS2005 and look under System.Data, do
you see System.Data.SqlTypes there?
Robin
<la*****@yahoo.comwrote in message
news:11*********************@e3g2000cwe.googlegrou ps.com...
Robin,
I'm using .Net 2.0 with SQL Server 2005.
RobinS wrote:
Which version of the .Net framework are you running? I took your code and
copied it and pasted it into a new class in VS2005, and it worked fine.
I'm
using .Net 2.0.
Also, what version of SQLServer are you using?
Robin
<la*****@yahoo.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add one to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
Does the error happen at runtime, or when you Build?
What does your connection string look like?
Robin
<la*****@yahoo.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...
Yes, the file is there - System.Data.dll 2.0.50727.42 9/23/2005 6:28AM
I am using VS2005
And I can see System.Data.Sqltypes beneath System.Data in the Object
Browser!
RobinS wrote:
>Weird. This is my System.Data dll location and file name. Do you have the
same thing? I think System.Data.SqlTypes is included in the
System.Data.dll.
Mine is dated 9/23/2005 7:28 AM.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Sys tem.Data.dll
Also, I assume you're using VS2005? yes?
If you bring up the Object Browser in VS2005 and look under System.Data,
do
you see System.Data.SqlTypes there?
Robin
<la*****@yahoo.comwrote in message
news:11*********************@e3g2000cwe.googlegro ups.com...
Robin,
I'm using .Net 2.0 with SQL Server 2005.
RobinS wrote:
Which version of the .Net framework are you running? I took your code
and
copied it and pasted it into a new class in VS2005, and it worked
fine.
I'm
using .Net 2.0.
Also, what version of SQLServer are you using?
Robin
<la*****@yahoo.comwrote in message
news:11**********************@f16g2000cwb.googleg roups.com...
The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add one
to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
I got an e-mail from "larclap". He talked to MSFT;
his project file was corrupted. I presume that
fixed the problem.
Robin S.
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:oK******************************@comcast.com. ..
Does the error happen at runtime, or when you Build?
What does your connection string look like?
Robin
<la*****@yahoo.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...
>Yes, the file is there - System.Data.dll 2.0.50727.42 9/23/2005 6:28AM
I am using VS2005
And I can see System.Data.Sqltypes beneath System.Data in the Object
Browser!
RobinS wrote:
>>Weird. This is my System.Data dll location and file name. Do you have
the
same thing? I think System.Data.SqlTypes is included in the
System.Data.dll.
Mine is dated 9/23/2005 7:28 AM.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Sy stem.Data.dll
Also, I assume you're using VS2005? yes?
If you bring up the Object Browser in VS2005 and look under System.Data,
do
you see System.Data.SqlTypes there?
Robin
<la*****@yahoo.comwrote in message
news:11*********************@e3g2000cwe.googlegr oups.com...
Robin,
I'm using .Net 2.0 with SQL Server 2005.
RobinS wrote:
Which version of the .Net framework are you running? I took your code
and
copied it and pasted it into a new class in VS2005, and it worked
fine.
I'm
using .Net 2.0.
Also, what version of SQLServer are you using?
Robin
<la*****@yahoo.comwrote in message
news:11**********************@f16g2000cwb.google groups.com...
The following code snippet has reference errors:
Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient
Public Class DataSourceDB
Private _Descr, _CsvFileName, _XSLTransform As SqlString
Private _dsID, _errorCode As SqlInt32
Private _mainConnection As SqlConnection
Private _rowsAffected As Int32
Public Sub New()
_mainConnection = New SqlConnection
_mainConnection.ConnectionString = cnString
End Sub
The first error says:
Namespace or type specified in the Imports 'System.Data.SqlTypes'
doesn't contain any public member or cannot be found. Make sure the
namespace or the type is defined and contains at least one public
member. Make sure the imported element name doesn't use any
aliases.
However, when I try to add a reference to the project,
System.Data.Sqltypes is not a choice in the .NET tab.
The datatype SqlConnection has the following error:
Reference required to assembly 'System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'
containing the base class 'System.ComponentModel.Component'. Add
one to
your project.
But there already is a reference to System in the project!
What am I missing here?
TIA, Lars
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: peter |
last post by:
Hello all,
Recently I've started to refactor my code ...(I'm using python 2.3.4)
I tried to add extra functionality to old functions non-intrusively.
When I used a construct, which involves...
|
by: David |
last post by:
Hi,
I want to work with Access 2002.
I will need to be able to distribute my application to users that may
still have access 2000 on their computers. I know access 2002 has a
function that...
|
by: Ishbel Kargar |
last post by:
I've bought a new laptop (running Windows XP home edition) to replace my old
one (running Windows 98). I don't have cable connection between the two
computers, so I've transferred most of the...
|
by: Dan Smith |
last post by:
When I try to create a new C# Web Reference in Visual Studio 2003, I get an
error message "The proxy settings on this computer are not configured
correctly for web discovery. ..." This web...
|
by: BBFrost |
last post by:
We just recently moved one of our major c# apps from VS Net 2002 to VS Net
2003. At first things were looking ok, now problems are starting to
appear.
So far ...
(1) ...
|
by: Dales |
last post by:
I have a custom control that builds what we refer to as "Formlets"
around some content in a page. These are basically content "wrapper"
sections that are tables that have a colored header and...
|
by: __PPS__ |
last post by:
Hello, I'm a university student and I'm preparing for my final today.
I'm reading course notes, I found completely strange piece of code. It
makes me laugh, I think the teacher needs to prepare...
|
by: raylopez99 |
last post by:
I'm having problems compiling complex reference declarations in
MSVC++.NET 2002 IDE.
Here is an example:
// --Foo.h--
#include "Bar.h"
class Bar; //forward decl. to a class Bar in...
|
by: rustyc |
last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-)
As I said over there:
... for a little side project at home, I'm writing a ham radio web site in...
|
by: Simon |
last post by:
I have problem with namespaces. I have a program that consumes the web
service and has for instance names space nsProgram. In this program I have
defined several classes that I use for storing and...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
