/// <summary> /// 执行SQL语句并返回数据表 /// </summary> /// <param name="Sqlstr">SQL语句</param> /// <returns></returns> public static DataTable ExecuteDt(String Sqlstr) { String ConnStr = SQLDbHelper.GetSqlConnection(); using (SqlConnection conn = new SqlConnection(ConnStr)) { SqlDataAdapter da = new SqlDataAdapter(Sqlstr, conn); DataTable dt = new DataTable(); conn.Open(); da.Fill(dt); conn.Close(); return(dt); } }
/// <summary> /// 根据SQL语句,取得SqlDataReader结果 /// </summary> /// <param name="Sqlstr">SQL语句</param> /// <returns>SqlDataReader</returns> public static SqlDataReader ExecuteDr(string Sqlstr) { String ConnStr = SQLDbHelper.GetSqlConnection(); using (SqlConnection conn = new SqlConnection(ConnStr)) { SqlCommand cmd = new SqlCommand(Sqlstr, conn); //cmd.CommandText = Sqlstr; //cmd.Connection = conn; conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); conn.Close(); return(dataReader); } }
/// <summary> /// 执行SQL语句并返回数据集 /// </summary> /// <param name="Sqlstr">SQL语句</param> /// <returns>DataSet</returns> public static DataSet ExecuteDs(String Sqlstr) { String ConnStr = SQLDbHelper.GetSqlConnection(); using (SqlConnection conn = new SqlConnection(ConnStr)) { DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(Sqlstr, conn); //cmd.CommandText = Sqlstr; //cmd.Connection = conn; da.SelectCommand = cmd; conn.Open(); da.Fill(ds); conn.Close(); return(ds); } }
/// <summary> /// 执行SQL语句并返回数据表 /// </summary> /// <param name="Sqlstr">SQL语句</param> /// <param name="param">参数对象列表</param> /// <returns></returns> public static DataTable ExecuteDt(String Sqlstr, SqlParameter[] param) { String ConnStr = SQLDbHelper.GetSqlConnection(); using (SqlConnection conn = new SqlConnection(ConnStr)) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(Sqlstr, conn); //cmd.CommandText = Sqlstr; //cmd.Connection = conn; cmd.Parameters.AddRange(param); da.SelectCommand = cmd; conn.Open(); da.Fill(dt); conn.Close(); return(dt); } }
/// <summary> /// 批量执行SQL语句 /// </summary> /// <param name="Sqlstr">SQL语句数组</param> /// <param name="param">SQL参数对象数组</param> /// <returns></returns> public static Boolean ExecuteSqls(String[] Sqlstr, List <SqlParameter[]> param) { String ConnStr = SQLDbHelper.GetSqlConnection(); using (SqlConnection conn = new SqlConnection(ConnStr)) { SqlCommand cmd = new SqlCommand(); SqlTransaction tran = null; cmd.Transaction = tran; try { conn.Open(); tran = conn.BeginTransaction(); cmd.Connection = conn; cmd.Transaction = tran; Int32 count = Sqlstr.Length; for (Int32 i = 0; i < count; i++) { cmd.CommandText = Sqlstr[i]; cmd.Parameters.AddRange(param[i]); cmd.ExecuteNonQuery(); } tran.Commit(); return(true); } catch { tran.Rollback(); return(false); } finally { cmd.Dispose(); conn.Close(); } } }
/// <summary> /// 执行SQL语句 /// </summary> /// <param name="Sqlstr">SQL语句</param> /// <param name="param">参数对象数组</param> /// <returns></returns> public static Boolean ExecuteSql(String Sqlstr, SqlParameter[] param) { String ConnStr = SQLDbHelper.GetSqlConnection(); using (SqlConnection conn = new SqlConnection(ConnStr)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = Sqlstr; cmd.Parameters.AddRange(param); conn.Open(); int AffectRows = cmd.ExecuteNonQuery(); //对于 UPDATE、INSERT 和 DELETE 语句,返回值为该命令所影响的行数。 conn.Close(); //对于所有其他类型的语句,返回值为 -1。如果发生回滚,返回值也为 -1。 if (AffectRows > 0 || AffectRows == -1) { return(true); } else { return(false); } } }