public void RefreshTableViz(Visual visual) { DataTable table = GetTableFromParameter("statResult"); string testPerformed = ""; if (table != null) { visual.As <TablePlot>().Data.DataTableReference = table; TablePlot tablePlot = visual.As <TablePlot>(); DataColumnCollection dfColumns = visual.As <TablePlot>().Data.DataTableReference.Columns; List <DataColumn> listOfCols = new List <DataColumn>(); DataValueCursor dv = DataValueCursor.CreateFormatted(table.Columns["test"]); foreach (DataRow row in table.GetRows(dv)) { testPerformed = dv.CurrentDataValue.ValidValue.ToString(); break; } for (int i = 0; i < dfColumns.Count(); i++) { if (!(dfColumns[i].Name == "W" && testPerformed == "t test") && !(dfColumns[i].Name == "t" && testPerformed == "Mann-Withney test") && !(dfColumns[i].Name == "degree_of_freedom" && testPerformed == "Mann-Withney test")) { listOfCols.Add(dfColumns[i]); } } visual.As <TablePlot>().TableColumns.Clear(); visual.As <TablePlot>().TableColumns.AddRange(listOfCols); } }
public LmiDataRowReader(LmiHandler lmiHandler) { this.lmiHandler = lmiHandler; initQuery(); resultProperties = new ResultProperties(); resultProperties.SetProperty("Host", lmiHandler.Host); resultProperties.SetProperty("UserName", lmiHandler.UserName); resultProperties.SetProperty("Query", lmiHandler.Query); if (lmiHandler.QueryId != null) { resultProperties.SetProperty("QueryID", lmiHandler.QueryId); } if (lmiHandler.IsCorrelation) { resultProperties.SetProperty("Correlation", "true"); } else { resultProperties.SetProperty("Correlation", "false"); } columns = new DataRowReaderColumn[queryDesc.columns.Length]; cursors = new DataValueCursor[queryDesc.columns.Length]; int i = 0; foreach (ColumnDesc column in queryDesc.columns) { switch (column.type) { case "TIMESTAMP": cursors[i] = DataValueCursor.CreateMutableCursor(DataType.DateTime); columns[i] = new DataRowReaderColumn(column.name, DataType.DateTime, cursors[i]); break; case "INT": cursors[i] = DataValueCursor.CreateMutableCursor(DataType.Integer); columns[i] = new DataRowReaderColumn(column.name, DataType.Integer, cursors[i]); break; case "LONG": cursors[i] = DataValueCursor.CreateMutableCursor(DataType.LongInteger); columns[i] = new DataRowReaderColumn(column.name, DataType.LongInteger, cursors[i]); break; case "DOUBLE": cursors[i] = DataValueCursor.CreateMutableCursor(DataType.Real); columns[i] = new DataRowReaderColumn(column.name, DataType.Real, cursors[i]); break; case "BOOLEAN": cursors[i] = DataValueCursor.CreateMutableCursor(DataType.Boolean); columns[i] = new DataRowReaderColumn(column.name, DataType.Boolean, cursors[i]); break; //case "INET_ADDR": default: cursors[i] = (MutableValueCursor <string>)DataValueCursor.CreateMutableCursor(DataType.String); columns[i] = new DataRowReaderColumn(column.name, DataType.String, cursors[i]); break; } i++; } }