zhengfy_20161125的博客

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

声称全局唯一标识符 string jlguid = Guid.NewGuid().ToString(); 与数据库交互，遍历符合条件的数据 DBVisitor.ExecuteNonQuery(string.Format("update gy_bingrenxx set jiatingdh='" + lianXiDh + "'");   DataTable dt=null; st