EdwardH
6/12/2007 2:23:00 PM
Manish,
Apologies for bringing this case up again but can I ask how secure this
ConfigurationMethod is as it is not passing a string? Is the web.config
encryption now still necessary?
"EdwardH" wrote:
> Manish,
> Works fine
> Many, many thanks - I have been struggling with this for a few days.
>
> "Manish Bafna" wrote:
>
> > Hi,
> > sorry i posted in hurry.This is a problem with posting in hurry.Actually it
> > will return SqlConnection.You can write something like this:
> > Dim myConnection As New
> > SqlConnection(ConfigurationManager.ConnectionStrings(
> > "NorthwindConn").ConnectionString)
> > 'Place the data in a DataTable
> > Dim myCommand As New SqlCommand(sql, myConnection)
> > Dim myAdapter As New SqlDataAdapter(myCommand)
> > myConnection.Open()
> > Dim dt As New DataTable
> > myAdapter.Fill(dt)
> > --
> > Hope this helps.
> > Thanks and Regards.
> > Manish Bafna.
> > MCP and MCTS.
> >
> >
> >
> > "EdwardH" wrote:
> >
> > > On that line of code I now get
> > > "System.Configuration.ConnectionStringSettingCollection cannot be converted
> > > to a String". I have System.Configuration as a reference and the following
> > > Import statements:
> > > Imports System.Data.SqlClient
> > > Imports System.Web.Security
> > > Imports System.Configuration
> > >
> > > Am I missing something else? Thanks again
> > > "Manish Bafna" wrote:
> > >
> > > > Hi,
> > > > You would be pulling back as string.That is
> > > > string strConn =
> > > > ConfigurationManager.ConnectionStrings["NorthwindConn"].ConnectionString
> > > > --
> > > > Hope this helps.
> > > > Thanks and Regards.
> > > > Manish Bafna.
> > > > MCP and MCTS.
> > > >
> > > >
> > > >
> > > > "EdwardH" wrote:
> > > >
> > > > > Thanks for your ansa.
> > > > > Am I pulling back value from web.config as a string or as a sqlconnection
> > > > > i.e System.Data.SqlClient.sqlConnection?
> > > > >
> > > > > "Manish Bafna" wrote:
> > > > >
> > > > > > Hi,
> > > > > > I think i have gone little off the topic.All you wanted was to retrieve
> > > > > > value of connectionstring in ASP.NET 2.0 way.Suppose you have defined
> > > > > > Connectionstring tag in web.config in following way:
> > > > > > <connectionStrings>
> > > > > > <add name="NorthwindConn"
> > > > > > connectionString="Server='local'; database='NORTHWIND';
> > > > > > Trusted_Connection=False; uid=sa;pwd=*****"
> > > > > > providerName="System.Data.SqlClient" />
> > > > > > </connectionStrings>
> > > > > >
> > > > > > What you must take care that tag <ConnectionStrings> is not included
> > > > > > inside <appSettings>
> > > > > > Include it after <configuration>Also, don't include it inside <system.web>
> > > > > > Then below code retrieves it:
> > > > > > ConfigurationManager.ConnectionStrings["NorthwindConn"].ConnectionString
> > > > > >
> > > > > > In .NET 2.0 there is a new configuration class called ConfigurationManager.
> > > > > > It supercedes the ConfigurationSettings class that most .NET developers are
> > > > > > familiar with today
> > > > > > System.Configuration.dll - ensure you add a reference to this assembly. In
> > > > > > .NET 2.0 all configuration functionality is in this separate assembly
> > > > > > now.Once this reference is added, System.Configuration.ConfigurationManager
> > > > > > will once more be available to you.
> > > > > > --
> > > > > > Hope this helps.
> > > > > > Thanks and Regards.
> > > > > > Manish Bafna.
> > > > > > MCP and MCTS.
> > > > > >
> > > > > >
> > > > > >
> > > > > > "EdwardH" wrote:
> > > > > >
> > > > > > > Am upgrading SQL server access app from 2003 to 2005. Old code works but I
> > > > > > > can see safer methods:
> > > > > > > My web.config (ASP.Net 1.1)
> > > > > > > <configuration>
> > > > > > > <appSettings>
> > > > > > > <add key="ConnectString" value="Data Source=Vaio1;Initial Catalog=IMA;User
> > > > > > > ID=sa;Password="/>
> > > > > > > <add key="ImagePath" value="/IMA/Images/"/>
> > > > > > > </appSettings> etc
> > > > > > >
> > > > > > > and vb code to open in page:
> > > > > > > Private ConnectString As String =
> > > > > > > ConfigurationSettings.AppSettings("ConnectString")
> > > > > > > Private invConn As SqlConnection
> > > > > > > Private invCom As SqlCommand
> > > > > > > Private objDR As SqlClient.SqlDataReader
> > > > > > > and in
> > > > > > > invConn = New SqlConnection(ConnectString)
> > > > > > > invConn.Open()
> > > > > > > invCom = New SqlCommand("iUserCheck", invConn)
> > > > > > > invCom.CommandType = CommandType.StoredProcedure
> > > > > > >
> > > > > > > I realise I need to encrypt this but want to upgrade this to ASP.net ver 2.
> > > > > > > Old code works fine but realise it is out of date.
> > > > > > >
> > > > > > >