> 
- Home Page
- > Script C#
- > Script C# XML
- > SQL to XML
SQL to XML - << VB.NET VERSION >>
Import data from a SQLServer table into an XML file
<%@ Page Language="c#" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.XML" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
string strCon = "Server=DATABASESERVER;uid=USERID;pwd=PASSWORD;Database=DATABASE;";
string strSQL = "Select campo1, campo2, campo3 from Tabella order by campo1";
DataSet objDataSet = new DataSet();
SqlConnection objCon;
SqlDataAdapter objAdapter;
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>Scairca l'XML</a>";
}
</script>
<html>
<body>
<asp:label id="message" runat="server" />
</body>
</html>
