public static QVDataTable FromJson(string json) { QVDataTable qvDataTable = null; qvDataTable = (QVDataTable)JsonConvert.DeserializeObject(json.ToString()); return(qvDataTable); }
public WSResponse GetQlikViewData(QVDataTable qvDataTable) { // WSResponse can be used to deliver some additional data back to the // client (QlikView extension), e.g. a download-link, some detailed additional information, etc. WSResponse wsResponse = new WSResponse(); try { #region Loop trough the data table if (qvDataTable != null) { // Loop through the header columns if (qvDataTable.Headers != null) { foreach (var h in qvDataTable.Headers) { Debug.Write("Header: " + "\t\t"); } Debug.Write("\n"); } // Loop trough all rows & cells if (qvDataTable.Rows != null) { foreach (var r in qvDataTable.Rows) { foreach (var c in r.Cells) { // Access the text value of the current cell Debug.Write(c.Text + "\t"); // Access the data value of the current cell Debug.Write(c.Data + "\t"); } Debug.Write("\n"); } } } #endregion wsResponse.StatusMessage = "Successfully exported " + qvDataTable.Rows.Count.ToString() + " accounts to salesforce.com ..."; string rMsg = String.Format("Upload of data has been process successfully. ({0} records)", qvDataTable.Rows.Count.ToString()); wsResponse.ReturnMessage = rMsg; } catch (Exception ex) { wsResponse.StatusMessage = "Error"; } return wsResponse; }
public WSResponse GetQlikViewData(QVDataTable qvDataTable) { // WSResponse can be used to deliver some additional data back to the // client (QlikView extension), e.g. a download-link, some detailed additional information, etc. WSResponse wsResponse = new WSResponse(); try { #region Loop trough the data table if (qvDataTable != null) { // Loop through the header columns if (qvDataTable.Headers != null) { foreach (var h in qvDataTable.Headers) { Debug.Write("Header: " + "\t\t"); } Debug.Write("\n"); } // Loop trough all rows & cells if (qvDataTable.Rows != null) { foreach (var r in qvDataTable.Rows) { foreach (var c in r.Cells) { // Access the text value of the current cell Debug.Write(c.Text + "\t"); // Access the data value of the current cell Debug.Write(c.Data + "\t"); } Debug.Write("\n"); } } } #endregion wsResponse.StatusMessage = "Successfully exported " + qvDataTable.Rows.Count.ToString() + " accounts to salesforce.com ..."; string rMsg = String.Format("Upload of data has been process successfully. ({0} records)", qvDataTable.Rows.Count.ToString()); wsResponse.ReturnMessage = rMsg; } catch (Exception ex) { wsResponse.StatusMessage = "Error"; } return(wsResponse); }