How create connectionstring in web.config file using c#?

Expand Post »

Hai,I am trying to connection using web.confing in connectionstring element
and i have written below code in connectionstring element in

ASP.NET Syntax (Toggle Plain Text)
 
      <connectionStrings>
      <add name="DB1" connectionString="Data Source=DEV5\\SQLEXPRESS;Initial Catalog=icondatabase;Integrated Security=True" />
      </connectionStrings>
  
      <connectionStrings>
      <add name="DB1" connectionString="Data Source=DEV5\\SQLEXPRESS;Initial Catalog=icondatabase;Integrated Security=True" />
      </connectionStrings>

And in the .aspx.cs file (in Load_page)i have written below code

ASP.NET Syntax (Toggle Plain Text)
 
      string connection= ConfigurationManager.ConnectionStrings["DB1"].ToString();
      SqlConnection cn = new SqlConnection("connection");
   
      string connection= ConfigurationManager.ConnectionStrings["DB1"].ToString();
      SqlConnection cn = new SqlConnection("connection");

while i compiled page it give the error:
"
ArgumentExeption was Unhandled by User Code
Format of the initialization string does not conform to specification starting at index 0."

any body plz help me......

Similar Threads

HELP PLEASE: System.Security.SecurityException in ASP.NET
ConnectionString Config in ASP.NET
Web.config, Access Database, Admin Authorisation Problem in ASP.NET
how to Give keywords in web config file ? in ASP.NET
why is this config file wrong in ASP.NET

Pari13

Reputation Points: 9

Solved Threads: 0

Junior Poster in Training