Connection string

Question

1.00/5 (2 votes)

See more:

SQL-Server-2005

Hi all

I can't able to connect to my sql2005 database, please any provide me a link or code how to connect

Thanks in adavance

Asgar

Posted 5-Dec-10 20:40pm

asgar ali

Updated 6-Dec-10 1:55am

v3

Add a Solution

Comments

thatraja 6-Dec-10 2:52am

Always make your question clear. Your Tag says "SQL2005" but you mentioned "my sql" in your question. Here after take some more time & complete your question. Happy coding.

Toli Cuturicu 6-Dec-10 3:26am

Here "my" is the pronoun, meaning that the sql database is "his" own.

Manfred Rudolf Bihy 6-Dec-10 3:28am

@thatraja: May be you should take some time read OP'S question. He wants to connect to his sql database. He wrote "my sql database" and not "MySQL".

Manfred Rudolf Bihy 6-Dec-10 3:29am

@Toli: Looks like somebody else noticed too :)

2 solutions

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)

Toniyo Jackson · Accepted Answer · 2010-12-05T20:46:00

Solution 1

Add this in web.config file,

<add name="sqlConn" connectionString="server='servername';Initial Catalog='dbname';user id='userid';password='password';Connection Timeout=0;"/>

Then in code use the below code,

public SqlConnection sqlCon;

sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings("sqlConn").ConnectionString);

Posted 5-Dec-10 20:46pm

Toniyo Jackson

Updated 5-Dec-10 20:47pm

v3

Comments

Toli Cuturicu 6-Dec-10 3:27am

Have anyone told you anything about this being a web project?

asgar ali 6-Dec-10 6:13am

thank u very much

Toniyo Jackson 6-Dec-10 6:15am

If its working fine vote it.

gokul7914 · Accepted Answer · 2010-12-05T21:24:00

In the .aspx file:
Include the system files as:

using System.data.sqlclient;

Sqlconnection con = new sqlconnection(ConfigurationManager.appsettings["ConnectionString"].ToSrting());

In the webconfig file:

XML

<appSettings>
    <add key="ConnectionString" value="Data Source=SMAAPC0104\SQLEXPRESS;Initial Catalog=Demo;Integrated Security=True"/>

  </appSettings>
    <connectionStrings>
    <add name="ImageLoader" connectionString="Data Source=SMAAPC0104\SQLEXPRESS;Initial Cataolg=Demo"/>
    </connectionStrings>

Try it out.

Cheers
Gokul.N