目标是把order.xml里的数据导入数据库 是不是程序哪里有问题
order.xml:
<?xml version="1.0" encoding="gb2312"?>
<Orders>
<Order date="2001-09-23">
<OrderId> O-01 </OrderId>
<Customer category="个人">
<CustomerId> KH-0786 </CustomerId>
<CustomerName> 陈 </CustomerName>
<CustomerAddress> 科技学院 </CustomerAddress>
<CustomerZip> 210027 </CustomerZip>
</Customer>
<BookId> B-0125 </BookId>
<Number Unit="本"> 1 </Number>
</Order>
<Order date="2001-09-23">
<OrderId> O-02 </OrderId>
<Customer category="单位">
<CustomerId> KH-0787 </CustomerId>
<CustomerName> 王 </CustomerName>
<CustomerAddress> XX学院 </CustomerAddress>
<CustomerZip> 210028 </CustomerZip>
</Customer>
<BookId> B-0124 </BookId>
<Number Unit="本"> 10 </Number>
</Order>
<Order date="2001-09-23">
<OrderId> O-04 </OrderId>
<Customer category="单位">
<CustomerId> KH-0789 </CustomerId>
<CustomerName> 张 </CustomerName>
<CustomerAddress> XZ学院 </CustomerAddress>
<CustomerZip> 210030 </CustomerZip>
</Customer>
<BookId> B-0129 </BookId>
<Number Unit="本"> 19 </Number>
</Order>
<Order date="2001-09-23">
<OrderId> O-03 </OrderId>
<Customer category="个人">
<CustomerId> KH-0788 </CustomerId> 数据挖掘研究院
<CustomerName> 李 </CustomerName>
<CustomerAddress> XY学院 </CustomerAddress>
<CustomerZip> 210025 </CustomerZip>
</Customer>
<BookId> B-0199 </BookId>
<Number Unit="本"> 15 </Number>
</Order>
</Orders>
order.xml.cs
using System;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
namespace XMLtoDB
{class Class1
{static void Main(string [] args)
{SqlConnection conBookOrder=new
SqlConnection ("Server =SQL Server; Database=BookOrder;UID=sa;PWD=");
DataSet dstBookOrder =new DataSet();
SqlDataAdapter dadCustomer=new SqlDataAdapter ("Select * From Customers",conBookOrder);
dadCustomer.Fill (dstBookOrder,"Customers");
DataTable dtblCustomer =dstBookOrder.Tables["Customers"];
SqlDataAdapter dadOrder=new SqlDataAdapter ("Select * From Orders",conBookOrder);
dadOrder.Fill (dstBookOrder,"Orders");
DataTable dtblOrder =dstBookOrder.Tables["Orders"];
}}}}
问题补充：
是不是在VS里运行程序就可以了?
