我从数据库中拿到值解析xml HttpPost 过来 以下这个方法进行接收
现在xmlData 里边的值是string 类型的 xmllogistics_interface=<RSS version="2.0"><BatchQueryResponse><clientID>TW</clientID><logisticProviderID>YTO</logisticProviderID><txLogisticID>LP2005082300225709000</txLogisticID><tradeNo>2005082300225709</tradeNo><mailNo>0571115987</mailNo><flag>1</flag><name>张三</name><address>华星科技大厦9层</address><postCode>266000</postCode><phone>231234134</phone><mobile>13575745195</mobile><prov>陕西省</prov><city>西安</city><sendStartTime>2011-05-13 13:16:00</sendStartTime><sendEndTime>2011-05-13 13:14:00</sendEndTime><itemName>Nokia N73</itemName><number>2</number><special>0</special><re>YTO</re><insuranceValue>0.0</insuranceValue><packageOrNot>0</packageOrNot></BatchQueryResponse></RSS>&data_digest=QG4B8aXGX753O+X8R31qng==<RSS version="2.0"><BatchQueryResponse><clientID>TW</clientID><logisticProviderID>YTO</logisticProviderID><txLogisticID>LP2005082300225709000</txLogisticID><tradeNo>2005082300225709</tradeNo><mailNo>0571115987</mailNo><flag>1</flag><name>张三</name><address>华星科技大厦9层</address><postCode>266000</postCode><phone>231234134</phone><mobile>13575745195</mobile><prov>陕西省</prov><city>西安</city><sendStartTime>2011-05-13 13:16:00</sendStartTime><sendEndTime>2011-05-13 13:14:00</sendEndTime><itemName>Nokia N73</itemName><number>2</number><special>0</special><re>YTO</re><insuranceValue>0.0</insuranceValue><packageOrNot>0</packageOrNot></BatchQueryResponse></RSS> public void ResponseData()
{
string request;
string xmlData;
//接收传递过来的数据流
using (Stream MyStream = Request.InputStream)
{
byte[] data = new byte[MyStream.Length];
MyStream.Read(data, 0, data.Length);
//从当前流读取数据
MyStream.Read(data, 0, data.Length);
request = Encoding.UTF8.GetString(data);
xmlData = HttpUtility.UrlDecode(request);
}
Response.Write(xmlData);
Response.End();
}如何将xmlData存入数据库中,望大家协助。
现在xmlData 里边的值是string 类型的 xmllogistics_interface=<RSS version="2.0"><BatchQueryResponse><clientID>TW</clientID><logisticProviderID>YTO</logisticProviderID><txLogisticID>LP2005082300225709000</txLogisticID><tradeNo>2005082300225709</tradeNo><mailNo>0571115987</mailNo><flag>1</flag><name>张三</name><address>华星科技大厦9层</address><postCode>266000</postCode><phone>231234134</phone><mobile>13575745195</mobile><prov>陕西省</prov><city>西安</city><sendStartTime>2011-05-13 13:16:00</sendStartTime><sendEndTime>2011-05-13 13:14:00</sendEndTime><itemName>Nokia N73</itemName><number>2</number><special>0</special><re>YTO</re><insuranceValue>0.0</insuranceValue><packageOrNot>0</packageOrNot></BatchQueryResponse></RSS>&data_digest=QG4B8aXGX753O+X8R31qng==<RSS version="2.0"><BatchQueryResponse><clientID>TW</clientID><logisticProviderID>YTO</logisticProviderID><txLogisticID>LP2005082300225709000</txLogisticID><tradeNo>2005082300225709</tradeNo><mailNo>0571115987</mailNo><flag>1</flag><name>张三</name><address>华星科技大厦9层</address><postCode>266000</postCode><phone>231234134</phone><mobile>13575745195</mobile><prov>陕西省</prov><city>西安</city><sendStartTime>2011-05-13 13:16:00</sendStartTime><sendEndTime>2011-05-13 13:14:00</sendEndTime><itemName>Nokia N73</itemName><number>2</number><special>0</special><re>YTO</re><insuranceValue>0.0</insuranceValue><packageOrNot>0</packageOrNot></BatchQueryResponse></RSS> public void ResponseData()
{
string request;
string xmlData;
//接收传递过来的数据流
using (Stream MyStream = Request.InputStream)
{
byte[] data = new byte[MyStream.Length];
MyStream.Read(data, 0, data.Length);
//从当前流读取数据
MyStream.Read(data, 0, data.Length);
request = Encoding.UTF8.GetString(data);
xmlData = HttpUtility.UrlDecode(request);
}
Response.Write(xmlData);
Response.End();
}如何将xmlData存入数据库中,望大家协助。
这是string 类型的 值是上边 的xml 如何将其值写入数据库中