Web config

[JJ297]

Could someone tell me how to reference my datasource from web config in my code behind page. I have this displayed now which is giving out too much info:

Dim conn As New Data.SqlClient.SqlConnection("Data Source=seb2a54;Initial Catalog=SpdtLibrary;User ID=Training;Password=people")

 

[ca8msm]

ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[JJ297]

Thanks for this but I'm a newbie and don't know what I should put in place of

Dim conn As New Data.SqlClient.SqlConnection("Data Source=seb2a54;Initial Catalog=SpdtLibrary;User ID=Training;Password=people")

Should I put...

Dim conn As New Data.SQLClient.SqlConnection = ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString

 

[ca8msm]

Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString)

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[JJ297]

I tried that now I'm getting and error:

NullReferenceExpection was unhandled by user code

object reference nto set to an instance of an object.

Use the "new" keyword to create an object instance.

Any ideas?

 

[adamroof]

if you place at the beginning of your codebehind, you can consume the variable within each of your routines.
This is an example, the RunThis() is not complete, nor best practice.

regarding your error, i bolded the line as it "should" be

Public Class yourclass_cb
    Inherits System.Web.UI.Page

    Dim conString As String = ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString

    Sub Page_Load()
        If Not Page.IsPostBack Then
             RunThis()
        End If
    End Sub

    Sub RunThis()
        [b]Dim myConnection As New SqlConnection(conString)[/b]
        Dim myCommand As New SqlCommand("sp_MyStoredProc", myConnection)
        myCommand.CommandType = CommandType.StoredProcedure       
        Dim da As New SqlDataAdapter(myCommand)
        Dim ds As New DataSet()
        da.Fill(ds)
        myConnection.Close()
    End Sub

 

[JJ297]

Thanks I got it working!