Talk:DataReader

	This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing
Low	This article has been rated as Low-importance on the project's importance scale.
	This article is supported by WikiProject Software (assessed as Low-importance).

Microsoft: .NET Low‑importance

	This article is within the scope of WikiProject Microsoft, a collaborative effort to improve the coverage of articles relating to Microsoft on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.MicrosoftWikipedia:WikiProject MicrosoftTemplate:WikiProject MicrosoftMicrosoft
Low	This article has been rated as Low-importance on the project's importance scale.
	This article is supported by WikiProject .NET (assessed as Low-importance).

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)[reply]

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