Hello
I'm working on an ASP.NET webapp and I must fill a datagrid with some old
ADO recordset format XML files (made with Save command in vb6) which is not
(fully) compatible with ADO.NET.
Do you a trick to allow this?

Sylvain

You will either have to:

1. Use interop, with ADO
2. Consume as XML
3. Transform the XML into the ADO.NET format

Show quoteHide quote

Sylvain,

From Help:

"To provide access from ADO.NET to ADO Recordset and Record objects, the
..NET Framework Data Provider for OLE DB overloads the Fill method of the
OleDbDataAdapter to accept an ADO Recordset or Record object."

There is more detailed info in Help, under DataTable class, accessing ADO
Recordset or Record.

Kerry Moorman



Show quoteHide quote

I'm not totally familiar with ADO in ASP.NET pages, but you mentioned that
you have XML files.  What about using Dataset.ReadXML()?
-Altaf
--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com


Show quoteHide quote

Sylvian,

I assume that your XML file is a self build XML file.

That means that you can read that file using the XMLTextreader.

See this sample (The XML is in the sample)

http://www.vb-tips.com/default.aspx?ID=e788c048-e547-4de3-9c6a-22589f018cd4

Than you can set that item by item in a datatable, which you can use as a
datasource for your datagrid.

To create an empty datatable it is

dim dt as new datatable
dt.columns.add(mycolumn1,gettype(system.String))'or other types in VB helps
intelligence for that.
etc. for all columns

Filling a datatable while you are reading is probably nothing more than
creating the fields and than

dt.loaddatarow(new object() {field1,field2,field3},true)

and than setting this to your datagrid

datagrid1.datasource = dt
datagrid1.databind

I hope this helps,

Cor



Show quoteHide quote

Datagrid with search capabilities, how to implement it?
Add New in Bindings Navigator problem
Select next item in DB without knowing what ID it has
Oracle Adventures
DataTable.Select() - is it possible to pass rows back to datatable