No problem, been there done that...just about every day!
--- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> Thanks for showing me the obvious or getting me to back up and see the forest again instead of staring at the trees. I should have thought of that.
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of zanniebelle
> Sent: Wednesday, February 22, 2012 4:54 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Add Standard Context Menu to UltraGrid
>
>
>
> Don't work with the UltraGrid, work with it's DataSource.
>
> If you're doing something like this:
> String BaqID = "someBAQId";
> DynamicQueryAdapter adDynamic = new DynamicQueryAdapter(someFormName);
> adDynamic.BOConnect();
> adDynamic.GetDashboardQuery (BaqID);
> Epicor.Mfg.BO.QueryDesignDataSet ds = adDynamic.RuntimeQuery;
> adDynamic.ExecuteDashboardQuery(ds);
>
> You can now grab the DataTable:
> DataTable dt = adDynamic.QueryResults.Tables[0];
>
> -OR- after you have assigned the grid's DataSource
> Epicor.Mfg.BO.QueryDesignDataSet ds = (DataSet) someUltraGrid.DataSource;
> DataTable dt = ds.Tables[0];
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Dan Godfrey <dgodfrey@> wrote:
> >
> > This looks simple but the issues I seem to be getting stonewalled is because I am assigning the dataset from the DynamicQueryAdapter to the Grid.DataSource and THEN manipulating the columns. So I have to work with Infragistics.Win.UltraWinGrid.UltraGridColumn which doesn't contain ExtendedProperties.
> >
> > ________________________________
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of zanniebelle
> > Sent: Tuesday, February 21, 2012 1:34 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Add Standard Context Menu to UltraGrid
> >
> >
> >
> > Set the column's "Like" extended property.
> >
> > The following will allow "Open With..." context menu on a result set from a BAQ or stored procedure call:
> >
> > //Cast the grids DataSource to a DataTable:
> > DataTable lo_table = (DataTable) somegrid.DataSource;
> >
> > // iterate the columns for the one you want:
> > foreach(DataColumn lo_col in lo_table.Columns)
> > {
> > if(lo_col.ColumnName.ToUpper() == "PO")
> > lo_col.ExtendedProperties["Like"] = "POHeader.PONum";
> > }
> >
> > -OR-
> >
> > if you already know the column name:
> > lo_table.Columns["PO"].ExtendedProperties["Like"] = "POHeader.PONum";
> >
> > Hope this helps!
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "dgodfrey_amc" <dgodfrey_amc@> wrote:
> > >
> > >
> > >
> > > Hi All,
> > > I would like to bring this post back. I didn't see anyone respond to this post. This is exactly what I was looking for and hoping someone has an answer for it.
> > >
> > > Joe, Did you ever come up with an answer yourself?
> > >
> > > Dan
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Joe Rojas <jrojas@> wrote:
> > > >
> > > > Hi All,
> > > >
> > > >
> > > >
> > > > I've added an UltraGrid to my customization that is populated with a BAQ
> > > > using the DynamicQuery BO.
> > > >
> > > > One of the fields is Customer ID and I'd like to add the standard Epicor
> > > > context menu to this field.
> > > >
> > > > Is this possible?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Joe Rojas | Director of Information Technology | Mats Inc
> > > > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > > > jrojas@ | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
> > > >
> > > >
> > > > This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>