Dynamically loading raw XML from SQL2K into an XML doc (ASP to C#)

[Frank Drebin]

In ASP, I have something like this:

Set conn = Server.CreateOb ject("ADODB.Con nection")
Set cmd = Server.CreateOb ject("ADODB.Com mand")
Set adoStream = Server.CreateOb ject("ADODB.Str eam")
conn.Open strConnString
Set cmd.ActiveConne ction = conn
cmd.CommandText = strSQL
adoStream.Open
cmd.Properties( "Output Stream").Value = adoStream
cmd.Properties( "xml root") = "XMLRoot"
cmd.Execute , , adExecuteStream
adoStream.Posit ion = 0
xmlDoc.loadXML adoStream.ReadT ext()

In C#, I have this so far:

System.Data.Ole Db.OleDbConnect ion objCN = new
System.Data.Ole Db.OleDbConnect ion();
objCN.Connectio nString = ConnString;
objCN.Open();
System.Data.Ole Db.OleDbCommand objCmd = new
System.Data.Ole Db.OleDbCommand ();
objCmd.Connecti on = objCN;
objCmd.CommandT ype = CommandType.Tex t;
objCmd.CommandT ext = strSQL;
System.Data.Ole Db.OleDbDataRea der objDR = objCmd.ExecuteR eader();

System.Xml.XmlD ocument xmlDom = new System.Xml.XmlD ocument();
xmlDom.Load(<I need that data reader in some loadable format here>);

Just a regular connection and returning a datareader - but to create an XML
doc, it needs an XmlReader - which DataReader isn't compatible. How can I
take the raw stream from OleDb and load that right into an XML doc?

Any ideas? Thanks in advance...

[Frank Drebin]

Can anyone help me out - I'm really in a jam here.. :o(

"Frank Drebin" <no*****@imsick ofspam.com> wrote in message
news:VI******** **************@ newssvr28.news. prodigy.com...

In ASP, I have something like this:

Set conn = Server.CreateOb ject("ADODB.Con nection")
Set cmd = Server.CreateOb ject("ADODB.Com mand")
Set adoStream = Server.CreateOb ject("ADODB.Str eam")
conn.Open strConnString
Set cmd.ActiveConne ction = conn
cmd.CommandText = strSQL
adoStream.Open
cmd.Properties( "Output Stream").Value = adoStream
cmd.Properties( "xml root") = "XMLRoot"
cmd.Execute , , adExecuteStream
adoStream.Posit ion = 0
xmlDoc.loadXML adoStream.ReadT ext()

In C#, I have this so far:

System.Data.Ole Db.OleDbConnect ion objCN = new
System.Data.Ole Db.OleDbConnect ion();
objCN.Connectio nString = ConnString;
objCN.Open();
System.Data.Ole Db.OleDbCommand objCmd = new
System.Data.Ole Db.OleDbCommand ();
objCmd.Connecti on = objCN;
objCmd.CommandT ype = CommandType.Tex t;
objCmd.CommandT ext = strSQL;
System.Data.Ole Db.OleDbDataRea der objDR = objCmd.ExecuteR eader();

System.Xml.XmlD ocument xmlDom = new System.Xml.XmlD ocument();
xmlDom.Load(<I need that data reader in some loadable format here>);

Just a regular connection and returning a datareader - but to create an XML doc, it needs an XmlReader - which DataReader isn't compatible. How can I
take the raw stream from OleDb and load that right into an XML doc?

Any ideas? Thanks in advance...