Questions tagged [rowfilter]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
20votes
2answers
31kviews

How can I reset table.DefaultView.RowFilter?

The code below works fine and filters the rows correctly but how would I restore the table to its original state? DataTable table = this.dataGridView1.DataSource as DataTable; table.DefaultView....
user avatar
15votes
2answers
10kviews

How can I perform a case-insensitive filter on a JTable?

I am making a table with a text field below it where you can type in a word to filter the table. It works, but what I want to do is be able to filter it with the word typed in, but ignoring the case ...
user avatar
14votes
3answers
44kviews

Compare dates in DataView.RowFilter?

I am scratching my head over something rather stupid yet apparently difficult. DataView dvFormula = dsFormula.Tables[0].DefaultView; dvFormula.RowFilter = "'" + startDate.ToString("yyyyMMdd") + "' &...
user avatar
  • 13.7k
10votes
2answers
7kviews

How does JTable RowFilter work?

I'm try to create a Row filter for a JTable to limit the number of rows displayed in the table. The RowFilter code is simple. It converts the model row number to the view row number (in case the ...
user avatar
  • 315k
8votes
3answers
22kviews

RowFilter.regexFilter multiple columns

I am currently using the following to filter my JTable RowFilter.regexFilter( Pattern.compile(textField.getText(), Pattern.CASE_INSENSITIVE).toString(), columns ); How do I ...
user avatar
  • 2,683
7votes
2answers
2kviews

Highlights subString in the TableCell(s) which is using for JTable filetering

how is possible to synchonize text typed into JTextField (then by DocumentListener passed String to the RowFilter) with TableCell if contains same as String value in JTextField/Document, and then ...
user avatar
  • 109k
7votes
1answer
3kviews

Row filter doesn't work as expected on cell update events

Working in a shared table model example I realized that if we attach a row filter to a table's row sorter this filter doesn't have any effect on cell update events. According to RowSorter API: ...
user avatar
  • 17.6k
6votes
2answers
12kviews

How to set RowFilter case-insensitive for DataView

I have a datagrid, its datasource is a dataview. There is a textbox with which users can type in filter text. I want to make the filter to be case insensitive. say, the typed text is "Tg" I tried ...
user avatar
  • 2,209
6votes
2answers
2kviews

Why does DataTable.Select() return the wrong rows?

The DataTable.Select() function returns the wrong rows with a filter like this... "booleanColumn1 AND booleanColumn2 AND GuidColumn1 = '00000000-0000-0000-0000-000000000000')" Making virtually any ...
user avatar
  • 71
5votes
4answers
52kviews

How can I filter rows in a JTable?

I have a JTable with many strings in it. I have created a textbox for user entry, above the table. I want a row filter which can remove the rows having strings entered by the user in the text box. ...
user avatar
5votes
3answers
10kviews

Set DataView (or DataTable.DefaultView) RowFilter for a custom type

I'm developing an application on the datagridview filtering. I'm using RowFilter property of the dataview for the filtering data. My database table contains int & varchar data type fields. And I ...
user avatar
  • 523
5votes
2answers
30kviews

RowFilter on a DataTable to display in a gridview

I have the following code which doesn't seem to work. In the Page_Load function I populate the DataSet and display the results in a grid view. newsCommand = new SqlCommand("SQL code here", ...
user avatar
5votes
1answer
2kviews

How To Refresh a Bound DataGridView On CheckBox Click

Goal I need a way to set items as Completed by clicking on a CheckBox in my bound DataGridView. Once that is done, the item is no longer seen from the DataGridView due to a DataView's row filter. ...
user avatar
  • 4,581
5votes
1answer
8kviews

Implement search textField into jTable

Now I have a search textField implemented with KeyReleased event, which don't found/update jTable when I start typing for example "An" from "Andrew", and just after I finish to type exactly (...
user avatar
4votes
2answers
6kviews

JTable row filtering based on values of two different columns

I want to implement row filtering in a JTable, based on values of two different columns: column1 = 1 column2 = 5 Here is the method that performs row-filtering based on INDEX_FIELD = 1 condition: ...
user avatar
  • 365
4votes
1answer
12kviews

How to get data after DataView filtering?

