sql connection string in c#

Question

1.00/5 (1 vote)

See more:

i want to connect to a db in c# but have an error in conection string how can i set it??
here is my code:

C#

string str = "Data Source=ADMIN-B19C3BADF;Initial Catalog=bazarkhodro;Integrated Security=True";
           Qconnection.ConnectionString = str;

Posted 5-Dec-12 22:14pm

f.sarikhani

Add a Solution

Comments

bbirajdar 6-Dec-12 4:17am

username ? password?

ho.kurd 27-Aug-13 18:58pm

So What About MDF ?

f.sarikhani 6-Dec-12 4:19am

i connect a gridview to db and copy its connection string and i dont have user name and pass in my db

Patel Shailendra 6-Dec-12 4:24am

can you post here whats error you get.

f.sarikhani 9-Dec-12 0:17am

Unknown connection option in connection string: initial catalog.

4 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)

Vishal.Shimpi144 · Answer 1 · 2012-12-05T22:50:00

you can get connection string in following way also...
1. create test.udl file on ur desktop.
2. open that file
3. select ur sever name
4. select ur database
5. click on test connection (if its succeded)
6. click on finish.
7. open same file with wordpad/ notepad
8. add username and password(if you are using server authontication)
copy the connection string and pest it your config file
like

XML

<connectionStrings>
   <add name="ApplicationServices" connectionString="copy connection string here" 
    />
 </connectionStrings>

bbirajdar · Answer 2 · 2012-12-05T22:18:00

Solution 1

I dont see the user name password in the connection string. Refer this website
http://www.connectionstrings.com/sql-server-2008[^]

Posted 5-Dec-12 22:18pm

bbirajdar

Krunal Rohit · Answer 3 · 2012-12-05T22:18:00

Solution 2

C#

static string ConStr = "Data Source=ADMIN-B19C3BADF;Initial Catalog=bazarkhodro;Integrated Security=True";
SqlConnection con = new SqlConnection(ConStr);

Posted 5-Dec-12 22:18pm

Krunal Rohit

Devang Vaja · Answer 4 · 2012-12-05T22:30:00

First of all connect to database from server exploroer
then right click on database>properties in that You will find the exatct connection string copy and paste it in web config <connectionstring><add name="cn" connectionstring="Paste here">
and then
in common class in constructor method call the
cn=new SqlConnection(configurationManager.Connectionstrings("cn").connectionstring);
cn.open();

may be this will Help You..
hApPy cOdInG:)

sql connection string in c#

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0