SQLHelper

说明：  重写了微软提供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.)