ConnectionString property has not been initialized. [Answered] RSS

• • Reply
  coollibran

  Member

  4 Points

  131 Posts

  ConnectionString property has not been initialized.

  Jul 16, 2014 02:16 AM|coollibran|LINK

  This is my webconfig file

  <?xml version="1.0"?>

  <configuration>

  
  <connectionStrings>
  <add
  name="TBNETConnectionString"
  connectionString="Data Source=localhost\SQLEXPRESS;Initial
  Catalog=NET;Persist Security Info=True;User
  ID=sa;Password=sa"
  providerName="System.Data.SqlClient"
  />
  </connectionStrings>
  
  <system.web>
  <compilation debug="true" targetFramework="4.0" />
  
  
  </system.web>
  </configuration>

  This is my default.aspx.cs file

  using System;
  using System.Collections.Generic;
  using System.Configuration;
  using System.Linq;
  using System.Web;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  using System.Web.UI.WebControls.WebParts;
  using System.Web.UI.HtmlControls;
  using System.Data;
  using System.Data.SqlClient;

  
  public partial class _Default : System.Web.UI.Page
  {
  protected void Page_Load(object sender, EventArgs e)
  {
  if (Request.QueryString["SearchString"] != null)
  {
  DisplaySearchResults(Request.QueryString["SearchString"]);
  }
  }

  public void DisplaySearchResults(string strSearch)
  {
  SqlCommand cmd = new SqlCommand("SearchByString", new SqlConnection(ConfigurationManager.AppSettings["NETConnectionstring"]));
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.Parameters.AddWithValue("@SearchString", strSearch);
  cmd.Connection.Open();
  Repeater1.DataSource = cmd.ExecuteReader();
  Repeater1.DataBind();
  cmd.Connection.Close();
  cmd.Connection.Dispose();
  }

  
  protected void Button1_Click(object sender, EventArgs e)
  {
  if (TextBox1.Text == "" | TextBox1.Text == null)
  {
  lblStatus.Text = "Please enter valid search criteria";
  }
  else
  {
  DisplaySearchResults(TextBox1.Text);
  lblStatus.Text = "";
  TextBox1.Text = "Request Submitted...";
  }

  
  }
  }

  gives InvalidOperationException was unhandled by user code

  ConnectionString property has not been initialized.

  What is the error and how to solve it??

  connectionstringpropertyinvalidoperationexception

• • Reply
  Mikesdotnett...

  All-Star

  194851 Points

  28099 Posts

  Moderator

  Re: ConnectionString property has not been initialized.

  Jul 16, 2014 02:21 AM|Mikesdotnetting|LINK

  Your connection string is in the ConnectionStrings section, not AppSettings, and it is called "TBNETConnectionString", not "NETConnectionstring"

  SqlCommand cmd = new SqlCommand("SearchByString", new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETConnectionstring"].ConnectionString));

  
  
  

  connectionstringpropertyinvalidoperationexception

  ASP.NET Tutorials | Learn Entity Framework Core | Learn Razor Pages | Learn Dapper
• • Reply
  coollibran

  Member

  4 Points

  131 Posts

  Re: ConnectionString property has not been initialized.

  Jul 16, 2014 06:25 AM|coollibran|LINK

  I made changes which rectified the earlier problem.

  Now it is giving the error ArguementException was unhandled by user code:

  Keyword not supported Initial catalog

  What is the possible cause of error??

  connectionstringpropertyinvalidoperationexception ArguementException

• • Reply
  Mikesdotnett...

  All-Star

  194851 Points

  28099 Posts

  Moderator

  Re: ConnectionString property has not been initialized.

  Jul 16, 2014 07:29 AM|Mikesdotnetting|LINK

  Try this:

  <add name="TBNETConnectionString" connectionString="Server=localhost\SQLEXPRESS;Database=NET;Persist Security Info=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient"/>

  connectionstringpropertyinvalidoperationexception ArguementException

  ASP.NET Tutorials | Learn Entity Framework Core | Learn Razor Pages | Learn Dapper
• • Reply
  coollibran

  Member

  4 Points

  131 Posts

  Re: ConnectionString property has not been initialized.

  Jul 16, 2014 07:43 AM|coollibran|LINK

  problem solved..

  thanks a lot

  connectionstringpropertyinvalidoperationexception ArguementException