📄 xmlgenerator.aspx
字号:
<%@ Import Namespace="System.IO" %>
<%@ 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 myCon = new SqlConnection(ConnectString.Value);
SqlDataAdapter MC = new SqlDataAdapter(myText.Value, myCon);
ds = new DataSet();
MC.Fill(ds, "Table");
Source = new DataView(ds.Tables[0]);
getSchema = GetSchema.Checked;
getData = GetData.Checked;
//用于保存转换后的XML文件的文件名
string filename=Server.MapPath("./")+"myXml.xml";
//创建文件流
System.IO.FileStream myFileStream =new FileStream(filename,FileMode.Create);
//判断用户选择输出Schema或者Data或两者
if (getSchema)
//输出为Schema
ds.WriteXmlSchema(myFileStream);
else if (getData)
//输出为Data
ds.WriteXml(myFileStream, XmlWriteMode.IgnoreSchema);
else
//两者都输出
ds.WriteXml(myFileStream);
MyDataGrid.DataSource=Source;
MyDataGrid.DataBind();
}
}
</script>
</head>
<body>
<h3>从SQL转换为XML</h3>
<form runat="server">
连接参数：<input id="ConnectString" type="text" value="server=(local)\NetSDK;database=Northwind;Trusted_Connection=yes" size="60" runat="server"><br>
SQL语句：<input id="myText" type="text" value="select * from Shippers" size="60" runat="server"><br>
<input type="radio" id="GetSchema" name="Mode" runat="server"/>得到XML Schema<br>
<input type="radio" id="GetData" name="Mode" runat="server"/>得到XML Data<br>
<input type="radio" id="GetBoth" name="Mode" checked runat="server"/>得到XML Schema和Data<br>
<input type="submit" runat="server" OnServerClick="Submit_Click"><hr>
<ASP:DataGrid id="MyDataGrid"
ShowFooter="false"
EnableViewState="false"
runat="server"/>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -