/// <summary> /// Execute a stored procedure or a Sql command that does not return query result. /// </summary> /// <param name="connStr"></param> /// <param name="commandText"></param> /// <param name="isStoredProcedure"></param> /// <param name="sqlParams"></param> /// <returns></returns> public static int ExecNonQuery(string connStr, string commandText, bool isStoredProcedure, params SqlParameter[] sqlParams) { ExecCommandReturn ret = ExecCommand0(connStr, commandText, isStoredProcedure, false, sqlParams); return(ret.RowAffected); }
/// <summary> /// Execute a stored procedure or Sql commadn that return query result. /// </summary> /// <param name="connStr"></param> /// <param name="commandText"></param> /// <param name="isStoredProcedure"></param> /// <param name="sqlParams"></param> /// <returns></returns> public static DataTable ExecQuery(string connStr, string commandText, bool isStoredProcedure, params SqlParameter[] sqlParams) { ExecCommandReturn ret = ExecCommand0(connStr, commandText, isStoredProcedure, true, sqlParams); return(ret.DataTable); }