Binding data from an ADODB recordset (Jet 4.0)

[Buggs2015Participant]

Hello,

I really love how simple and how easy it is to use the JQXGrid,

Do you have an example that I can work with that takes a clientside (as I have an application that runs from the intranet at work) recordset from ADODB and binds it to your grid? I have searched high and low all over the web but could not find such documentation. Id really love to be able to bind my recordset to your Grid because of the Export to Excel, HTML, PDF and CSV features.

Much thanks and appreciation for all your help and support.

Cheers,

Jay

[ivailoParticipant]

Hi Buggs2015,

Unfortunately, we don’t have experience with ADODB.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[taskmateParticipant]

Hi

Suggestion:

If you are using ADODB, I presume you are using .net or .asp. Then a suitable answer could be that you save the recordset from the .net code as xml file and then use the xml file as datasource for the grid.

In case you wish to have code in .net then I might be able to help you further.

The line below is from visual basic 6.0
AdodbRecordset.Save “C:\a.xml”, adPersistXML

Regards

Sanjay

[Author]

Posts