By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,089 Members | 1,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,089 IT Pros & Developers. It's quick & easy.

SQL FOR XML Query results to Text via ASP.NET

P: n/a
Rob
I doubt this is the best way to do it, but what I came up
with was to hide the XML in an HTML Comment then edit the
file deleting the HTML stuff and keep the XML results. If
anyone has a better solution, I would be interested.
Thank you.

Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
Dim cmd As System.Data.SqlClient.SqlCommand
cmd = New System.Data.SqlClient.SqlCommand
("STSspXMLHistory", Me.SqlConnection1)
cmd.CommandType = CommandType.StoredProcedure
Me.SqlConnection1.Open()
Dim myDataReader As
System.Data.Sqlclient.SqlDataReader = cmd.ExecuteReader
(CommandBehavior.CloseConnection)
Response.Write("<!--")
If myDataReader.HasRows Then
Do While myDataReader.Read()
Response.Write(myDataReader.GetValue
(0).ToString)
Loop
Else
Response.Write("No rows returned.")
End If
Response.Write("-->")

'DataGrid1.DataSource = myDataReader
'DataGrid1.DataBind()

myDataReader.Close()
Me.SqlConnection1.Close()
End Sub
-----Original Message-----
I tried the code below from the help files to read throughthe datareader and print the results, however, I get
a "timeout" error. Is there a way to use Response.Write
instead? The query results are large. Thank you in
advance.

If myDataReader.HasRows Then
Do While myDataReader.Read()
Console.WriteLine(vbTab & "{0}" & vbTab
& "{1}", myDataReader.GetInt32(0), myDataReader.GetString
(1))
Loop
Else
Console.WriteLine("No rows returned.")
End If
-----Original Message-----
As a workaround to a problem I'm having with the results
pane in Query Analyzer properly displaying a text field

in
a Latin1_General_Bin collation database, I've begun

trying
to use ASP.NET to return the results of the query in Textfor use as a one time XML file build. The query is a FORXML Explicit.

So far, I've tried sending the results of the query via astored procedure to a datagrid. However this cuts off
much of the results due the column and row limitation in
the grid. What I would simply like to do is some kind ofresponse.write of the results of the query as text
directly in the browser or in a very large text box

rather
than the datagrid. Then I can copy/paste to a text file
and work with the results there.

The code follows below:

Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
Dim cmd As System.Data.SqlClient.SqlCommand
cmd = New System.Data.SqlClient.SqlCommand
("RobXML", Me.SqlConnection1)
cmd.CommandType = CommandType.StoredProcedure
Me.SqlConnection1.Open()
Dim myDataReader As
System.Data.Sqlclient.SqlDataReader = cmd.ExecuteReader
(CommandBehavior.CloseConnection)
DataGrid1.DataSource = myDataReader
DataGrid1.DataBind()
myDataReader.Close()
Me.SqlConnection1.Close()
End Sub

Private Sub DataGrid1_SelectedIndexChanged(ByVal
sender As System.Object, ByVal e As System.EventArgs)

End Sub
End Class
.

.

Nov 18 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.