将XML文件导入到Oracle数据库中思路.doc

将XML文件导入到Oracle数据库中的思路 一、程序源码 前台代码： %@ Page Language=C# AutoEventWireup=true CodeFile=ImportData.aspx.cs Inherits=ImportData % !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN HYPERLINK /TR/xhtml1/DTD/xhtml1-transitional.dtd /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns= HYPERLINK /1999/xhtml /1999/xhtmlhead runat=server???? title将Xml文件导入到数据库/title /head body ??? form id=form1 runat=server ??? div ??????? TABLE id=Table1 cellSpacing=3 cellPadding=3 bgColor=#99ccff border=0 ??????????????? TR ??????????????????? TD align=center colSpan=2STRONGFONT size=6读取Xml，导入Oracle并显示/FONT/STRONG/TD ??????????????? /TR ??????????????? TR ??????????????????? TD colSpan=2FONT size=2读取Xml文件中的内容，并将其内容导入到Oracle数据库/FONT/TD ??????????????? /TR ??????????????? TR ??????????????????? TD bgColor=#cccccc style=width: 129px; height: 27px;FONT size=2strong请输入Xml文件名/strong/FONT/TD ??????????????????? TD bgColor=#cccccc style=height: 27px ??????????????????????? asp:TextBox ID=textBoxXml runat=server Font-Names=Arial Font-Size=X-Small ??????????????????????????? Width=500px/asp:TextBox/TD ??????????????? /TR??????????????? ??????????????? TR ??????????????????? TD colSpan=2 style=height: 18px ??????????????????????? asp:Label id=Message runat=server Font-Bold=True Font-Size=X-Small ForeColor=Red/asp:Label/TD ??????????????? /TR ??????????????? TR ??????????????????? TD style=width: 129px; height: 17px/TD ??????????????????? TD style=height: 17px ??????????????????????? asp:Button id=buttonSubmit runat=server Text=Submit OnClick=buttonSubmit_Click/asp:Button/TD ??????????????? /TR ??????????? /TABLE ??????? br / ??????? strongspan style=color: #0066ff测试从Xml文件是否能成功读取数据/spanbr / ??????????? asp:GridView ID=GridView1 runat=server CellPadding=4 ForeColor=#333333 GridLines=None ??????????????? FooterStyle BackColor=#990000 Font-Bold=True ForeColor=White / ??????????????? RowStyle BackColor=#FFFBD6 ForeColor=#333333 / ??????????????? SelectedRowStyle