Databases
StackOverflow2013
Postsdbo
POFilter while typing
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFilter while typing
    primarykey
    data
    text
    <p>In my winforms app I have a textbox which filters the datagrid while typing (search while typing), this works fine, I also have another button to apply a filter via two comboboxes.</p> <p>This button does a copy of the datatable connected to the datagridview as datasource, and changes the datagridviews datasource to the copy of the datatable.</p> <p>When this filter is applied via the button, I make another button visible (called btnRemoveFilterFserie) to "remove" the filter by changing the datasource back to the original datatable.</p> <p>When btnRemoveFilterFserie.Visible == true it means that a other filter is applied and I want to apply the search when typing on the DS1Filter3 datatable, but it returns an error that the [Description] column isn't found on this line</p> <pre><code>DataRow[] result = DS1Filter.Select(outputInfo); </code></pre> <p>I hope it isn't to confusing to understand my explanation.</p> <p>This is the code that I use.</p> <pre><code>private void txtFserieSearch_KeyUp(object sender, KeyEventArgs e) { string outputInfo = ""; string[] keyWords = txtFserieSearch.Text.Split(' '); foreach (string word in keyWords) { if (outputInfo.Length == 0) { outputInfo = "(Description LIKE '%" + word + "%' OR `Function Value` LIKE '%" + word + "%')"; } else { outputInfo += " AND (Description LIKE '%" + word + "%' OR `Function Value` LIKE '%" + word + "%')"; } } if (btnRemoveFilterFserie.Visible == true) { //Applies the filter to the DataView DataRow[] result = DS1Filter.Select(outputInfo); DataTable DS1Filter3 = DS1Filter.Clone(); foreach (DataRow row in result) { DS1Filter3.ImportRow(row); } dataGridFserie.DataSource = DS1Filter3; } else if (btnRemoveFilterFserie.Visible == false) { DataRow[] result = DS1.Select(outputInfo); DataTable DS1Filter2 = DS1.Clone(); foreach (DataRow row in result) { DS1Filter2.ImportRow(row); } dataGridFserie.DataSource = DS1Filter2; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPandaNL
    1. USPandaNL
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COWhat are you doing exactly, what you want and what part triggers the error is not too clear. Can you please start clarifying these issues? For example: which part of your code is triggering the error?
      singulars
      1. POFilter while typing
      1. USvarocarbas
    2. COTried to clear some things up.
      singulars
      1. POFilter while typing
      1. USPandaNL
    3. COThere is not an immediate communication Datasources-Datagridview; actually, there might be some differences with the indices. That's why it is always recommendable to modify both elements (DataSource and DGV) at the same time. From the code you posted, I understand that the Datasources are re-defined on a regular basis (not the DGV), although the exact conditions are not yet too clear. This might be provoked a coordination problem and thus the error is triggered because you intend to access a record (defined by row/column) not present in the DataSource anymore
      singulars
      1. POFilter while typing
      1. USvarocarbas
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload