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.

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")

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).

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

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.

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