June 8th, 2006, 06:38 PM
|
|
Registered User
|
|
Join Date: May 2006
Posts: 19
Time spent in forums: 6 h 33 m 4 sec
Reputation Power: 0
|
|
|
Converting SQL to XML
I'm trying to convert some sql data to xml with some visual basic code-behind... but it's not working.
When I fire off the page it just flashes and stays blank. It doesn't display at all my label I tell it to when the code is finished.
Right now I'm firing it off whent he page loads just to simplify things, but I previously had a button that was used to initialize it. It failed with the same result, page flashes, no label displays. I even check up on my server where the xml doc is supposed to be saved to but it's not found.
Here's my code behind:
Code:
Imports System.Data.SqlClient
Imports System.Data
Imports System.Xml
Partial Class SQL_to_XML
Inherits System.Web.UI.Page
Sub Page_Load(ByVal Source As Object, ByVal E As EventArgs)
Dim strCon As String = "workstation id=""BLAH"";packet size=4096;integrated security=SSPI;data source=""BLAH"";persist security info=False;initial catalog=BLAH"
Dim strSQL As String = "SELECT BLAH, BLAH, BLAH FROM BLAH"
Dim objDataSet As New DataSet()
Dim objCon As SqlConnection
Dim objAdapter As SqlDataAdapter
objCon = New SqlConnection(strCon)
objAdapter = New SqlDataAdapter(strSQL, objCon)
objAdapter.Fill(objDataSet, "Tbl")
objDataSet.WriteXml(Server.MapPath("Tbl.xml"))
message.Text = "<a href=Tbl.xml>XML output</a>"
End Sub
End Class
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
and here's my aspx page code:
Code:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="SQL_to_XML.aspx.vb" Inherits="SQL_to_XML" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>SQL to XML</title>
<script language="VB">
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:label id="message" runat="server" />
</div>
</form>
</body>
</html>
Help is much appreciated.
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
