public string EventLog() { EVENT_LOGTableAdapter adptEvent = new EVENT_LOGTableAdapter(); DataTable dt = new DataTable(); using (adptEvent) { dt = adptEvent.GetData(); } string xml = ""; using (StringWriter sw = new StringWriter()) { dt.WriteXml(sw); xml = sw.ToString(); } return(xml); }
public ActionResult GetDownloads() { EVENT_LOGTableAdapter ta = new EVENT_LOGTableAdapter(); DataTable dt = new DataTable(); DataSet ds = new DataSet(); String[,] data = new String[3, 3]; String x = ""; String jsonString = "[ "; try { //ds.Tables.Add(dt); dt = ta.GetData(); for (int i = 0; i < 200; i++) { x = Convert.ToDateTime(dt.Rows[i]["Timestamp"]).ToString(); jsonString = String.Concat(jsonString, "{ ", '"', "Timestamp", '"', ": ", '"'); jsonString = String.Concat(jsonString, (dt.Rows[i]["Timestamp"] == null) ? "" : x, '"', ", "); x = dt.Rows[i]["Client_IP"].ToString(); jsonString = String.Concat(jsonString, '"', "Client_IP", '"', ": ", '"'); jsonString = String.Concat(jsonString, (dt.Rows[i]["Client_IP"] == null) ? "" : x, '"', ", "); x = dt.Rows[i]["Event"].ToString(); jsonString = String.Concat(jsonString, '"', "Event", '"', ": ", '"'); jsonString = String.Concat(jsonString, (dt.Rows[i]["Event"] == null) ? "" : x, '"', " }, "); } jsonString = jsonString.Substring(0, jsonString.Length - 2); jsonString = String.Concat(jsonString, " ]"); return(Json(jsonString)); } catch (Exception ex) { return(Json(ex.Message)); } }