Using SQL server in C#

[dhawal]

hi,
I am new to .net and SQL stuff. I was reading tutorials on google and got the syntax for establishing an SQL connection but could understand it. So if someone could explain in a better way?

SqlConnection myConnection = new SqlConnection("user id=username;" +
"password=password;server=serverurl;" +
"Trusted_Connection=yes;" +
"database=databse; " +
"connection timeout=30");


i wanted to ask what should come in place of server url?
and also, what should be written in place of databse??
My database is named - "StuData" and is stored in path C:\myDataSrc.
I am using SQL server 2008.

[sandeeptheviper]

hi
okk let me try

here SqlConnection is a class and myConnection is its object.

user id = it is used to specify the server login account

password=it is used to specify the login password for the server login account

server = it is the name of your server

database=it is the name of the database that you are working on

connection timeout = is the time in seconds to wait while a connection to the data source is attempted.

for example in sql server 2005 if my server name is sqlserver098 and database name is HR and user id =sam and password is 1234
then i will write the following query

SqlConnection connection=new SqlConnection();
and now gonna use the ConnectionString property of SqlConnection class
connection.ConnectionString="Data Source=sqlserver098;Initial Catalog=HR; User ID=sa;password=1234"


hope this helps