SqlConnection in Ado.Net

hello friends !! Today I am just going to explain about SqlConnection in a ado.net which is as given below :

SqlConnection !!

Sqlconnection: 

• Sqlconnection is an object used to make connection with database.
• We make instance of sqlconnection which is take connection string as argument and pass the value to the constructor statement.

There are two type of connection we make which is as given below :

1. Open();
2. Close();

Open();: The Open(); method we used for open the database connection.
Close();The Close(); method we used for Close the database connection.

Syntax:

SqlConnection con = new SqlConnection ("data source=.; initial catalog=project2; integrated security=true");

Note:

data source=.;  (this tell your server name)
.  (Dot means your current server name)

Initial catalog =project2;   (tell your database name)
(Project2 is a database name)

Integrates security=true (it tell you that you are login in the sql server with window authentication)

Note: if you login with Sql server authentication then you have to give here id and password instead of integrated security =true as given below:
User Id=sandeep;
Password=soni;

The output screen will you see as given below:

I hope this post will help you..

Still, If you've query regarding to this article then please post your comment .your post will be appropriate .

Posted in: Ado.Net