1        public SqlDataReader GetDivisions(string sqlConn) {
2            SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings[sqlConn]);
3
4            strSQL = "Select * from Divisions Where Status = 'A' order by SortOrder, DIV";
5            cn.Open();
6            SqlCommand cmd;
7            SqlDataReader rdr;
8            cmd = new SqlCommand(strSQL, cn);
9            rdr = cmd.ExecuteReader();
10	    cn.Close()
11
12            return rdr;
13        }
14

Use this code in a class that is called to return a datareader