总结数据库的连接和基本处理类.docVIP

数据库的连接和基本处理类 /** * pTitle: 数据库连接函数/p * pDescription: 数据库连接、查询、更新数据处理/p * pCopyright: Copyright (c) 2009/p * @author Ki 2009/04/11 * @Version 1.0 */ using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using Sybase.Data.AseClient; using System.Data.SqlClient; namespace WBIS.Base.Fun { /// summary /// 数据库连接及处理类，用来连接数据库及读取，更新数据库处理 /// /summary public class DB { ///summary ///设置连接字符串 ////summary //public static string strConn = Data Source=tycad;user=PPMS;password=tycad123456;; //public static string strConn = Data Source=02;Port=5000;UID=sa;Charset=big5;PWD=sybase;database=bistrn; //public static string strConn = DRIVER={Sybase ASE ODBC Driver};Charset=iso_1;UID=sa;DB=sybase;NA=02,5000;PWD=bistrn; //TWD2008 charset指定了編碼方式為big5 public static string strConn = Data Source=服務器;Port=2048;UID=用戶名;charset=big5;PWD=密碼;database=數據庫;Max Pool Size=512 ; /// summary /// 数据库处理之出错提示信讯 /// /summary public static string strDBErrMag = ; ///summary ///连接数据库对象 ////summary //public static AseConnection m_conn = new AseConnection(strConn); /// summary /// 创建一个命令 /// /summary //public static AseCommand m_cmd = new AseCommand(); /// summary /// 创建连接对象 /// /summary /// returns/returns public static AseConnection Conn() { if (strConn != ) { try { return new AseConnection(strConn); } catch (System.Exception ex) { strDBErrMag = 连接数据库处理出错: + ex.Message.ToString(); return nu