I apply a filter to Dataview and after that I need to get the filtered data. before filtering I did: dvUnloadOpenAccounts.RowFilter = "uso_id = '30640'"; foreach (DataRow row in dvUnloadOpenAccounts....
user avatar
  • 1,119
4votes
1answer
14kviews

JTable, RowFilter and RowFilter.Entry

please I have an issue with RowFilter (its ComparisonType) to put together Regex(String), Number, Date together with AND, OR, NOR no idea how to handle with null value for AND, OR, NOR if ...
user avatar
  • 109k
4votes
3answers
7kviews

Filtering by date with DataTable.RowFilter while ignoring time

How do I filter for records on a DataTable which are on a certain date? I've tried plain [datecol] = #11 March 2010# and CONVERT([datecol],'System.DateTime') = #11 March 2010#. With no luck. MSDN: ...
user avatar
  • 5,279
4votes
1answer
642views

Matching parentheses with a RowFilter (regexFilter)

protected void searchFilter(String s, int n) { RowFilter<MyTableModel, Object> rf = null; try { System.out.println(s); rf = RowFilter.regexFilter(s, n); ...
user avatar
4votes
2answers
21kviews

Filter records from the dataset in vb.net

I want to filter values from a dataset. It contain phone numbers starting with zero and non zero values. How can I filter a phone number (start with non zero no) from the dataset. Below is the vb.net ...
user avatar
  • 1,307
4votes
3answers
2kviews

DateTime filtering in DataTable.DefaultView.RowFilter

I have tried to filter the DateTime column from a DataTable using RowFilter and the column contains the Date with the Time. I have tried like below, dataView.RowFilter = "[Date] = #6/26/2011 2:53:24 ...
user avatar
  • 141
4votes
1answer
2kviews

How to Filter DataGridView with DataSet as DataSource

Need some help. I retrieve data from a Database and fill it into a DataSet using a TableAdapter. MyTableAdapter.Fill(MyDataSet, "Table1") DataGridView1.DataSource=MyDataSet DataGridView1....
user avatar
3votes
4answers
20kviews

Missing operand after '=' operator

I have this line of code which uses a dataview view_1 and I'm trying to filter the datagridview by product_name and its size using the RowFilter. Here is the code: view_1.RowFilter = "product_name = '...
user avatar
  • 377
3votes
3answers
20kviews

Querying inside a Dataset C#

I have an ADO.NET dataset which is set by a certain query, say SELECT ID,USER,PRODUCT,COUNT FROM PRODUCTION Without using a where clause I need to derive some results from the dataset. Say I want to ...
user avatar
  • 2,095
3votes
2answers
6kviews

I want to obtain auto filtering in JTable as in ms excel

I am using jtable to display data from ms sql server table. I am able to sort the data using: TableRowSorter<TableModel> sorter = new TableRowSorter<TableModel>(model); jtable....
user avatar
3votes
2answers
5kviews

Multiple cell renderers for a column in a JTable?

Let's say I have the following JTable, which is displayed as soon as a button is pressed: | Name ------+------------ True | Hello World False | Foo Bar True | Foo False | Bar I want to ...
user avatar
  • 4,916
3votes
1answer
7kviews

Java Swing: Combine RowFilter.andFilter with RowFilter.orFilter

I couldn't quite get this to work, and the examples I found only worked with a single RowFilter.andFilter or a RowFilter.orFilter. Is there a way to combine two to get something like (A || B) &&...
user avatar
3votes
3answers
12kviews

Datagridview row filter

I am using DataView and RowFilter. Only one column is filtering, but I want all columns to be filtered. I would like to search for a word in the text box to make this filter. DataView dv = dt....
user avatar
  • 115
3votes
3answers
7kviews

Filter number in a DataView using RowFilter in C#4.0

I'm trying to filter my DataView DataSet using RowFilter. I would like to perform a like statement on an Integer column So something like this: myDataView.RowFilter ="ID LIKE %1%"; This works ...
user avatar
3votes
1answer
6kviews

Filter rows in HBase based on partial row keys

I have my HBase data with row key as siteid_timestamp. ROW COLUMN+CELL 001_1454578003995 column=hd:abc, timestamp=1454578173766, value=2 001_1454578003996 column=hd:def, ...
user avatar
3votes
2answers
1kviews

How to disable column header sorting in a jtable after RowFilter filtering is applied

I have a JTable which is passed to another class when a JToggleButton is clicked, a popup with parameters for filtering appears and the JTable is filtered using RowFilter with the given parameters. ...
user avatar
3votes
5answers
15kviews

Filtering a empty string in DataTable

How do filter a empty String in DataTable? I need to filter a column (say Customer Name where the name is string.Empty) I tried this but i cant get into right way.. I need to filter the DataView ...
user avatar
  • 2,485
3votes
1answer
3kviews

"Concatenating" andFilter and orFilter for RowFilter

I have a JTable with four columns, the first one containing either a number or a text, the other three only text. I'm trying to filter this table with the help of a RowFilter: sorter = new ...
user avatar
  • 755
3votes
2answers
3kviews

Delete a row in a JTable with a RowFilter

I have a Swing desktop application with a JTable. There are no problems when adding rows to the JTable. I can also sort (using JTable.autoCreateRowSorter) and then delete the row (using ...
user avatar
  • 460
3votes
2answers
1kviews

DataView RowFilter with TimeSpan DataType

I try to use the DataView RowFilter for a column with DataType "TimeSpan" as following: dv.RowFilter = ("Convert([time],System.String) LIKE '17:12:00'") I've found that the search Parameter "%17% or ...
user avatar
3votes
2answers
966views

Search bulk datas within a JTable through JTextField without much delay

I have created an application which searches the datas listed within a JTable while entering the required data in a JTextField. The application works fine for small amount of datas, but in the case ...
user avatar
3votes
3answers
4kviews

Filter a DataGridView

I'm trying to filter a DataGridView, the DataSource is a DataSet. So I'm using the following line to filter the grid: DataTable dt = (dataGridViewMain.DataSource as DataSet).Tables[0]; dt....
user avatar
3votes
2answers
3kviews

How to get the current filtered TableModel

I have this code below, in which, after a mouseClick event it filters the rows based on a JList getSelectedItem().toString(), here is the code: try{ TableRowSorter<TableModel> rowSorter ...
user avatar
  • 908
3votes
2answers
1kviews

Unable to have a dash (-) in the name of a datatable column for filtering

I got a problem with filtering datatables. One Column is calles BANF-Nummer. Using a filter, I got a error message. I wrote the following code for that: FilterExpression = "(Kontierungsobjekt = '...
user avatar
  • 39
3votes
2answers
3kviews

C# Convert DataView to Table (DataTable) in .NET 1.1

I have a dataview on which I have set a rowfilter: DataView dv = ds.Tables[0].DefaultView; dv.RowFilter = "here my filter"; Once data filtered, I want to convert it to a DataTable. I know this is ...
user avatar
  • 8,478
3votes
1answer
4kviews

Injection Attacks against .NET DataView RowFilter

So I'm writing a handler that filters a cached DataTable based on the AppRelativeCurrentExecutionFilePath using the DataView RowFilter property. What's the best way to encode the input to prevent an ...
user avatar
  • 13.3k
2votes
2answers
40kviews

How to apply filter to DataView with Multiple "AND" conditions

I have a DataTable containing the some rows. Which is copied to DataView. Now I have IDs in form of List<string>. which contains the selected items from GridView. Now I want to filter this ...
user avatar
2votes
2answers
5kviews

How to get a subset DataTable from another DataTable filtered by few column values?

The problem I have is, my search criteria is: Row["colName"] != "abc" AND Row["colName"] != "def" AND Row["colName"] != "ghic" AND Row["colName"] != "klm" AND Row["colName"] != "xyz" AND Row[...
user avatar
  • 2,056
2votes
2answers
9kviews

Issue after filtering JTable

I have an issue with a program I am working on. To briefly explain, I have a JTable with multiple columns and rows. Particular columns have editable fields when upon changing the value other column ...
user avatar
  • 52
2votes
3answers
6kviews

Filter JTable based on a jtextfield NON Case Sensitive (Java)

I already can filter the JTable using a JTextField, the problem is that is case sensitive. For example, I got this name in the Jtable: "Guillian Fox", if I write "guillian fox or "GUILLIAN FOX" in the ...
user avatar
  • 842
2votes
1answer
22kviews

dataTable.DefaultView.Rowfilter always returning first row

I've been trying to make a search function for a dataTable. My problem is that the first row of the table is ALWAYS within the filtered rows, even when the boolean column is actually changed to a zero....
user avatar
2votes
2answers
4kviews

Match a single character in a DataView RowFilter?

I'm wondering if there is any possible way of applying a RowFilter on a DataView which provides single character matching? e.g. DataView.RowFilter = "SOME_COL like 'A_BCD%'; where the underscore ...
user avatar
  • 565
2votes
2answers
2kviews

Very big JTable, RowFilter and extra load

I wanted to ask for a clarification about the use of RowFilter and its effects on performances. I implemented a filter through the method include(Entry) that for every row simply checks if its ...
user avatar
  • 3,828
2votes
2answers
3kviews

JTable filtering by an exact match to a String

I want to filter a JTable exactly by a string. My filter is like this: Pattern.quote(textfield.getText()); But, when I filter on "G" I get also all lines of the JTable with the entry "KG". I just ...
user avatar
2votes
2answers
1kviews

How to filter a row OUT of a JTable using RowFilter

Every example I have seen for this uses RowFilter.regexFilter and filters everything else out except the given text. I want the rows of the given text filtered OUT. It doesn't even make sense the ...
user avatar
  • 1,481

15 30 50 per page
1
2 3 4 5 6