Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.41 KB | None | 0 0
  1. "detailInputs": [
  2. {
  3. "name": "SOGrid",
  4. "repeatingInputs": [
  5. {
  6. "inputs": [
  7. {
  8. "name": "ItemNumber",
  9. "value": "XYZ"
  10. },
  11. {
  12. "name": "Quantity",
  13. "value": "1"
  14. }
  15. ]
  16. },
  17. {
  18. "inputs": [
  19. {
  20. "name": "ItemNumber",
  21. "value": "ABC"
  22. },
  23. {
  24. "name": "Quantity",
  25. "value": "1"
  26. }
  27. ]
  28. }
  29.  
  30. using (var conn = new OleDbConnection(connectionString))
  31. {
  32. sheetName = "Detail";
  33. conn.Open();
  34. var cmd = conn.CreateCommand();
  35. cmd.CommandText = $"SELECT * FROM [{sheetName}$]";
  36.  
  37. using (var rdr = cmd.ExecuteReader())
  38.  
  39. {
  40. var query = rdr.Cast<DbDataRecord>().Select(row => new {
  41. name = row[0],
  42. value = row[1],
  43. //description = row[2]
  44. });
  45.  
  46. var json = JsonConvert.SerializeObject(query);
  47. jsonArrayString = jsonArrayString + ","detailInputs":[{"name":"SOGrid","repeatingInputs":[{"inputs": " + json + "}]}]}";
  48.  
  49. using (var conn = new OleDbConnection(connectionString))
  50. {
  51. sheetName = "Detail";
  52. conn.Open();
  53. int counter = 0;
  54. var cmd = conn.CreateCommand();
  55. cmd.CommandText = $"SELECT * FROM [{sheetName}$]";
  56. var values = new List<Dictionary<string, object>>();
  57. var ListValues = new List<string>();
  58.  
  59. using (var rdr = cmd.ExecuteReader())
  60.  
  61. {
  62.  
  63. while (rdr.Read())
  64. {
  65.  
  66. var fieldValues = new Dictionary<string, object>();
  67. var fieldValuesList = new List<string>();
  68.  
  69. for (int i = 0; i < rdr.FieldCount; i++)
  70. {
  71. fieldValues.Add(rdr.GetName(i), rdr[i]);
  72. fieldValuesList.Add(rdr.GetName(i));
  73. }
  74.  
  75. // add the dictionary on the values list
  76. values.Add(fieldValues);
  77.  
  78. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement