Anyone do any databinding? RDS? XML?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K.M.L. - 27 Apr 2004 05:13 GMT

Having some trouble. RDS is fine, but seems to not respond after a certain
number of recrods.

So I'm trying to bind between <XML id=xmlData> tags using, but if I do:

xmlData.loadXml oHttp.responseXML 'oHttp=MSXMLHTTP

there is no binding, but data is coming back in oHttp.responseXML

Some mentioned this might be because of the data from recordsets being in
attributes and not elements. I dunno. I just want a HTML table bound to a
datasource and dataflds bound to something that was a disconnected recordset
and can be turned back into one and DOM'ed to page that will do a
BatchUpdate.

RDS is fine for 256 records of 841, but doesn't work after that.

Anyone know of someway to bind data? (My users what 'Excel Lite' as I call
it) and RDS, disconnected recordsets and XML with HTML data binding is the
ticket if I can get it to work.

I can provide more code if needed.

Many thanks,
Kevin

Reply to this Message

Bob Barrows [MVP] - 27 Apr 2004 15:08 GMT

Bob Barrows

> Having some trouble. RDS is fine, but seems to not respond after a
> certain number of recrods.
[quoted text clipped - 8 lines]
> Some mentioned this might be because of the data from recordsets
> being in attributes and not elements. I dunno.

I just realized that I have a demo of using data binding available here (I
wish I had remembered this in our previous discussion):
http://www.davidpenton.com/testsite/tips/xml.data.islands.asp

This demo does not include the XMLHTTP functionality, but it does illustrate
the basic functionality. The server-side code in the demo is the code that
would be in the page to which you would submit a request via xmlhttp.

You will notice that the data in this demo is contained in attributes, and
it works correctly.. In our previous discussion, I mentioned that certain
events did not work correctly when binding table elements to data in
attributes. I wrote this demo before I found out about that bug. This bug
only occurs for editable elements: certain events fire twice when they
should only fire once. There's a KB article about this if you care to look
it up. I found an xsl example on the web that converts attributes to
elements for use in my one page that uses tabular data binding.

> I just want a HTML table bound to a datasource and
> dataflds bound to something that was
> a disconnected recordset and can be turned back into one and DOM'ed
> to page that will do a BatchUpdate.

You will not be able to do this without RDS.

What you can do is save the disconnected recordset to a file after putting
its data in an xml document, then reopen the file when getting data from an
xmlhttp submission, update the data in the recordset with the data in the
submitted dom document, reconnect the recordset and do a batch update.

> RDS is fine for 256 records of 841, but doesn't work after that.
>
> Anyone know of someway to bind data? (My users what 'Excel Lite' as
> I call it) and RDS, disconnected recordsets and XML with HTML data
> binding is the ticket if I can get it to work.

There is a limit to how well an html page is going to be able to mimic a
spreadsheet. You should convey this to your users and offer an alternative
that involves paging the data.

Bob Barrows

Signature

Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Reply to this Message

Brian Staff - 27 Apr 2004 15:31 GMT

Kevin,

I'm assuming you are binding to either <span> or <input> tags inside a table
structure. Show us that structure.

Also show a sample node of your XML structure.

This technique does work - I have used it.

Brian

> Having some trouble. RDS is fine, but seems to not respond after a certain
> number of recrods.
[quoted text clipped - 21 lines]
> Many thanks,
> Kevin

Reply to this Message

Webmaster Forum / Browsers / Internet Explorer / April 2004

Anyone do any databinding? RDS? XML?