Wrox Home  
Search P2P Archive for: Go

  Return to Index  

ado_dotnet thread: Help!!!


Message #1 by "Tony Arslan" <tarslan@n...> on Wed, 20 Mar 2002 17:57:16 -0600
Hello All,
I have VS Enterprise Architect. The IntelliSense functionality of it does
nor work. For Example:

Dim myConnection As SQLConnection
Dim myCommand As SQLCommand
Dim myReader  As SQLDataReader
Dim SQL       As String
Dim ConnStr   As String

SQL = "SELECT * FROM Table1"
ConnStr = "server=.......blah...blah"

myConnection = New SQLConnection(ConnStr)
myConnection.Open()

When I type "myConnection" then press "." key I don't get the list available
to me (which includes Open() method)

Can Someone please help me.... I tried every thing...
Nothing worked.
Thanks in advance,
Please send your reply directly to me at tarslan@n... if you can

Tony


Message #2 by David.Martret@q... on Thu, 21 Mar 2002 11:11:15 +1100
Tony,

You have to include the namespace(s) at the top of each code behind page
(before all other statements)

e.g.:

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Web.UI.WebControls

This will give you the functionality you require.

Regards,
David

(P.S. this took me quite a while to discover also ... as you need to add
the reference to the project and add this statement to the page)



                                                                                                                   
                    "Tony Arslan"                                                                                  
                    <tarslan@n...        To:     "ADO.NET" <ado_dotnet@p...>                               
                    eft.com>             cc:                                                                       
                                         Subject:     [ado_dotnet] Help!!!                                         
                    21/03/02                                                                                       
                    10:57                                                                                          
                    Please                                                                                         
                    respond to                                                                                     
                    "ADO.NET"                                                                                      
                                                                                                                   
                                                                                                                   



Hello All,
I have VS Enterprise Architect. The IntelliSense functionality of it does
nor work. For Example:

Dim myConnection As SQLConnection
Dim myCommand As SQLCommand
Dim myReader  As SQLDataReader
Dim SQL       As String
Dim ConnStr   As String

SQL = "SELECT * FROM Table1"
ConnStr = "server=.......blah...blah"

myConnection = New SQLConnection(ConnStr)
myConnection.Open()

When I type "myConnection" then press "." key I don't get the list
available
to me (which includes Open() method)

Can Someone please help me.... I tried every thing...
Nothing worked.
Thanks in advance,
Please send your reply directly to me at tarslan@n... if you can

Tony







Message #3 by "Ludington, Kruse" <kruse.ludington@c...> on Thu, 21 Mar 2002 00:40:40 -0000
Recompile

- Kruse

This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information.
No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately
delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE
GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE
FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are
those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views
of any such entity.
Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not
constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as 
preliminary only and subject to our formal written confirmation.



  Return to Index