Soteriologist
Programmer
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:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
and here's my aspx page code:
Help is much appreciated.
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" "[URL unfurl="true"]http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">[/URL]
<html xmlns="[URL unfurl="true"]http://www.w3.org/1999/xhtml"[/URL] >
<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.
