SqlCommand.ExecuteReader 方法

以下示例创建一个 SqlCommand，然后通过传递两个字符串来执行它，其中一个字符串是 Transact-SQL SELECT 语句，另一个字符串用于连接数据源。CommandBehavior 设置为 CloseConnection。

public void CreateMySqlDataReader(string mySelectQuery,string myConnectionString)
{
   SqlConnection myConnection = new SqlConnection(myConnectionString);
   SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
   myConnection.Open();
   SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
   while(myReader.Read())
   {
      Console.WriteLine(myReader.GetString(0));
   }
   myReader.Close();
   //Implicitly closes the connection because CommandBehavior.CloseConnection was specified.
}

转载于:https://www.cnblogs.com/crane/archive/2006/01/20/320900.html