How to create a connection string in asp net c

Question

I am working on asp net c  project  for connection I used   SqlConnection con   new SqlConnection   Data Source   SQLEXPRESS AttachDbFilename D  19-02 ABCC App Data abcc mdf Integrated Security True User Instance True      but I want to get this connection string to get configure and be like this  so can any one help how to create this kind of connection   SqlConnection con   new SqlConnection ConfigurationManager ConnectionStrings  itmall   ConnectionString

User · Answer

string connectionstring  DataSource severname InitialCatlog databasename Uid   password    SqlConnection con new SqlConnection connectionstring

User · Answer

Add this connection string tag in web config file    lt connectionStrings gt     lt add name  itmall       connectionString  Data Source   SQLEXPRESS AttachDbFilename D  19-02 ABCC App Data abcc mdf Integrated Security True User Instance True   gt   lt  connectionStrings gt    And use it like you mentioned

User · Answer

add this in web config file              lt configuration gt                 lt appSettings gt                    lt add key  ConnectionString  value  Your connection string which contains database id and password   gt               lt  appSettings gt               lt  configuration gt     cs file   public ConnectionObjects                     string connectionstring  ConfigurationManager AppSettings  ConnectionString   ToString         Hope this helps

User · Answer

Demo     lt connectionStrings gt   lt add name  myConnectionString  connectionString  server localhost database myDb uid myUser password myPass     gt   lt  connectionStrings gt    Based on your question    lt connectionStrings gt       lt add name  itmall  connectionString  Data Source   SQLEXPRESS AttachDbFilename D  19-02 ABCC App Data abcc mdf Integrated Security True User Instance True    gt       lt  connectionStrings gt    Refer links   http   www connectionstrings com store-connection-string-in-webconfig   Retrive connection string from web config file   write the below code in your file where you want   string connstring ConfigurationManager ConnectionStrings  itmall   ConnectionString   SqlConnection con   new SqlConnection connstring     or you can go in your way like  SqlConnection con   new SqlConnection ConfigurationManager ConnectionStrings  itmall   ConnectionString     Note   The  name  which you gave in web config file and name which you used in connection string must be same like  itmall  in this solution

User · Answer

It occurs when IIS is not being connected to SQL SERVER  For a solution  see this screenshot

User · Answer

Add this in your web config file   lt connectionStrings gt   lt add name  itmall   connectionString  Data Source   SQLEXPRESS AttachDbFilename D  19- 02 ABCC App Data abcc mdf Integrated Security True User Instance True    gt   lt  connectionStrings gt

[c#] How to create a connection string in asp.net c#

Examples related to c#

Examples related to asp.net

Examples related to sql-server-express