SQL Server datareader

kscase · January 18th, 2007, 05:10 PM

I am attempting to write the login code for my application. I've been looking at a number of examples. but so far, I've been unsuccessful.

This is the code I have right now:

Code:

Imports System.Data
Imports System.Data.SqlClient
Imports System.Windows.Forms

Public Class APCLogin
    Private APCConnString As String
    Private APC_WirelessConnectionStringIntegrated As String
    '"Data Source=SERVER\APCD1;Initial Catalog=APC_Wireless;Integrated Security=True;User Instance=True"
    Private APC_WirelessConnectionStringSQLsrvr As String
    '"Data Source=SERVER\APCD1;Initial Catalog=APC_Wireless;User ID=?;Password=?"

...

Private Sub APCLogin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim blnSecurityType As Boolean
        'Dim cnStr As String 'connection string

        If blnSecurityType Then
            'integrated security version
            APCConnString = APC_WirelessConnectionStringIntegrated
        Else
            'sql server security version
            APCConnString = APC_WirelessConnectionStringSQLsrvr
        End If
    End Sub

    Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click
        Dim APCReader As New System.Data.SqlClient.SqlDataReader()

I'm getting the following error message, which I don't understand:
'SqlDataReader' is ambiguous in the namespace 'System.Data.SqlClient'

What did I not do in my imports statements?

Thanks,
Karen

dparsons · January 18th, 2007, 05:19 PM

Try this:

Dim APCReader as SqlDataReader

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

kscase · January 19th, 2007, 12:50 PM

Still happening ...

dparsons · January 19th, 2007, 02:07 PM

hmm I can't solve this. Its not that you didn't do something but, it seems, you are somehow referencing 2 classes that both contain a definition for the DataReader. (To be honest I have no idea how you are doing this, did you add a reference the System.Data class to your project twice?)

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

Imar · January 19th, 2007, 02:41 PM

What's even more interesting is that the compiler doesn't give you a warning about newing up a SqlDataReader since it has no public constructors....

Is this all the code? Or is there more that can influence this situation?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

suresh_ala · February 6th, 2007, 06:11 AM

What is the Best approach for Processing Sql commands Asynchrnously?

Call back/ Wait handler /Polling...

under Which casee we have to pick

suresh_ala · February 6th, 2007, 06:18 AM

There is a no public constructor, so you can't create an instance of datareader.