Guest User

Untitled

a guest
Apr 24th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. var conn = new SqlConnection(ConnString);
  2. conn.Open();
  3. var data = new Dictionary<string, List<object>>();
  4. foreach (var h in hours)
  5. {
  6. data += SqlUniversal.GetAllData(query,
  7. new[] {
  8. //some parameters
  9. },
  10. conn);
  11. }
  12. //Here is the method, above is how I call it.
  13. public static Dictionary<string, List<object>> GetAllData(string command, SqlParameter[] pars, SqlConnection conn)
  14. {
  15. if (conn == null)
  16. {
  17. conn = new SqlConnection(ConnString);
  18. conn.Open();
  19. }
  20. var res = new Dictionary<string, List<object>>();
  21. using (conn)
  22. {
  23. using (var cmd = new SqlCommand(command, conn))
  24. {
  25. cmd.Parameters.AddRange(pars);
  26. using (var reader = cmd.ExecuteReader())
  27. {
  28. while (reader.Read())
  29. for (var i = 0; i < reader.VisibleFieldCount; i++)
  30. {
  31. if (reader.GetValue(i) == DBNull.Value)
  32. continue;
  33.  
  34. var name = reader.GetName(i);
  35.  
  36. if (res.ContainsKey(name))
  37. res[name].Add(reader.GetValue(i));
  38.  
  39. else
  40. res.Add(name, new List<object> {reader.GetValue(i)});
  41. }
  42.  
  43. return res;
  44. }
  45. }
  46. }
  47. }
Add Comment
Please, Sign In to add comment