Scrivere un file XML
<%@ Page Language="c#" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection objCon = new SqlConnection("server=DBSERVER;User id=USER;password=PWD;database=DB");
SqlDataAdapter objAdapter;
DataSet ds = new DataSet();
objAdapter = new SqlDataAdapter("Select campo1, campo2 from miaTabella", objCon);
objAdapter.Fill(ds, "miaTabella");
ds.WriteXml(Server.MapPath("./miaTabella.xml"));
}
</script>
Scarica il Codice...
Stampa la pagina