public DataSet SelectDataset(string StoredProcedure_, string Parameters_, string ParameterValues_)
{
DataSet DataSet_ = new DataSet();
SqlCommand Command_ = new SqlCommand();
SqlConnection Connection_ = new SqlConnection(Connection_String);
SqlDataAdapter Adapter_ = new SqlDataAdapter();
try
{
string[] _Parameters;
string[] _ParameterValues;
int i, ParameterCount;
_Parameters = Parameters_.Split('`');
_ParameterValues = ParameterValues_.Split('`');
ParameterCount = _Parameters.Length;
if (Connection_.State == ConnectionState.Closed)
{
Connection_.Open();
}
Command_.CommandType = CommandType.StoredProcedure;
Command_.CommandText = StoredProcedure_;
Command_.Connection = Connection_;
Command_.Parameters.Clear();
for (i = 0; i < ParameterCount; i++)
{
Command_.Parameters.Add(new SqlParameter(_Parameters[i], _ParameterValues[i]));
}
Adapter_.SelectCommand = Command_;
Adapter_.Fill(DataSet_);
Connection_.Close();
Adapter_.Dispose();
Command_.Dispose();
}
catch (Exception Exception_)
{
//throw new PerformanceException(Exception_.Message, Exception_.InnerException);
}
return DataSet_;
}
{
DataSet DataSet_ = new DataSet();
SqlCommand Command_ = new SqlCommand();
SqlConnection Connection_ = new SqlConnection(Connection_String);
SqlDataAdapter Adapter_ = new SqlDataAdapter();
try
{
string[] _Parameters;
string[] _ParameterValues;
int i, ParameterCount;
_Parameters = Parameters_.Split('`');
_ParameterValues = ParameterValues_.Split('`');
ParameterCount = _Parameters.Length;
if (Connection_.State == ConnectionState.Closed)
{
Connection_.Open();
}
Command_.CommandType = CommandType.StoredProcedure;
Command_.CommandText = StoredProcedure_;
Command_.Connection = Connection_;
Command_.Parameters.Clear();
for (i = 0; i < ParameterCount; i++)
{
Command_.Parameters.Add(new SqlParameter(_Parameters[i], _ParameterValues[i]));
}
Adapter_.SelectCommand = Command_;
Adapter_.Fill(DataSet_);
Connection_.Close();
Adapter_.Dispose();
Command_.Dispose();
}
catch (Exception Exception_)
{
//throw new PerformanceException(Exception_.Message, Exception_.InnerException);
}
return DataSet_;
}