how to specify connection string in app.config file

Question

0.00/5 (No votes)

See more:

C#

private void button1_Click(object sender, EventArgs e)
        {
            string str = ConfigurationSettings.AppSettings["ConnectionString"];


            using (SqlConnection connection = new SqlConnection(str))
            {     try 
            {

                connection.Open();   ---throwing error here saying instance failure
            }   
            catch (System.Data.SqlClient.SqlException ex)
            {   
                  
                return;
            } 
                string selectCommandText = "SELECT * FROM tmptblUserProfile";   
                using (SqlDataAdapter adapter = new SqlDataAdapter(selectCommandText, connection))
                {
                    using (DataTable table = new DataTable("tmptblUserProfile")) 
                {             adapter.Fill(table);           
                    
                    StringBuilder commaDelimitedText = new StringBuilder();
                    commaDelimitedText.AppendLine("col1|col2|col3|col4|col5|col6col7|col8|col9|col10|col11|col12|col13|col14|col15");         
                    foreach (DataRow row in table.Rows) {
                        string value = string.Format("{0}|{1}|{2}|{3}|{4}|{5}{6}|{7}|{8}{9}|{10}|{11}{12}|{13}|{14}", row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12], row[13], row[14]);                 
                        commaDelimitedText.AppendLine(value);         
                    }        
                    File.WriteAllText(@"C:\Documents and Settings\aj99823\Desktop\amal101.txt", commaDelimitedText.ToString());    
                }  
            }

            } 
        }

in the app.config i specified as

HTML

<configuration>
  <appsettings>
 <add key="ConnectionString">
 value="Data Source=CSZ-PCS43132\\SQLEXPRESS;Initial Catalog=test;Integrated Security=True"
 />
 </add></appsettings>
  </configuration>

it is throwing one error saying instance failure while executing this statement.can anyone plss help me.............

Posted 26-Feb-12 22:49pm

amaljosep

Updated 27-Feb-12 0:45am

uspatel

v2

Add a Solution

3 solutions

Solution 1

The problem is not with your config file, the problem is with your SQL Server instance name. Check if CSZ-PCS43132\\SQLEXPRESS is a valid SQL Server instance. (Here CSZ-PCS43132 is your PC/Server name and SQLEXPRESS is your instance name)

Posted 26-Feb-12 22:57pm

Shameel

Solution 2

connection string is specified just like how you did in appconfig.ex

XML

<connectionStrings>
   <clear />
   <add name="Local" connectionString="Data Source=MyPC;Database=Northwind;user=sa;password=pass;" />
   </connectionStrings>

It seems like your connection string is not correct.You can try to open SSMS using same credential.

Posted 26-Feb-12 23:06pm

Rishikesh_Singh

Comments

amaljosep 27-Feb-12 5:12am

if i give like this in app.config...how should i call it in the button click event?

Rishikesh_Singh 27-Feb-12 6:39am

public static string GetConnectionString(string name)
{
try
{
return ConfigurationManager.ConnectionStrings[name].ConnectionString;
}

catch (ConfigurationException oex)
{
throw oex;
}
catch (Exception oex)
{
throw oex;
}
}

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rishikesh_Singh · Accepted Answer · 2012-02-27T00:43:00

Solution 3

Your problem is because of in "\\" your connection string should be
CSZ-PCS43132\SQLEXPRESS;Initial Catalog=test;Integrated Security=True

Mark it as answered if it helps

Posted 27-Feb-12 0:43am

Rishikesh_Singh

v2

Comments

amaljosep 30-Mar-12 8:19am

thanks a lot for your help.......