SqlHelper类的方法.docVIP

using System; using System.Data; using System.Configuration; 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 System.Data.SqlClient; using System.Collections; /// summary /// SqlHelper 的摘要说明 /// /summary public class SQLHelper { // Fields public static readonly string CONN_STRING; private static Hashtable parmCache; static SQLHelper() { //definition the Database Connection; SQLHelper.CONN_STRING = Data Source=.;Initial Catalog=two_company;Persist Security Info=True;User ID=sa;Password=sa; SQLHelper.parmCache = Hashtable.Synchronized(new Hashtable()); } public static void CacheParameters(string cacheKey, params SqlParameter[] cmdParms) { SQLHelper.parmCache[cacheKey] = cmdParms; } //clear the SqlCommand Params Set it Values is Null public static void ClearParameterValues(params SqlParameter[] cmdParms) { SqlParameter[] parameterArray1 = cmdParms; for (int num1 = 0; num1 parameterArray1.Length; num1++) { SqlParameter parameter1 = parameterArray1[num1]; parameter1.Value = DBNull.Value; } } public static SqlParameter CreateReturnParameter(string parameterName) { return new SqlParameter(parameterName, SqlDbType.Int, 4, ParameterDirection.ReturnValue, false, 0, 0, string.Empty, DataRowVersion.Default, null); } public static DataRow ExecuteDataRow(string cmdText) { DataSet set1 = SQLHelper.ExecuteDataset(cmdText); if ((set1.Tables.Count 0) (set1.Tables[0].Rows.Count 0)) { //why Return First Row return set1.Tables[0].Rows[0]; } return null; } publi