用于对数据库进行操作的类库---经验的总结 (二)C#.docx

用于对数据库进行操作的类库经验的总结 (二)C#public?static?string?GetData(string?firstName,string?lastName,ref?DataSet?ds)?????????{????????????SqlConnection?conn=new?SqlConnection(connectionString)?;????????????SqlDataAdapter?da=new?SqlDataAdapter(Pro_GetUserInfo,conn);????????????para0=new?SqlParameter(@firstName,firstName);????????????para1=new?SqlParameter(@lastName,lastName);????????????da.SelectCommand.Parameters.Add(para0);????????????da.SelectCommand.Parameters.Add(para1);????????????da.SelectCommand.CommandType=CommandType.StoredProcedure;????????????try????????????{????????????????conn.Open();????????????????da.Fill(ds);????????????????conn.Close();????????????}????????????catch(Exception?ex)????????????{???????????????If(conn.State?==?ConnectionState.Open)???????????????{????????????????conn.Close();???????????????}???????????????return?ex.ToString();????????????}????????????????????}using?System;using?System.Data;using?System.Configuration;using?System.Data.SqlClient;using?System.Data.SqlTypes;using?System.Collections;public?class?CSqlHelper{????string?ConnStr?=?String.Empty;????public?CSqlHelper()????{????????//ConnStr?=?ConfigurationSettings.AppSettings[sqlConstr];????????ConnStr?=?sqlConstr;????}????public?static?string?sqlConstr?=?;????public?CSqlHelper(string?Str)????{????????try????????{????????????this.ConnStr?=?Str;????????}????????catch?(Exception?ex)????????{????????????throw?ex;????????}????}????/**////?summary????///?返回connection对象,并打开连接????///?/summary????///?returns/returns????public?SqlConnection?ReturnConn()????{????????SqlConnection?Conn?=?new?SqlConnection(this.ConnStr);????????Conn.Open();????????return?Conn;????}????public?void?Dispose(SqlConnection?Conn)????{????????if?(Conn?!=?null)????????{????????????if?(Conn.State?==?ConnectionState.Open)????????????{????????????????Conn.Close();????????????????Conn.Dispose();????????????}????????}????????GC.Collect();????}????/**////?summary????///?运行SQL语句(连接在函数中打开并且关闭)????///?是sql语句,或者不带参数的存储过程.????///?/summary????