---------------------- ASP.Net+Android+IO开发S、.Net培训、期待与您交流! ---------------------- using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Collections; namespace newsConten.DAL { public class DBhelper { public static int ExecuteNonQuery(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms) { SqlCommand cmd = new SqlCommand(); using (SqlConnection conn = new SqlConnection(connString)) { PerPrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); int val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return val; } } public static object ExecuteScalar(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms) { SqlCommand cmd = new SqlCommand(); using (SqlConnection conn = new SqlConnection(connString)) { PerPrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); object val = cmd.ExecuteScalar(); cmd.Parameters.Clear(); return val; } } public static SqlDataReader ExecuteReader(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms) { SqlCommand cmd = new SqlCommand(); SqlConnection conn = new SqlConnection(connString); try { PerPrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); SqlDataReader rdr = cmd.ExecuteReader(); return rdr; } catch { conn.Close(); throw; } } public static DataSet Dataset(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParmes) { SqlCommand cmd = new SqlCommand(); SqlConnection con = new SqlConnection(connString); PerPrepareCommand(cmd, con, null, cmdType, cmdText, cmdParmes); using (SqlDataAdapter ad = new SqlDataAdapter(cmd)) { DataSet ds = new DataSet(); ad.Fill(ds); return ds; } } public static DataTable DATATable(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParmes) { SqlCommand cmd = new SqlCommand(); SqlConnection con = new SqlConnection(connString); PerPrepareCommand(cmd, con, null, cmdType, cmdText, cmdParmes); using (SqlDataAdapter ad = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); ad.Fill(dt); return dt; } } public static void PerPrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParms) { if (conn.State != ConnectionState.Open) conn.Open(); cmd.Connection = conn; cmd.CommandText = cmdText; if (trans != null) cmd.Transaction = trans; cmd.CommandType = cmdType; if (cmdParms != null) { foreach (SqlParameter parm in cmdParms) cmd.Parameters.Add(parm); } } } } ---------------------- ASP.Net+Android+IO开发S、.Net培训、期待与您交流! ---------------------- </textarea >