StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » UltraChart business object connection

UltraChart business object connection

Michael Reese — Mon, 08 Oct 2007 10:56:07 GMT

I am trying to connect to the orders business object with some strange results. I was wondering what is the best way to attach to the business object. Do you have an example?

Michael

RE: UltraChart business object connection

Trent L. Taylor — Mon, 08 Oct 2007 10:56:07 GMT

[quote]Can this be performed with the BBS?[/quote]

Sure. You can create joins, etc. and custom properties and bring back anything that you want (for viewing only). However....if you want to update a join, then you will need to create a view and make it updatable before it will go both ways.

RE: UltraChart business object connection

Michael Reese — Mon, 08 Oct 2007 09:48:09 GMT

Thanks Guys

The reason I am asking is because I am using ULTRACHART and have the following code to pull back data from 2 tables. Can this be performed with the BBS? Do you have an example. I would like to clean up the form and talk to the BOs directely.

Thanks

Michael

****Chart Sample Code****

Dim ds As New SqlConnection(MicroFour.StrataFrame.Data.DataLayer.DataSources.Item(0).ConnectionString.ToString)

Dim Command2 As SqlCommand = New SqlCommand("SELECT B.SiteName,COUNT(B.ID) AS Sites FROM Subjects A INNER JOIN Sites AS B ON A.SiteID = B.ID GROUP BY B.SiteName", ds)

Dim MainDataAdapterDA2 As New SqlDataAdapter

MainDataAdapterDA2.SelectCommand = Command2

Dim MainDataTable2 As New DataTable

MainDataAdapterDA2.Fill(MainDataTable2)

Dim MainSeries2 As New NumericSeries()

'Databind = Datatable,ValueColumn as String and Label Column as String)

MainSeries2.DataBind(MainDataTable2, "Sites", "SiteName")

RE: UltraChart business object connection

Trent L. Taylor — Tue, 02 Oct 2007 09:30:56 GMT

You will want to drop on a BusinessBindingSOurce on the form, then choose the BO that you want to bind to the grid. You will then bind to the UltraGrid using their standard DataBindings (DataSource).

RE: UltraChart business object connection

Michael Reese — Tue, 02 Oct 2007 09:26:10 GMT

Hi Ben

I am using UltraChart. I would like to connect to the BO and expose the fields? It is a simple composite chart. Been trying a few ways without success.

Michael

RE: UltraChart business object connection

StrataFrame Team — Tue, 02 Oct 2007 09:02:44 GMT

Whenever you say "connect" do you mean trying to show the data in a grid? Or are you trying to connect to the db and retrieve records? Or are you just trying to retrieve a field value from the business object? I just need a little more detail on what you're trying to do to point you in the right direction. ;) Thanks.