Codejock Developer Community : Datasource and DataBinding

Datasource and DataBinding : For ADO should be fine (at least...

Fri, 24 Jul 2009 08:13:23 +0000

Author: mdoubson
Subject: 14635
Posted: 24 July 2009 at 8:13am

For ADO should be fine (at least in known environments - may be Dataflex have some restrictions?)

Datasource and DataBinding : I am using ADO

Fri, 10 Jul 2009 19:50:40 +0000

Author: Phoenix999
Subject: 14635
Posted: 10 July 2009 at 7:50pm

I am using ADO

Datasource and DataBinding : If you are using a VB6 datasource...

Fri, 10 Jul 2009 13:38:08 +0000

Author: jpbro
Subject: 14635
Posted: 10 July 2009 at 1:38pm

If you are using a VB6 datasource class as your datasource, the CJ RC doesn't support it.

Datasource and DataBinding : Ok Firstly I am using Visual DataFlex...

Thu, 09 Jul 2009 04:12:27 +0000

Author: Phoenix999
Subject: 14635
Posted: 09 July 2009 at 4:12am

Ok Firstly I am using Visual DataFlex as my info shows so a sample would be a waste of time.
Now sorry to labour on this but I am trying to get this working as I expect it should.

Now the code in the sample is:

Private Sub ShowRecords(Table as String)
    ' show records
    If not Rs.State = adStateClosed Then Rs.Close
'    Rs.CursorType = adOpenStatic
    Rs.CursorLocation = adUseClient
    Rs.Open "select * from " & "[" & Table & "]", Con
    Set wndRecords.DataManager.DataSource = Rs
    wndRecords.DataManager.DataBind                                 <----- databind here what is the rest of this code doing?
    ' add empty header row
    wndRecords.PaintManager.HeaderRowsDividerStyle = xtpReportFixedRowsDividerOutlook
    wndRecords.HeaderRecords.DeleteAll
    wndRecords.PopulateHeaderRows
    Dim Record as ReportRecord
    Set Record = wndRecords.DataManager.CreateEmptyRecord
    If Record is Nothing Then Exit Sub
    Dim HeaderRecord as ReportRecord
    Set HeaderRecord = wndRecords.HeaderRecords.Add
    Dim i as Integer
    For i = 0 to Record.ItemCount - 1
        HeaderRecord.AddItem Record.item(i).Value
    Next
    wndRecords.ShowHeaderRows = True
    wndRecords.HeaderRowsAllowEdit = True
    wndRecords.PopulateHeaderRows
    Set Record = Nothing

This appears to me that there is more than just setting the Datasource property to allow the data to display. Is this correct?

Datasource and DataBinding : Phoenix999 wrote:So are you...

Mon, 06 Jul 2009 09:52:45 +0000

Author: Lodep59
Subject: 14635
Posted: 06 July 2009 at 9:52am

Phoenix999 wrote:

So are you saying that the data should be shown automatically?

Absolutly ! It's the meaning of databinding :)

If you run the sample app made by codejock (without changing something), did you have only the columns headers ?

If yes, can you make a sample with some data that isn't working for you ?

Datasource and DataBinding : Yes I saw the sample and And that...

Fri, 03 Jul 2009 20:43:55 +0000

Author: Phoenix999
Subject: 14635
Posted: 03 July 2009 at 8:43pm

Yes I saw the sample and And that is exactly what I am doing.

However all I get is the header row with the column names-there is no data being shown.

Someone else has asked the same question on this forum and got no answer.

So are you saying that the data should be shown automatically?

If so then it isnt happening for me- hence the original question.

Datasource and DataBinding : Phoenix999 wrote:The ReportControls...

Fri, 03 Jul 2009 12:57:30 +0000

Author: Lodep59
Subject: 14635
Posted: 03 July 2009 at 12:57pm

Phoenix999 wrote:

The ReportControls DataSource I just don't get.

Once attached you still need to iterate to create columns
Seems to defeat the purpose of the DataSouce.

Am I missing the way this is used? There is no automatic poulation correect?

Did you see the sample ?

Example :

    ' Open Recordset
    Rs.CursorLocation = adUseClient
    Rs.Open "select * from " & "[" & Table & "]", Con

    ' Data binding
    Set wndRecords.DataManager.DataSource = Rs
    wndRecords.DataManager.DataBind

Datasource and DataBinding : Maybe I am missing something here.I...

Wed, 01 Jul 2009 17:58:41 +0000

Author: Phoenix999
Subject: 14635
Posted: 01 July 2009 at 5:58pm

Maybe I am missing something here.

I have another control where once a datasource is attached it needs no other code to
populate header and columns with correct alignment etc based on the data type.

The ReportControls DataSource I just don't get.

Once attached you still need to iterate to create columns
Seems to defeat the purpose of the DataSouce.

Am I missing the way this is used? There is no automatic poulation correect?

Datasource and DataBinding : Hi, Have you seen the sample...

Wed, 01 Jul 2009 03:41:08 +0000

Author: Lodep59
Subject: 14635
Posted: 01 July 2009 at 3:41am

Hi,

Have you seen the sample released by CJ ?

You can find it on your installation folder in :

Samples\ReportControl\VB\ReportDataBinding

In my opinion, this example should be included in the start menu shortcuts ...

Datasource and DataBinding : New user of Codejock (v13). I...

Fri, 26 Jun 2009 20:07:30 +0000

Author: Phoenix999
Subject: 14635
Posted: 26 June 2009 at 8:07pm

New user of Codejock (v13).

I am having trouble understanding whether the datasource property once set from an ADO data sourse should display the data or not.

The header columns get the correct labels but no data is showm

I have looked through the forums and note there are a few questions of this type BUT no answer forthcoming. Is this supported?

I have other controls that once the datasource is set that is all that is reqiored to display the data.

So does Codejock work this way? Or do you have to request row by row from the datasource and manually display the date. Is dso seems to defeat the purpose