private static object PrivateExecuteScalar(string CommandText, CommandType CommandType, SqlParameterCollection Parameters) { try { SqlConnection connection = DataAccessSql.GetConnection(); connection.Open(); SqlCommand command = DataAccessSql.GetCommand(); command.CommandText = CommandText; command.CommandType = CommandType; command.Connection = connection; if (Parameters != null) { foreach (SqlParameter parameter in (DbParameterCollection)Parameters) { command.Parameters.Add(new SqlParameter(parameter.ParameterName, parameter.SqlDbType, parameter.Size, parameter.Direction, parameter.Precision, parameter.Scale, parameter.SourceColumn, parameter.SourceVersion, parameter.SourceColumnNullMapping, parameter.Value, parameter.XmlSchemaCollectionDatabase, parameter.XmlSchemaCollectionOwningSchema, parameter.XmlSchemaCollectionName)); } } object obj = command.ExecuteScalar(); connection.Close(); return(obj); } catch (Exception ex) { throw ex; } }
private static DataSet RetrieveDataSet(string CommandText, CommandType CommandType, SqlParameterCollection Parameters) { try { DataSet dataSet = new DataSet(); SqlConnection connection = DataAccessSql.GetConnection(); connection.Open(); SqlDataAdapter dataAdapter = DataAccessSql.GetDataAdapter(CommandText, connection); SqlCommand command = DataAccessSql.GetCommand(); command.CommandText = CommandText; command.CommandType = CommandType; command.Connection = connection; dataAdapter.SelectCommand = command; if (Parameters != null) { foreach (SqlParameter parameter in (DbParameterCollection)Parameters) { dataAdapter.SelectCommand.Parameters.Add(new SqlParameter(parameter.ParameterName, parameter.SqlDbType, parameter.Size, parameter.Direction, parameter.Precision, parameter.Scale, parameter.SourceColumn, parameter.SourceVersion, parameter.SourceColumnNullMapping, parameter.Value, parameter.XmlSchemaCollectionDatabase, parameter.XmlSchemaCollectionOwningSchema, parameter.XmlSchemaCollectionName)); } } dataAdapter.Fill(dataSet); connection.Close(); return(dataSet); } catch (Exception ex) { throw ex; } }
public static SqlParameterCollection GetParametersCollection() { return(DataAccessSql.GetCommand().Parameters); }