He was not having a reference location problem - but more an issue of not having the right references. The client handles bringing in the assemblies from the proper location, unless you choose to go browse elsewhere which will not work. The path, once added, is smart enough to show whether it initially came from an E:\EpicorClient or now needs C:\EpicorClient
Many Many Thanks @danbedwards
your code is working great, it slow the UI abit but this is acceptable compare to what we achieved, now i can use this ‘superduper’ code method technique to Add, link, and display any value on the Database to any Epicor Custom Tracker, really appreciate your support.
@ckrusen,
Thanks for your note, but @danbedwards already helped me to find these assy DLL files.
Hi Dan,
i hope that you are ok, i am trying to apply this code to add a field (OrderRel.NeedByDate) to the Demand Custom Grid in Job Manager, the new issue in this case is passing three parameters not one i.e. OrderNum, OrderLine, and OrderRel, also could you please shed some light on GetByID LINQ structure here, as i menstioned before i have started teach myself C# in the past 6 months, and i am doing OK so far, so if you or any one on this great Forum know useful websites/documents/training material describing using Database C#.Net commands, i will be very appreciated to your advice,
Hi all @hkeric.wci,
could any one help on this code issue ???
i am trying to apply this code to add a field (OrderRel.NeedByDate) to the Demand Custom Grid in Job Manager, the new issue in this case is passing three parameters not one i.e. OrderNum, OrderLine, and OrderRel, also could you please shed some light on GetByID LINQ structure here, as i menstioned before i have started teach myself C# in the past 6 months, and i am doing OK so far, so if you or any one on this great Forum know useful websites/documents/training material describing using Database C#.Net commands, i will be very appreciated to your advice,
OK, not getting the exception anymore but i can’t get this code to work
if (!string.IsNullOrEmpty(resource))
{
DataSet ds = _boReader.GetRows(“Erp:BO:Resource”, “ResourceID=’” + resource + “’”, “Description”);
if(ds.Tables[0].Rows.Count > 0)
{
row.Cells[“ResouceDesc”].Value = ds.Tables[0].Rows[0][“Description”];
}
Hi @tkoch
could you share a full example here please, mine on this thread was selected for one column as a parameter and was very slow compared to the Dynamic query
I was just indicating that in theory since you are specifying a smaller dataset to return boreader should be good to use, though I have not compared it returning the same data vs dynamic query. I have used boreader in a lot of places and haven’t observed any noticeable performance losses. I’ll run a test since I’m now curious
then based on this, the second step which is inserting back the data to existed grid row by row is the bottleneck as DQ will display the whole data in one hit !! am i right ?
Yes, I think it is slow because it runs for each row in the grid. I have done in the past if I know I need data like this I just pull all the data in one call to a dataset (just query for Resource table on form load) then on row initialize find the relevant data in the dataset rather than running a query for each row