how to get the multiple rows from db using c#

Question

hiii..

       i want to get multiple rows from database...

         SqlCommand cmd = new SqlCommand("SELECT * FROM dateshort WHERE from_date BETWEEN '" + from + "' AND '" + to + "' ", mycon);

         using this query  i want to fetch the in between dates ...

but i don't konw how to implement in c#...