convert ค่า mysqldatareader to dictionary ?????????? ช่วยด้วยครับ

 string data = "";
            mysql sql = new mysql(); // class mysql 

            string table = "sale";
            string where = "sale_status = 'Active'";
            MySqlDataReader dr = sql.selectwhere(table, where);

            data = "<table class='table table-striped table-bordered table-hover' id='table_sale_manager'>";
            data += "<thead><tr><th>ชื่อ - นามสกุล</th><th>เพศ</th><th>เบอร์โทรศัพท์มือถือ</th><th>E-mail</th></tr></thead><tbody>";
            while (dr.Read()) <------------- error
            {
                data += "<tr>";
                data += "<td>" + dr["sale_manager_name"].ToString() + " " + dr["sale_manager_lastname"].ToString() + "</td>";
                data += "<td>" + dr["sale_manager_sex"].ToString() + "</td>";
                data += "<td>" + dr["sale_manager_mobile"].ToString() + "</td>";
                data += "<td>" + dr["sale_manager_email"].ToString() + "</td>";
                data += "</tr>";
            }

            data += "</tbody></table>";


            return data;

public MySqlDataReader selectwhere(string table, string where)
        {
            string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["mitsu"].ToString();
            MySqlConnection connection = new MySqlConnection(connectionstring);
            connection.Open();
            string cmdText = "SELECT * FROM " + table + " WHERE " + where;
            MySqlCommand cmd = new MySqlCommand(cmdText, connection);
            MySqlDataReader dr = cmd.ExecuteReader();
            int num = dr.Cast<object>().Count();
            dr.Dispose();
            setrow(num);
            dr = cmd.ExecuteReader();
            connection.Close();
            return dr;

        }