Re: bind HTML table to ADO persisted recordset client-side


"Bruce Hensley" <nobody@nowhere> wrote in message
news:eJgYKNExFHA.1412@xxxxxxxxxxxxxxxxxxxxxxx
> I've seen hints that it is possible to bind an HTML table to an ADO
> recordset, but I can't find an example.
>
> I would like to persist a disconnected recordset on the local client, then
> open it (read-only) from DHTML and bind it to a table. I want to use
> recordset.sort and .filter to manipulate the display dynamically.
>
> I can find info and examples on binding to XML data islands, TDC, and
> others, but not just to a recordset. Am I missing something?

Persisted to a file on the client and persisted to a data island are really
the same basic things, you can open a recordset by passing it an XML
DOMDocument object (which exposes an IStream) or you can open it by passing
it a file name, or even a URL -- it makes no difference really.

Not sure what TDC is -- do you mean RDC? You will want to use an RDC object
but you can hook it up to data on the fly, by setting its SourceRecordset
property to an open recordset object. Sort it using the RDC.recordset
property.

Not that I want to be disingenous about the task, but there isn't much more
to it than that, and the databound-related attributes on the table and its
cells.


-Mark




> Thanks,
> Bruce
>
>


.

Relevant Pages

  • DataReport in Visual Basic 6
    ... I would like to know if we can bind the same DataReport (Visual Basic ... Qr1 =" Select EMP_ID, FirstName, LastName from Pers where Function ... I just want to know if we can bind two different RecordSet to the Same ...
    (microsoft.public.vb.crystal)
  • DataReport in Visual Basic 6
    ... I would like to know if we can bind the same DataReport (Visual Basic ... Qr1 =" Select EMP_ID, FirstName, LastName from Pers where Function ... I just want to know if we can bind two different RecordSet to the Same ...
    (microsoft.public.vb.general.discussion)
  • DataReport in Visual Basic 6
    ... I would like to know if we can bind the same DataReport (Visual Basic ... Qr1 =" Select EMP_ID, FirstName, LastName from Pers where Function ... I just want to know if we can bind two different RecordSet to the Same ...
    (comp.lang.basic.visual.misc)
  • Re: ADO Form bind
    ... setting the control source to County makes the text not updateable that I ... I don't believe you can bind an updatable form to an ADO recordset using the Jet provider. ...
    (microsoft.public.access.formscoding)
  • Re: Bindind a listbox to a recordset using DAO in Access 2000 VBA
    ... and only to bind the list ... I know the recordset is being ... > the Listbox doesn't appear to bind itself; I end with a blank list ... > Dim wks As DAO.workspace ...
    (microsoft.public.word.vba.general)