SqlConnection m_objConnection = new SqlConnection("ConnectionString");
m_objConnection.Open();
SqlCommand m_objCommand = new SqlCommand("UR_QUERY", m_objConnection);
SqlDataReader m_objDataReader = m_objCommand.ExecuteReader();                        
//Get the data by using the Read() method as
While(m_objDataReader.Read())
{
  //Get the data either BY
  m_objDataReader.GetValue(Column#);
  or By
  m_objDataReader["Column_Name"];

}        
m_objConnection.Close();