private void DataGridViewObject_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index == this.sizeColumn.Index) { VDI vDI = ((VDIRow)this.dataGridViewVDIs.Rows[e.RowIndex1]).VDI; VDI vdi2 = ((VDIRow)this.dataGridViewVDIs.Rows[e.RowIndex2]).VDI; long num = vDI.virtual_size - vdi2.virtual_size; e.SortResult = (num > 0L) ? 1 : ((num < 0L) ? -1 : 0); e.Handled = true; } }
private void dataGridView1_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.RowIndex1 == 0) { e.SortResult = 0; e.Handled = true; } else { } }
private void dataGridViewWeapons_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index == 0) { e.SortDataGridViewColumnDate(); } else if (Array.IndexOf(new int[] { 2, 4, 9, 10, 11, 12 }, e.Column.Index) >= 0) { e.SortDataGridViewColumnNumeric(); } }
// Override of visits column sorting, to properly ordering as integers and not as strings - do not work as expected, yet... private void dataGridViewStarList_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index == 0) { e.SortDataGridViewColumnDate(); } else if (e.Column.Index == 2 || e.Column.Index == 4) { e.SortDataGridViewColumnNumeric(); } }
private void ContentsGrid_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.ValueType == typeof(DateTime)) { DateTime date1 = Convert.ToDateTime(e.CellValue1); DateTime date2 = Convert.ToDateTime(e.CellValue2); e.SortResult = System.DateTime.Compare(date1, date2); e.Handled = true; } }
private void dataGridViewCurrent_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index == 1 || e.Column.Index == 2) { e.SortDataGridViewColumnDate(); } else if (e.Column.Index == 7) { e.SortDataGridViewColumnNumeric(); } }
private void dataGridViewItems_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { var row1 = dataGridViewItems.Rows[e.RowIndex1] as CapabilityRow; var row2 = dataGridViewItems.Rows[e.RowIndex2] as CapabilityRow; if (row1 != null && row2 != null && e.Column.Index == columnImage.Index) { e.SortResult = row1.Capability.PII.CompareTo(row2.Capability.PII); e.Handled = true; } }
private void dataGridViewLedger_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index == 0) { e.SortDataGridViewColumnDate(); } else if (e.Column.Index >= 3) { e.SortDataGridViewColumnNumeric(); } }
private void dataGridViewPatches_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { Alert alert1 = ((PatchGridViewRow)dataGridViewPatches.Rows[e.RowIndex1]).UpdateAlert; Alert alert2 = ((PatchGridViewRow)dataGridViewPatches.Rows[e.RowIndex2]).UpdateAlert; if (e.Column.Index == ColumnDate.Index) { e.SortResult = DateTime.Compare(alert1.Timestamp, alert2.Timestamp); e.Handled = true; } }
/// <summary> /// When sorting the Property Name column use the value of /// the PropertyNameSortString column to sort rather than /// Property Name. /// </summary> /// <param name="sender">The parameter is not used.</param> /// <param name="e">The parameter is not used.</param> private void PropertiesGrid_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Name == "PropertyName") { e.SortResult = String.Compare( this.PropertiesGrid.Rows[e.RowIndex1].Cells["PropertyName"].Value.ToString(), this.PropertiesGrid.Rows[e.RowIndex2].Cells["PropertyName"].Value.ToString()); } e.Handled = true; }
private void dataGridView_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column == ColDate) { e.SortDataGridViewColumnDate(); } else if (e.Column == ColValue) { e.SortDataGridViewColumnNumeric(); } }
private void dataGridView_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index == 0) { e.SortDataGridViewColumnDate(); } else if (e.Column.Index == 4) { e.SortDataGridViewColumnTagsAsStringsLists(dataGridView); } }
void grid_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { e.SortResult = String.Compare(e.CellValue1.ToString(), e.CellValue2.ToString()); if (e.SortResult == 0 && e.Column.Name != column.Name) { e.SortResult = String.Compare( grid[column.Index, e.RowIndex1].Value.ToString(), grid[column.Index, e.RowIndex2].Value.ToString()); } e.Handled = true; }
private void dataGridSeriesList_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { bool targetIntSortable = dgv.Columns[ColNames.Season].Index == e.Column.Index || dgv.Columns[ColNames.Episode].Index == e.Column.Index; if (targetIntSortable) { e.SortResult = int.Parse(e.CellValue1.ToString()).CompareTo(int.Parse(e.CellValue2.ToString())); e.Handled = true; } }
private void dataGridView1_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index != 1) { e.Handled = false; return; } e.SortResult = (long)(dataGridView1.Rows[e.RowIndex1].Cells[1].Tag) > (long)(dataGridView1.Rows[e.RowIndex2].Cells[1].Tag) ? 1 : -1; e.Handled = true; }
void E_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { // // SortCompare event handler // // // Sort table by selected column then by forth then by second // then by third then by first column in the selected Sort Direction // // Compare values inside cells in selected column e.SortResult = System.String.CompareOrdinal( e.CellValue1.ToString(), e.CellValue2.ToString()); // If values are equal // Compare values inside cells in forth column if (e.SortResult == 0) { e.SortResult = System.String.CompareOrdinal( ELEMENT_LIST.Rows[e.RowIndex1].Cells[3].Value.ToString(), ELEMENT_LIST.Rows[e.RowIndex2].Cells[3].Value.ToString()); // If values are equal // Compare values inside cells in second column if (e.SortResult == 0) { e.SortResult = System.String.CompareOrdinal( ELEMENT_LIST.Rows[e.RowIndex1].Cells[1].Value.ToString(), ELEMENT_LIST.Rows[e.RowIndex2].Cells[1].Value.ToString()); // If values are equal // Compare values inside cells in third column if (e.SortResult == 0) { e.SortResult = System.String.CompareOrdinal( ELEMENT_LIST.Rows[e.RowIndex1].Cells[2].Value.ToString(), ELEMENT_LIST.Rows[e.RowIndex2].Cells[2].Value.ToString()); // If values are equal // Compare values inside cells in first column // in oposite sort direction than selected if (e.SortResult == 0) { e.SortResult = System.String.CompareOrdinal( ELEMENT_LIST.Rows[e.RowIndex2].Cells[0].Value.ToString(), ELEMENT_LIST.Rows[e.RowIndex1].Cells[0].Value.ToString()); } } } } e.Handled = true; }
private void dataGridSymbols_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index > 0) { e.Handled = true; int val1; int val2; Int32.TryParse(e.CellValue1.ToString(), out val1); Int32.TryParse(e.CellValue2.ToString(), out val2); e.SortResult = val1 - val2; } }
private void CustomSortCompare(object sender, DataGridViewSortCompareEventArgs e) { try { int columnIndex = e.Column.Index; sortedByTime = false; // For signal strength, frequency and noise... if (columnIndex == (int)Index.Signal || columnIndex == (int)Index.Freq || columnIndex == (int)Index.Noise) { decimal a = decimal.Parse(e.CellValue1.ToString()); decimal b = decimal.Parse(e.CellValue2.ToString()); e.SortResult = a.CompareTo(b); } // For event numbers and durations... else if (columnIndex == (int)Index.Event || columnIndex == (int)Index.Duration) { double a = double.Parse(e.CellValue1.ToString()); double b = double.Parse(e.CellValue2.ToString()); e.SortResult = a.CompareTo(b); } // For timestamps... else if (columnIndex == (int)Index.Time) { DateTime a = DateTime.ParseExact(e.CellValue1.ToString(), "HH:mm:ss", CultureInfo.CurrentCulture); DateTime b = DateTime.ParseExact(e.CellValue2.ToString(), "HH:mm:ss", CultureInfo.CurrentCulture); e.SortResult = a.CompareTo(b); if (e.SortResult > 0) { sortedByTime = true; } } else if (columnIndex == (int)Index.Image) { string a = (e.CellValue1 == null ? "" : e.CellValue1.ToString()); string b = (e.CellValue2 == null ? "" : e.CellValue2.ToString()); e.SortResult = a.CompareTo(b); } } catch { } e.Handled = true; }
private void DataGridView1_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.DefaultCellStyle.Format == "d") { DateTime f1; DateTime f2; DateTime.TryParse(e.CellValue1.ToString(), out f1); DateTime.TryParse(e.CellValue2.ToString(), out f2); e.SortResult = System.DateTime.Compare(f1, f2); e.Handled = true; } }
/// <summary> /// Handles the automatic sorting of the AlertsGridView for the non-string columns /// </summary> private void dataGridViewUpdates_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { Alert alert1 = (Alert)dataGridViewUpdates.Rows[e.RowIndex1].Tag; Alert alert2 = (Alert)dataGridViewUpdates.Rows[e.RowIndex2].Tag; if (e.Column.Index == ColumnDate.Index) { int sortResult = DateTime.Compare(alert1.Timestamp, alert2.Timestamp); e.SortResult = (dataGridViewUpdates.SortOrder == SortOrder.Descending) ? sortResult *= -1 : sortResult; e.Handled = true; } }
private void dgvIssues_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column == colPriority) { var issueA = ((org.mantisbt.www.IssueData)dgvIssues.Rows[e.RowIndex1].Tag); var issueB = ((org.mantisbt.www.IssueData)dgvIssues.Rows[e.RowIndex2].Tag); e.SortResult = int.Parse(issueA.priority.id).CompareTo(int.Parse(issueB.priority.id)); e.Handled = true; } }
private void dgPorts_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Equals(cDesc)) { int res = AlphanumComparator(e.CellValue1 as string, e.CellValue2 as string); if (res == 0) { e.Handled = true; e.SortResult = res; } } }
private void dgvFactors_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Name == "clnTotalPrice") { e.SortResult = System.Decimal.Compare( Convert.ToDecimal(e.CellValue1.ToString()), Convert.ToDecimal(e.CellValue2.ToString()) ); e.Handled = true; } }
private void RecordView_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { object tag1 = RecordView[e.Column.Index, e.RowIndex1].Tag; object tag2 = RecordView[e.Column.Index, e.RowIndex2].Tag; if (tag1 != null && (tag1 is double || tag1 is int) && e.CellValue1 is int) { double c1 = 0, c2 = 0; if (tag1 is double) { c1 = (double)tag1; c2 = (double)tag2; } else if (tag1 is int) { c1 = (double)(int)e.CellValue1 / Math.Max((int)tag1, 1); c2 = (double)(int)e.CellValue2 / Math.Max((int)tag2, 1); } if (Math.Abs(c1 - c2) < 0.000001) { e.SortResult = (int)e.CellValue1 - (int)e.CellValue2; } else if (c1 < c2) { e.SortResult = -1; } else { e.SortResult = 1; } e.Handled = true; } else if (tag1 is string) { e.SortResult = ((IComparable)tag1).CompareTo(tag2); e.Handled = true; } if (!e.Handled) { e.SortResult = ((IComparable)e.CellValue1 ?? 0).CompareTo(e.CellValue2 ?? 0); e.Handled = true; } if (e.SortResult == 0) { e.SortResult = (int)(RecordView.Rows[e.RowIndex1].Tag ?? 0) - (int)(RecordView.Rows[e.RowIndex2].Tag ?? 0); } }
private void dgvDescriptions_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.CellValue1.ToString().Equals(OtherCountryDescription)) { e.SortResult = 1; e.Handled = true; } else if (e.CellValue2.ToString().Equals(OtherCountryDescription)) { e.SortResult = -1; e.Handled = true; } }
private void Grid1_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { //修改服务时间的比较方式为日期比较 if (e.Column.Name == "服务时间") { e.SortResult = (Convert.ToDateTime(e.CellValue1) > Convert.ToDateTime(e.CellValue2)) ? 1 : (Convert.ToDateTime(e.CellValue1) < Convert.ToDateTime(e.CellValue2)) ? -1 : 0; } if (e.Column.Name == "编号") { e.SortResult = (Convert.ToInt32(e.CellValue1) > Convert.ToInt32(e.CellValue2)) ? 1 : (Convert.ToInt32(e.CellValue1) < Convert.ToInt32(e.CellValue2)) ? -1 : 0; } e.Handled = true; }
private void dgvAllDevices_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column == this.imgstatus) { int num = this.CompareImg(e.CellValue1, e.CellValue2); if (num == 0) { num = string.Compare(this.dgvAllDevices.Rows[e.RowIndex1].Cells["dgvtbDeviceNm"].Value.ToString(), this.dgvAllDevices.Rows[e.RowIndex2].Cells["dgvtbDeviceNm"].Value.ToString()); } e.SortResult = num; e.Handled = true; } }
public static void SortCompareRows(this DataGridView grid, DataGridViewSortCompareEventArgs e, string dateTimeColumnName) { e.Handled = false; //File.AppendAllText("log.txt", $"e.Column.Name={e.Column.Name}, dateTimeColumnName={dateTimeColumnName}\n"); if (e.Column.Name == dateTimeColumnName) { e.SortResult = DateTime.Compare( DateTime.Parse(grid.Rows[e.RowIndex1].Cells[dateTimeColumnName].Value as string), DateTime.Parse(grid.Rows[e.RowIndex2].Cells[dateTimeColumnName].Value as string)); e.Handled = true; //File.AppendAllText("log.txt",$"SortResult={e.SortResult}, dt1={grid.Rows[e.RowIndex1].Cells[dateTimeColumnName].Value as string}, dt2={grid.Rows[e.RowIndex2].Cells[dateTimeColumnName].Value as string}\n"); } }
private void dataGridViewStorage_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column == ColumnDevicePosition) { e.SortResult = StringUtility.NaturalCompare(e.CellValue1.ToString(), e.CellValue2.ToString()); e.Handled = true; } else { e.Handled = false; } }
void DataSortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Index < data.Columns.Count - 1 && e.Column.Index > 1 && double.TryParse(e.CellValue1.ToString().Replace("%", string.Empty), out double x) && double.TryParse(e.CellValue2.ToString().Replace("%", string.Empty), out double y)) { e.SortResult = x.CompareTo(y); e.Handled = true; } else if (e.Column.Index == data.Columns.Count - 1 && int.TryParse(e.CellValue2.ToString().Replace(",", string.Empty), out int ca) && int.TryParse(e.CellValue1.ToString().Replace(",", string.Empty), out int cb)) { e.SortResult = cb.CompareTo(ca); e.Handled = true; } }
private void dataGridView1_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { // Try to sort based on the cells in the current column. e.SortResult = System.String.Compare( e.CellValue1.ToString(), e.CellValue2.ToString()); // If the cells are equal, sort based on the ID column. if (e.SortResult == 0 && e.Column.Name != "ID") { e.SortResult = System.String.Compare( dataGridView1.Rows[e.RowIndex1].Cells["ID"].Value.ToString(), dataGridView1.Rows[e.RowIndex2].Cells["ID"].Value.ToString()); } e.Handled = true; }