Talk:DataReader

Sample code suggestion

I suggest the following example (please note the additional using for mycommand and avoiding string concatenation):

void DataTest()
{
  using (SqlConnection conn1 = new SqlConnection(...))
  {
    conn1.Open();

    using (SqlCommand mycommand = new SqlCommand("Select * From someTable", conn1))
    using (SqlDataReader myreader = mycommand.ExecuteReader())
    {
      if(myreader == null)
      {
        return;
      }

      while(myreader.Read())
      {
        Console.WriteLine(string.Format("{0}:{1}", myreader.GetValue(0), myreader.GetTypeName(0));
      }
    }
  }
}

What do other's think? --Blue4k (talk) 17:49, 23 December 2010 (UTC)

I like it! Much clearer! Wikipedia:Be bold 5.10.169.18 (talk) 14:36, 6 February 2013 (UTC)