Help With Testing A Dataset In Via Code Behind

Hi

I really need your help. I’ve got a table with 4 columns – username (a string of text), dateTime (a date and time), duration (time in minutes), roomID (URL). I really need some help with writing up some code behind to check if a user has permission to continue. I’ve got the first bit, but I need help with collecting the data and testing it:

            SqlConnection conn = new SqlConnection(Global.ConnectionString);
            SqlCommand cmd = new SqlCommand("select * from tblActiveSession where Username=@Username", conn);

            SqlParameter paraUsername = cmd.Parameters.Add("@Username", SqlDbType.NVarChar);
            paraUsername.Value = this.txtUsername.Text;

            try
            {
                conn.Open()

This is where I need the help. What I need is to test each row against the following:

If now() is within the allowed time frame – greater than dateTime, but less than dateTime + duration, then break the loop and redirect to roomID.

I really hope this makes sence, and I’m greatful for any help.

Many thanks
Richard