怎么把txt文件转换成xml文件
发布网友
发布时间：2022-04-23 00:50
共1个回答
热心网友
时间：2023-10-05 17:57
<%@
Import
Namespace="System.Data"
%>
<%@
Import
Namespace="System.Data.SqlClient"
%>
<html>
<head>
<script
language="C#"
runat="server">
public
DataView
Source;
public
DataSet
ds;
public
bool
getSchema,
getData;
public
void
Submit_Click(Object
sender,
EventArgs
evt)
{
if
(IsPostBack)
{
SqlConnection
myConnection
=
new
SqlConnection(ConnectString.Value);
SqlDataAdapter
myCommand
=
new
SqlDataAdapter(myText.Value,
myConnection);
ds
=
new
DataSet();
myCommand.Fill(ds,
"表");
Source
=
new
DataView(ds.Tables[0]);
getSchema
=
GetSchema.Checked;
getData
=
GetData.Checked;
MyDataGrid.DataSource=Source;
MyDataGrid.DataBind();
}
}
</script>
</head>
<body
bgcolor="ffffcc">
<h3><font
face="宋体">SQL
到
XML
生成器</font></h3>
<form
runat="server">
<table
border=0
cellpadding=5
style="font:10.5pt
宋体">
<tr>
<td
colspan="2">
<b>连接字符串:</b><br>
<input
id="ConnectString"
type="text"
value="server=(local);database=pubs;uid=sa;pwd=1234"
size="85"
runat="server">
</td>
</tr>
<tr>
<td
colspan="2">
<b>查询:</b><br>
<input
id="myText"
type="text"
value="SELECT
*
FROM
Authors"
size="85"
runat="server">
</td>
</tr>
<tr>
<td>
<input
type="radio"
id="GetSchema"
name="Mode"
runat="server"/>获取
XML
架构<br>
<input
type="radio"
id="GetData"
name="Mode"
runat="server"/>获取
XML
数据<br>
<input
type="radio"
id="GetBoth"
name="Mode"
checked
runat="server"/>两者都获取
</td>
<td
valign="top">
<input
type="submit"
runat="server"
OnServerClick="Submit_Click">
</td>
</tr>
<tr>
<td
colspan="2">
<%
if
(Page.IsPostBack)
{
%>
<b>结果：</b><br>
<textarea
cols=80
rows=25>
<%
if
(getSchema)
ds.WriteXmlSchema(Response.Output);
else
if
(getData)
ds.WriteXml(Response.Output,
XmlWriteMode.IgnoreSchema);
else
ds.WriteXml(Response.Output,
XmlWriteMode.WriteSchema);
%>
</textarea>
<%
}
%>
</td>
</tr>
<tr>
<td
colspan="2">
<%
if
(Page.IsPostBack)
{
%>
<b>数据：</b><br>
<%
}
%>
<ASP:DataGrid
id="MyDataGrid"
BackColor="#EDBE7B"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#DC6035"
EnableViewState="false"
runat="server"
/>
</td>
<tr>
</table>
</form>
</body>
</html>
用C#来做。要用XmlTextWriter向TXT文件中写内容。
using
System.Xml;
using
System.Text;
XmlTextReader
xmlReader
=
null;
xmlReader
=
new
XmlTextReader(mDocument);
//mDocument参数为xml文档名字
while(xmlReader.Read())
{
if(xmlReader.NodeType
==
XmlNodeType.Element)
{
while(xmlReader.MoveToNextAttribute())
{
//用XmlTextWriter类将xmlReader.Name和xmlReader.Value写入HTML做
//相应的处理
}
if(xmlReader.IsEmptyElement)
{
}
else
{
}
}
else
if(xmlReader.NodeType
==
XmlNodeType.EndElement)
{
//做自己的处理
}
else
if(xmlReader.NodeType
==
XmlNodeType.Text)
{
if
(xmlReader.Value.Length
!=
0)
{
//将xmlReader.Value
写入TXT中的处理
}
}
}
//end
of
~while(xmlReader.Read())
展开
