假如XML文件如下:
<?xml version="1.0" encoding="gb2312" standalone="no"?>
<HyperLinks>
<url>
<names>免费邮</names>
<address>http://mail.21cn.com</address>
</url>
<url>
<names>天一庄9家业主一夜被盗</names>
<address>http://house.21cn.com/news/news/2007/03/30/3157184.shtml</address>
</url>
</HyperLinks>要插入的数据库为testdata,表为test,表中只有两个字段,一个为names,一个为address;代码如下:
SqlConnection conn=new SqlConnection("server=(local);database=testdata;uid=sa;pwd=yuhaixia");
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
conn.Open();
string strSQL = "";
DataSet xmlDataSet=new DataSet();
xmlDataSet.ReadXml("132.xml");
for (int i = 0; i < xmlDataSet.Tables[0].Rows.Count; i++)
{
String a,b;
a= xmlDataSet.Tables[0].Rows[i][0].ToString();
b= xmlDataSet.Tables[0].Rows[i][1].ToString();
strSQL = "insert into test (names,address) values ("+ "'" +a +"'" +","+ "'" +b+ "'" +")";
cmd = new SqlCommand(strSQL, conn);
cmd.ExecuteNonQuery();
}
conn.Close();
<?xml version="1.0" encoding="gb2312" standalone="no"?>
<HyperLinks>
<url>
<names>免费邮</names>
<address>http://mail.21cn.com</address>
</url>
<url>
<names>天一庄9家业主一夜被盗</names>
<address>http://house.21cn.com/news/news/2007/03/30/3157184.shtml</address>
</url>
</HyperLinks>要插入的数据库为testdata,表为test,表中只有两个字段,一个为names,一个为address;代码如下:
SqlConnection conn=new SqlConnection("server=(local);database=testdata;uid=sa;pwd=yuhaixia");
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
conn.Open();
string strSQL = "";
DataSet xmlDataSet=new DataSet();
xmlDataSet.ReadXml("132.xml");
for (int i = 0; i < xmlDataSet.Tables[0].Rows.Count; i++)
{
String a,b;
a= xmlDataSet.Tables[0].Rows[i][0].ToString();
b= xmlDataSet.Tables[0].Rows[i][1].ToString();
strSQL = "insert into test (names,address) values ("+ "'" +a +"'" +","+ "'" +b+ "'" +")";
cmd = new SqlCommand(strSQL, conn);
cmd.ExecuteNonQuery();
}
conn.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货