> 
- Home Page
- > Script C#
- > Script C# XML
- > Tab XML
Tab XML - << VERSIONE VB.NET >>
Importa in XML i dati di un file con i campi separati da tab
<%@ Page Language="c#" Debug="true" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Collections" %>
<%@ Import Namespace="System.Net" %>
<%@ Import Namespace="System.IO" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
fromTabbedToXML((char)13, Server.MapPath("magazzino.tab"));
}
private void fromTabbedToXML(char strDelimiter, string strFilePath)
{
try
{
DataSet oDS = new DataSet();
DataTable oTable = new DataTable();
DataRow oRows;
int intCounter = 0;
oDS.DataSetName = "magazzino";
oDS.Namespace = "magazzino";
oDS.Tables.Add("articolo");
StreamReader oSR = new StreamReader(strFilePath);
oSR.BaseStream.Seek(0, SeekOrigin.Begin);
foreach (string strFields in oSR.ReadLine().Split(strDelimiter))
oDS.Tables[0].Columns.Add(strFields);
oTable = oDS.Tables[0];
while (oSR.Peek() > -1)
{
oRows = oTable.NewRow();
foreach (string strFields in oSR.ReadLine().Split(strDelimiter))
{
oRows[intCounter] = strFields;
intCounter = intCounter + 1;
}
intCounter = 0;
oTable.Rows.Add(oRows);
}
oDS.WriteXml(Server.MapPath("magazzino.xml"));
Label1.Text = "Fatto";
}
catch (Exception ex)
{
Label1.Text = "Errore: <br>" + ex.Message;
}
}
</script>
<html>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
