Using Statement am Beispiel eines DataReaders

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

// Apfel Tools
// www.citrusnet.ch/blog


string connString = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;";
using (SqlConnection conn = new SqlConnection(connString))
  {
   SqlCommand cmd = conn.CreateCommand();
   cmd.CommandText = "SELECT CustomerId, CompanyName FROM Customers";
   conn.Open();
   using (SqlDataReader dr = cmd.ExecuteReader())
    {
     while (dr.Read())
      Console.WriteLine("{0}\t{1}", dr.GetString(0), dr.GetString(1)); 
    }
  }