public static XmlReader ExecuteXmlReader(SqlTransaction transaction, string spName, params object[] parameterValues) { if (parameterValues != null && parameterValues.Length > 0) { SqlParameter[] spParameterSet = SqlHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName); SqlHelper.AssignParameterValues(spParameterSet, parameterValues); return(SqlHelper.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName, spParameterSet)); } return(SqlHelper.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName)); }
public static object ExecuteScalar(string connectionString, string spName, params object[] parameterValues) { if (parameterValues != null && parameterValues.Length > 0) { SqlParameter[] spParameterSet = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName); SqlHelper.AssignParameterValues(spParameterSet, parameterValues); return(SqlHelper.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName, spParameterSet)); } return(SqlHelper.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName)); }
public static int ExecuteNonQuery(string connectionString, string spName, Hashtable parameterValues) { if (parameterValues != null && parameterValues.Count > 0) { SqlParameter[] spParameterSet = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName); SqlHelper.AssignParameterValues(spParameterSet, parameterValues); return(SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, spParameterSet)); } return(SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName)); }
public static void BeginExecuteNonQuery(string connectionString, string spName, params object[] parameterValues) { if (parameterValues != null && parameterValues.Length > 0) { SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName); SqlHelper.AssignParameterValues(commandParameters, parameterValues); SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters); } else { SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName); } }
public static XmlReader ExecuteXmlReader(SqlConnection connection, string spName, params object[] parameterValues) { XmlReader result; if (parameterValues != null && parameterValues.Length > 0) { SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connection.ConnectionString, spName); SqlHelper.AssignParameterValues(commandParameters, parameterValues); result = SqlHelper.ExecuteXmlReader(connection, CommandType.StoredProcedure, spName, commandParameters); } else { result = SqlHelper.ExecuteXmlReader(connection, CommandType.StoredProcedure, spName); } return(result); }
public static DataSet ExecuteDataset(SqlTransaction transaction, string spName, params object[] parameterValues) { DataSet result; if (parameterValues != null && parameterValues.Length > 0) { SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName); SqlHelper.AssignParameterValues(commandParameters, parameterValues); result = SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, spName, commandParameters); } else { result = SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, spName); } return(result); }
public static int ExecuteNonQuery(string connectionString, string spName, Hashtable parameterValues) { int result; if (parameterValues != null && parameterValues.Count > 0) { SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName); SqlHelper.AssignParameterValues(commandParameters, parameterValues); result = SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters); } else { result = SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName); } return(result); }