程序方法

3.xml报文转意字符串'<'、'>'。

string str=string_object.tostring().Replace("<", "&lt;").Replace(">", "&gt;");

2.取查询结果的指定条数

select * from ( select  t.*, rownum RN from v_xxx  t  ORDER BY id) where RN between 3 and 15

1.根据条件去淡单个字段

string ICDM10 = DBVisitor.ExecuteScalar(string.Format("select ICDM10 from gy_jibing where jibingid='{0}' ", arr[0])).ToString();