Home > DeveloperSection > Blogs > Database Connection

Database Connection


ADO.Net ADO.Net 
Ratings:
0 Comment(s)
 2634  View(s)
Rate this:
ADO.NET is also a part of the .NET Framework. ADO.NET is used to handle data access. With ADO.NET you can work with databases.

ADO.NET is a part of the .NET Framework
ADO.NET consists of a set of classes used to handle data access

Create a Database Connection

SqlConnection con = new SqlConnection(sqlString);

con.Open();

 SqlCommand cmd = new SqlCommand("select id, pass from student", con);SqlDataReader dr = cmd.ExecuteReader();

con.Close();use following namspaceusing System.Data;

 

using System.Data.SqlClient;

string sqlString = "Server=(local); Database=my; User Id=sa; Password=sa";

Don't want to miss updates? Please click the below button!

Follow MindStick