随笔分类 -  数据库操作

摘要：DECLARE @i INT SET @i = 1 WHILE (@i < 5) BEGIN INSERT INTO TableInfo ( TableInfo.TableTypeId, TableInfo.TableCode, TableInfo.TableName, TableInfo.InstId, ... 阅读全文

摘要：//在使用参数形式时 需要这样连接字符串return String.Format("and {0} like '%'+@{0}+'%' ", par);SELECT * FROM PersonsWHERE City LIKE '%lon%'SELECT * FROM PersonsWHERE ... 阅读全文

摘要：1 /// 2 /// DAL基类 3 /// 4 /// 5 public abstract class BaseDAL where T : class, new() 6 { 7 /// 8 /... 阅读全文

摘要：1 /// 2 /// 分页字符串帮助类 3 /// 4 public static class PageStrHelper 5 { 6 /// 7 /// 获取分页字符串 8 /// ... 阅读全文

摘要：public class SQLHelperNew { //连接字符串 private static readonly string ConnStr = System.Configuration.ConfigurationManager.ConnectionSt... 阅读全文