protected void btnRegCard_Click(object sender, EventArgs e)
    {
        CheckIn checkIn = new CheckIn();

        checkIn.Reservation_ID = SqlInt32.Parse(hidReservationId.Value);
        DataTable tbaleCard = checkIn.SelectOne_ByReservationID();//FOR registration card

        // Session["welcomeCard"] = tbaleCard;

        tbaleCard.TableName = "RegistrationCard";
        SecondaryGuests sg = new SecondaryGuests();

        sg.Reservation_ID = SqlInt32.Parse(hidReservationId.Value);
        DataTable tbaleCardSg = sg.SelectAll();//to get the Secondary guest

        tbaleCardSg.TableName = "Guest";
        DataSet DS = new DataSet();

        DS.Tables.Add(tbaleCard);
        DS.Tables.Add(tbaleCardSg);
        Session["welcomeCard"] = DS;
        string popupScript = "<script language='javascript'>" +
                             "window.open('RegCard.aspx','ThisPopUp1', " +
                             "'left = 300, top=150,  " +
                             "menubar=no, scrollbars=yes, resizable=yes')" +
                             "</script>";

        Page.ClientScript.RegisterStartupScript(GetType(), "PopupScript", popupScript);
    }
    private DataTable GetSecondaryGuests()
    {
        int             reservationId = hidReservationId.Value == string.Empty ? 0 : Int32.Parse(hidReservationId.Value);
        SecondaryGuests sg            = new SecondaryGuests();

        sg.Reservation_ID = reservationId;
        secGuestsTbl      = sg.SelectAll();

        return(secGuestsTbl);
    }