reading a web.config connection string from asp.net code RSS

• • Reply
  

  jpuga

  Member

  69 Points

  103 Posts

  reading a web.config connection string from asp.net code

  May 09, 2012 02:57 PM|LINK

  Hi All

  my web.config connection string is:

  connectionString="Data Source=server\instance;Initial Catalog=Databasename.mdf;User ID=User;Password=password"

  but I have been using on my asp.net code the following format to create  manually a connection string by code

  Dim con As SqlConnection
              Dim cmd As SqlCommand
              con = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dayabasename.mdf;Integrated Security=True;User Instance=True")
              con.Open()
              cmd = New SqlCommand("dbo.AddPMUpdate", con)
              cmd.CommandType = CommandType.StoredProcedure
              cmd.Parameters.AddWithValue("@Title", TBTitle.Text)
              cmd.Parameters.AddWithValue("@Description", TBDescription.Text)
              cmd.ExecuteNonQuery()
              con.Close()
              GridView1.DataBind()
              TBTitle.Text = ""
              TBDescription.Text = ""
          Catch ex As Exception
              LBMessage.Text = ex.Message

  now my application has been published, and I got and erroe in each page that I created a manual connection string by code

  I would appreciate if you show me how to read the connection string from my web.config to my code.

  Thanks in advance, your help will be appreciated....!!!!
  
  

   

• • Reply
  

  HeartattacK

  All-Star

  55262 Points

  5917 Posts

  Moderator

  MVP

  Re: reading a web.config connection string from asp.net code

  May 09, 2012 03:04 PM|LINK

  Reference System.Configuration and then you can access it by:

  ConfigurationManager.ConnectionStrings["connectionStringName"].ConnectionString
  

  "If I can see further than anyone else, it is only because I am standing on the shoulders of giants."

  ---

  blog: www.heartysoft.com
  twitter: @ashic
  • Marked as answer by HeartattacK on May 09, 2012 03:44 PM
• • Reply
  

  jpuga

  Member

  69 Points

  103 Posts

  Re: reading a web.config connection string from asp.net code

  May 09, 2012 03:18 PM|LINK

  I tried with this format

  String Con = ConfigurationManager.ConnectionStrings["Conectionstring"].ConnectionStrings

  but I got and error
  string is a class type and cannot be used as an expression

  what do you think??

• • Reply
  

  HeartattacK

  All-Star

  55262 Points

  5917 Posts

  Moderator

  MVP

  Re: reading a web.config connection string from asp.net code

  May 09, 2012 03:20 PM|LINK

  Ahh...you're on VB.NET:

  ConfigurationManager.ConnectionStrings("Conectionstring").ConnectionString

  "If I can see further than anyone else, it is only because I am standing on the shoulders of giants."

  ---

  blog: www.heartysoft.com
  twitter: @ashic
  • Marked as answer by jpuga on May 09, 2012 03:42 PM
• • Reply
  

  jpuga

  Member

  69 Points

  103 Posts

  Re: reading a web.config connection string from asp.net code

  May 09, 2012 03:44 PM|LINK

  Thanks a lot now works......