private void LoadRows() { if (this.Query != null) { this.Grid.NoRows = this.Query.Store.Count(); for (int i = 0; i < this.Grid.NoRows; i++) { Model.Item item = this.Query.Store[i]; int j = 0; foreach (Model.PropertyType proptype in this.Query.Store.ItemType.SearchPropertyTypes) { Model.Property property = item.Property(proptype); this.Grid.Rows[i].Cells[j].Binding = property; j++; } } } else { // Clear all Rows this.Grid.NoRows = 0; } }
static void Main(string[] args) { Server server = new Server("http://localhost/InnovatorServer100SP4"); Database database = server.Database("CMB"); Session session = database.Login("admin", IO.Server.PasswordHash("innovator")); Query query = session.Query("v_Order"); query.Select = "part"; query.Property("part").Select = "item_number,name,cmb_name,description,major_rev,keyed_name,state,cmb_ibs_transfer_lock,cmb_ibs_commodity_code,cmb_ibs_eng_order_no,cmb_ibs_field19,cmb_ibs_lead_time,cmb_ibs_mat_move_code,cmb_ibs_part_type,cmb_ibs_planner_code,cmb_ibs_product_code,cmb_ibs_product_group,cmb_name_no_cr,make_buy,unit"; Model.Item order = query.Store.Get("7BDC68F4B7BB49F8BC124E56246939BC"); Model.Item part = (Model.Item)order.Property("part").Value; }