public Oplitis getRankById(Oplitis myOplitis) { Dal myDal = new Dal(); SqlDataReader dr = myDal.getRankByID(myOplitis); DataTable dt = new DataTable(); if (dr.HasRows) { dt.Load(dr); } foreach (DataRow row in dt.Rows) { myOplitis.rankID = Convert.ToInt32(row["op_rid"].ToString()); } return(myOplitis); }