ObjectDataSource And Connection Pool

I use an ERP system that has muliple Business Objects created for different aspects of the application.

In doing some ASP.NET Development today, I wanted to make use of some of these BO's so that I could connect and make use of the logic the system needs to work properly.
In doing so, I was able to successfully create a new ObjectDataSource and see that I can in fact make use of the logic.  My question however, is that in my application the usage of a connection pool is required almost like a connection string and I"m not sure how to tell my ObjectDataSource what this actual connection pool is actually.

I can write custom VB.NET code to connect like below and it works just fine.  Just would like to use the ObjectDataSource if at all possible.  Seems to me its a LOT more clean.

Here is how I would hard code kicking off the objects "GetList" event.  Would LOVE to do this with an ObjectDataSource so I can just bind things like my datagrids to this.

        Dim objSess As Epicor.Mfg.Core.Session
        objSess = New Epicor.Mfg.Core.Session("Username", "Password", "IP TO APPLICATION SERVER", Epicor.Mfg.Core.Session.LicenseType.Default)
        Dim recSelected As Boolean
        Dim objShipToList As New Epicor.Mfg.BO.ShipTo(objSess.ConnectionPool)
        Dim dsShipToListDataSet As New Epicor.Mfg.BO.ShipToListDataSet
        dsShipToListDataSet = objShipToList.GetList("ShipToNum = '2'", 0, 1, recSelected)
        objSess.Dispose()
LVL 2
chrisryhalAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CodeCruiserCommented:
One option is to write the above code in a method and then specify that method as the SelectMethod of the objectdatasource

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.objectdatasource.selectmethod.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chrisryhalAuthor Commented:
Thanks for the hlep.  That worked.
0
CodeCruiserCommented:
Glad to help :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.