/// <summary> /// Gets the data set. /// </summary> /// <typeparam name="T"></typeparam> /// <returns></returns> public T GetDataSet <T>() where T : DataSet, new() { T result = DataService.GetDataSet <T>(Command); OutputValues = Command.OutputValues; return(result); }
/// <summary> /// Executes an SP using the specified provider /// </summary> /// <param name="spAndParams">The SP name and each argument required - these must be in order</param> /// <param name="providerName">Specifies the specific provider to use.</param> /// <returns>System.Data.DataSet</returns> public static DataSet GetDataSet(string spAndParams, string providerName) { QueryCommand cmd = new QueryCommand("EXEC " + spAndParams, providerName); cmd.CommandType = CommandType.Text; cmd.ProviderName = providerName; return(DataService.GetDataSet(cmd)); }
/// <summary> /// Executes an SP using the specified provider /// </summary> /// <param name="spAndParams">The SP name and each argument required - these must be in order</param> /// <param name="providerName">Specifies the specific provider to use.</param> /// <returns>System.Data.DataSet</returns> public static DataSet GetDataSet(string spAndParams, string providerName) { QueryCommand cmd = new QueryCommand(String.Concat("EXEC ", spAndParams), providerName) { CommandType = CommandType.Text, ProviderName = providerName }; return(DataService.GetDataSet(cmd)); }