如何创建 executeReader 类

先生，

我有一个用于执行非查询的连接类

public class Connection
{
    SqlConnection conn;
    SqlCommand cmd;
    public void connclose()
    {
        conn.Close();
    }
    public Connection()
    {
       conn = new SqlConnection(@"server=ADMIN-PC;database=sample;Integrated security=true");
       cmd = null;
    }
    public void nonquery(SqlCommand cmd)
    {
        conn.Open();
        cmd.Connection = conn;
        cmd.ExecuteNonQuery();
        conn.Close();
    }

以同样的方式，我还必须创建一个执行阅读器类。我应该为此申请哪些更改

我也有课

public void insert(string sid, string cid, string state)
    {
        SqlCommand cmd = new SqlCommand("InsertState");
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@StateId", SqlDbType.VarChar).Value = sid;
        cmd.Parameters.Add("@CountryId", SqlDbType.VarChar).Value = cid;
        cmd.Parameters.Add("@State", SqlDbType.VarChar).Value = state;
        conn.nonquery(cmd);
    }

public SqlDataReader ReadMe(SqlCommand cmd)
    {
        conn.Open();
        cmd.Connection = conn;
        SqlDataReader reader =  cmd.ExecuteReader();
        return reader;
    }

   SqlCommand cmd = new SqlCommand("reading");
   cmd.CommandType = CommandType.StoredProcedure;
   using(SqlDataReader ourreader = conn.ReadMe(cmd))
        {
         while (ourreader.Read())
               {
               //some code
               }
        }
   conn.Close();