protected void bind_formview(string mode)
    {
        //try
        //{
        //have to use a collection as formview needs to bind to enumerable
        HouseBLTableCollection _hbl = new HouseBLTableCollection();

        if (mode != "Insert")
        {
            //get key id
            int _hblid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));

            HouseBLTable _tbl = new HouseBLTable(_hblid);
            _hbl.Add(_tbl);
        }
        else
        {
            HouseBLTable _tbl = new HouseBLTable();
            _hbl.Add(_tbl);
        }
        this.fmvBol.DataSource = _hbl;
        this.fmvBol.DataBind();
        //}
        //catch (Exception ex)
        //{
        //    this.dxlblErr.Text = ex.Message.ToString();
        //    this.dxpnlErr.ClientVisible = true;
        //}
    }
 public HouseBLTableCollection FetchAll()
 {
     HouseBLTableCollection coll = new HouseBLTableCollection();
     Query qry = new Query(HouseBLTable.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public HouseBLTableCollection FetchByQuery(Query qry)
 {
     HouseBLTableCollection coll = new HouseBLTableCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public HouseBLTableCollection FetchByID(object HouseBLID)
 {
     HouseBLTableCollection coll = new HouseBLTableCollection().Where("HouseBLID", HouseBLID).Load();
     return coll;
 }
    protected void bind_formview(string mode)
    {
        //try
        //{
            //have to use a collection as formview needs to bind to enumerable
            HouseBLTableCollection _hbl = new HouseBLTableCollection();
            if (mode != "Insert")
            {
                //get key id
                int _hblid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));

                HouseBLTable _tbl = new HouseBLTable(_hblid);
                _hbl.Add(_tbl);
            }
            else
            {
                HouseBLTable _tbl = new HouseBLTable();
                _hbl.Add(_tbl);
            }
            this.fmvBol.DataSource = _hbl;
            this.fmvBol.DataBind();
        //}
        //catch (Exception ex)
        //{
        //    this.dxlblErr.Text = ex.Message.ToString();
        //    this.dxpnlErr.ClientVisible = true;
        //}
    }