SqlCommand Record Count

Question

---

SqlCommand Command = this.CreateCommand(String.Format("SELECT {0} FROM {1} WITH (NOLOCK) ORDER BY ID", String.Join(",", this.m_Campaign.Fields.ToArray()), _Tablename));

---

How can I go about getting the record count of this query? I need to know how many records it's retrieving.