文件名称:SQLHelper
- 所属分类:
- 数据库系统
- 资源属性:
- [Windows] [Visual.Net] [Basic/ASP] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 6kb
- 下载次数:
- 0次
- 提 供 者:
- 沈**
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
重写了微软提供SQLHelper(共用的数据库调用接口) 1把SqlHelper的connectionString做成一个全局量,统一设置数据库连接字符串 2增加了返回特定表名的DataSet的各接口。 可在项目的config文件设置数据库连接字符串 private static string connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"] <!-- application specific settings --> <appSettings> <add key="ConnectionString" value="packet size=4096 user id=sa data source=localhost persist security info=True initial catalog=NorthWind password= "/> </appSettings> 当然可以把数据库连接方法修改后直接用。-rewritten Microsoft SQLHelper (shared database Call Interface) a SqlHelper the connectionString caused an overall volume, uniform database connections increased by two strings to the specific name of the table in the DataSet interface. In the config files set database connection string private static string connectionString = System.Configuration.ConfigurationSettings.AppSettings [ "ConnectionString"] lt; !-- Application specific settings-- gt; Lt; AppSettingsgt; Lt; Add key = "ConnectionString" value = "packet size = 4096 user id = sa data source = localhost persist security info = = True initial catalog NorthWind password ="/gt; lt;/appSettingsgt; of course, the database can be connected directly to amend the methods used.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
SQLHelper.cs