private void btnNotEqualFilter_Click(object sender, EventArgs e) { // ExStart:NotEqualCustomFilter // Get the RowFilter object for the first worksheet. RowFilterSettings rowFilter = gridDesktop1.Worksheets[0].RowFilter; // Filter Rows. rowFilter.CustomRows(0, GridFilterOperatorType.NotEqual, "Customer 1"); gridDesktop1.Worksheets[0].RefreshFilter(); // ExEnd:NotEqualCustomFilter }
private void button2_Click(object sender, EventArgs e) { // ExStart:CustomFilter // Set the header row. gridDesktop1.Worksheets[0].RowFilter.HeaderRow = 0; // Get the RowFilter object for the first worksheet. RowFilterSettings rowFilter = gridDesktop1.Worksheets[0].RowFilter; // Filter Rows. rowFilter.FilterRows(0, "Customer 1"); gridDesktop1.Worksheets[0].RefreshFilter(); // ExEnd:CustomFilter }
private void button2_Click(object sender, EventArgs e) { // ExStart:CustomFilter // Set the starting row. gridDesktop1.Worksheets[0].RowFilter.StartRow = 1; // Set the ending row. gridDesktop1.Worksheets[0].RowFilter.EndRow = 101; // Get the RowFilter object for the first worksheet. RowFilterSettings rowFilter = gridDesktop1.Worksheets[0].RowFilter; // Filter Rows. rowFilter.FilterRows(0, "Customer 1"); // ExEnd:CustomFilter }