private DataSet TestQueryFor(RxProcs ProcToRun, List <SqlParameter> Parms, String CnxString)
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(CnxString))
{
using (SqlCommand comm = new SqlCommand(AvailableRxProcs[ProcToRun], conn))
{
comm.CommandType = CommandType.StoredProcedure;
Parms.ForEach(delegate(SqlParameter parm)
{
comm.Parameters.Add(parm);
});
using (SqlDataAdapter da = new SqlDataAdapter(comm))
{
try
{
da.Fill(ds);
}
catch (Exception)
{ }
finally
{ }
}
comm.Parameters.Clear();
}
}
return(ds);
}
private DataSet TestQueryFor(RxProcs ProcToRun, String CnxString)
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(CnxString))
{
using (SqlCommand comm = new SqlCommand(AvailableRxProcs[ProcToRun], conn))
{
comm.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(comm))
{
try
{
da.Fill(ds);
}
catch (Exception)
{ }
finally
{ }
}
}
}
return(ds);
}
private DataSet TestQueryFor(RxProcs ProcToRun, List<SqlParameter> Parms, String CnxString)
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(CnxString))
{
using (SqlCommand comm = new SqlCommand(AvailableRxProcs[ProcToRun], conn))
{
comm.CommandType = CommandType.StoredProcedure;
Parms.ForEach(delegate(SqlParameter parm)
{
comm.Parameters.Add(parm);
});
using (SqlDataAdapter da = new SqlDataAdapter(comm))
{
try
{
da.Fill(ds);
}
catch (Exception)
{ }
finally
{ }
}
comm.Parameters.Clear();
}
}
return ds;
}
private DataSet TestQueryFor(RxProcs ProcToRun, String CnxString)
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(CnxString))
{
using (SqlCommand comm = new SqlCommand(AvailableRxProcs[ProcToRun], conn))
{
comm.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(comm))
{
try
{
da.Fill(ds);
}
catch (Exception)
{ }
finally
{ }
}
}
}
return ds;
}
