如何把数据库查询后得到的结果集输出到XML中
IList <ClassStockWarningInfo> stockWarningList = new List <ClassStockWarningInfo>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringInventoryDistributedTransaction, 600, CommandType.StoredProcedure, SQL_SELECT_STOCKWARNING_BY_FILIALECTLIST_AND_GOODSCLASS, parms))
{
while (rdr.Read())
{
ClassStockWarningInfo stockWarningInfo = new ClassStockWarningInfo(rdr.GetGuid(0), rdr.GetString(1), rdr[2] == DBNull.Value ? "" : rdr.GetString(2), rdr.GetDouble(3), rdr.GetInt32(4), rdr.GetDouble(5), rdr[6] == DBNull.Value ? 0 : rdr.GetDouble(6));
stockWarningList.Add(stockWarningInfo);
}
}
return stockWarningList;
我想问的是,查询到的结果是不是保存在了stockWarningList中了?如果是的话,我怎么把结果输出到XML中?
我看不太懂上面的代码,能给我解释一下就最好了,谢谢!
注:查询数据库主要是调用存储过程SQL_SELECT_STOCKW
相关问答:
DataSet导出xml 批处理(循环)得怎么处理
XML文件
<A>
<B>
<C>
</C>
&nb ......
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<video>
<device deviceid="\\?\usb#vid_0c45&pid_613b#5&2d0620de& ......
string b = "";
b = System.Guid.NewGuid().ToString();//获得会话ID
//写XML
XmlDocument xml = new XmlDocumen ......