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; }