How to connect SQL database with C#

Question

0.00/5 (No votes)

See more:

How to connect SQL Database with C#

according to How to connect SQL Database to your C# program, beginner's tutorial[^]

there is 2 ways to connect to database :

1 is windows authentication
2 is database authentication

if i use database authentication :

should connectionString be like this ?

using(SqlConnection conn = new SqlConnection()) 
{
    conn.ConnectionString = "Server=[server_name];Database=[database_name]; password = = [password_name];user = [user_name];
    // using the code here...
}

What I have tried:

this is just a question about the syntax of the connectionstring. i would like to know if my syntax for the connectionstring is correct if i use database authentication.

Posted 30-Aug-17 23:32pm

forte74

Updated 31-Aug-17 21:04pm

Add a Solution

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)

OriginalGriff · Answer 1 · 2017-08-31T00:00:00

Solution 1

It's not far off - though the password field appears to have too many "=" characetrs.
Here's one of mine:
This is the local access, with intgrated security.

Connection=Data Source=GRIFF-DESKTOP\SQLEXPRESS;Initial Catalog=DatabaseName;Integrated Security=True

And the remote access to the same database used SQL authantication

Connection=Data Source=GRIFF-DESKTOP\SQLEXPRESS;Initial Catalog=DatabaseName;User id=SQLUserName;Password=SQLUserPassword

But don't hard code them like that - always use a configuration file of some form to store them, so they can be changed if the server changes (or when you move to production).

Posted 31-Aug-17 0:00am

OriginalGriff

Comments

forte74 31-Aug-17 6:41am

i have read that C# does not have header files. so how do you import other files to program.cs or into main ?

OriginalGriff 31-Aug-17 7:05am

Sorry?
You're going to have to ask that again - we only get exactly what you type to work with, and you are missing out a lot of context we don't have access to.

Foothill 1-Sep-17 11:48am

With C#, application settings (you will find them in your project's properties) are saved to a file in your User\AppData\Local folder which is loaded when you run your program. Also, you could store your user name, password, or connection string there. You could also just save them to a text file in the same directory of the executable and load it with the System.IO.StreamReader class.

Thomas Nielsen - getCore · Answer 2 · 2017-08-31T21:04:00

Solution 2

Thatone isn't too difficult, have a look at this site for some of your alternatives, the first one should serve you fine,

SQL Server Native Client 11.0 OLE DB Provider Connection Strings - ConnectionStrings.com[^]

Posted 31-Aug-17 21:04pm

Thomas Nielsen - getCore