Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "detailInputs": [
- {
- "name": "SOGrid",
- "repeatingInputs": [
- {
- "inputs": [
- {
- "name": "ItemNumber",
- "value": "XYZ"
- },
- {
- "name": "Quantity",
- "value": "1"
- }
- ]
- },
- {
- "inputs": [
- {
- "name": "ItemNumber",
- "value": "ABC"
- },
- {
- "name": "Quantity",
- "value": "1"
- }
- ]
- }
- using (var conn = new OleDbConnection(connectionString))
- {
- sheetName = "Detail";
- conn.Open();
- var cmd = conn.CreateCommand();
- cmd.CommandText = $"SELECT * FROM [{sheetName}$]";
- using (var rdr = cmd.ExecuteReader())
- {
- var query = rdr.Cast<DbDataRecord>().Select(row => new {
- name = row[0],
- value = row[1],
- //description = row[2]
- });
- var json = JsonConvert.SerializeObject(query);
- jsonArrayString = jsonArrayString + ","detailInputs":[{"name":"SOGrid","repeatingInputs":[{"inputs": " + json + "}]}]}";
- using (var conn = new OleDbConnection(connectionString))
- {
- sheetName = "Detail";
- conn.Open();
- int counter = 0;
- var cmd = conn.CreateCommand();
- cmd.CommandText = $"SELECT * FROM [{sheetName}$]";
- var values = new List<Dictionary<string, object>>();
- var ListValues = new List<string>();
- using (var rdr = cmd.ExecuteReader())
- {
- while (rdr.Read())
- {
- var fieldValues = new Dictionary<string, object>();
- var fieldValuesList = new List<string>();
- for (int i = 0; i < rdr.FieldCount; i++)
- {
- fieldValues.Add(rdr.GetName(i), rdr[i]);
- fieldValuesList.Add(rdr.GetName(i));
- }
- // add the dictionary on the values list
- values.Add(fieldValues);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement