Mega Code Archive

 

Categories / C# / ADO Database

 

Create Connection

using System; using System.Data; using System.Data.Common; class MainClass {     public static void Main(string[] args) {         DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient");         using (IDbConnection con = factory.CreateConnection()) {             con.ConnectionString = @"Data Source = .\sqlexpress;Database = Northwind; Integrated Security=SSPI";             using (IDbCommand com = con.CreateCommand()) {                 com.CommandType = CommandType.StoredProcedure;                 com.CommandText = "Ten Most Expensive Products";                 con.Open();                 using (IDataReader reader = com.ExecuteReader()) {                     Console.WriteLine(Environment.NewLine);                     Console.WriteLine("Price of the Ten Most Expensive Products.");                     while (reader.Read()) {                         Console.WriteLine("  {0} = {1}", reader["TenMostExpensiveProducts"], reader["UnitPrice"]);                     }                 }             }         }     } }