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