摘要：
追加：row_number, rank, dese_rank, ntile1. row_number: 为查询出来的每一行记录生成一个序号。SELECT row_number() OVER(ORDER BY field) AS row_nFROM tablename;分页查询：with t_towtableas (select row_number over(order by field1) as row_number from tb)select * from t_rowtable where row_number > 1 and row_number > 4 order by 阅读全文
摘要：
将从WebService得到数据并将xml转化成Dataset显示出来XmlDataDocument xd = new XmlDataDocument();DataSet ds = new DataSet();StringBuilder xmlStr = new StringBuilder(ServiceA.GetInfo(StrSearch).OuterXml);xd.loadXml(Xml.Str.toString());ds.readXml(new XmlNodeReader(xd));DataGrid1.DataSource = ds.Tables['list'].De 阅读全文