SQL server 2000 and XML

webmasterbeta

New Member
How to bind a table in the client browser to data back from SQL Server 2000using the new feature "For XML Auto"?For example, there is an ADO recordset, rs and I called,rs.open "Select FieldName1, Fieldname2 From Tablename For XML Auto, Elements",cnConnectionObjectHow can I bind a table in client browser to this recordset(or XML derivedfrom this recordset)?Somebody told me it is very easy to derive an XML (or rather XML documentfrom the recordset) and bind it to a table. But I don't know how?Can someone tell me?
 
Back
Top