Databases
StackOverflow2013
Postsdbo
POFiltering related data in a DataGridView
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFiltering related data in a DataGridView
    primarykey
    data
    text
    <p>I have a <code>DataGridView</code> that pulls data from a couple tables similarly to <a href="https://stackoverflow.com/questions/5678326/showing-the-related-data-in-datagridview" title="Showing the related data in Datagridview">this</a> setup. It works great. Good post and answer. Continuing with the example in that post, I now want to create a filter that yields all transactions in the <code>DataGridView</code> that apply to a specific account by using a <code>LIKE</code> parameter on the account description.</p> <p>I have a solution by checking the accounts table for the description and obtaining the IDAccount value then using that value in the <code>DataGridView</code> filter, but I was hoping there would be a more automated way using bindings.</p> <p>Any ideas? Thank you for your suggestions.</p> <p><strong>Edit</strong>: Supposing I have a <code>TextBox</code> control called AccountDescriptionBox, I'd like to be able to do something like</p> <pre><code>dataGridView1.Filter = string.Format("{0} LIKE '{1}'", "IDAccount", AccountDescriptionBox.Text); </code></pre> <p>Obviously, this won't work as IDAccount is an integer, not a string. The solution I mention above is</p> <pre><code>string filter = string.Empty; Regex searchTerm = new Regex(Regex.Escape(AccountDescriptionBox.Text).Replace('\\', '.'), RegexOptions.IgnoreCase); var accts = from acct in dataSet1.Accounts let matches = searchTerm.Matches(acct.Description) where matches.Count &gt; 0 select acct.ID; for (int i; i &lt; accts.Count() - 1; i++) { filter += string.Format("IDAccount = {0} OR ",accts.ElementAt(i)); } filter += string.Format("IDAccount = {0}",accts.Last()); dataGridView1.Filter = filter; </code></pre> <p>This works, but is cumbersome. I'd rather do it through bindings if there's a way.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USgregsdennis
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POFiltering related data in a DataGridView
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCode snippets to illustrate what it is you trying to accomplish may help
      singulars
      1. POFiltering related data in a DataGridView
      1. USCoops
    2. COI have also been trying out how to filter datagridviews lately. In my case they were populated by linq. The solution I'm using now is to simply use the linq query as the filter, so the filtering happens before the rows end up in the datagridview. Might work for you depending on your situation.
      singulars
      1. POFiltering related data in a DataGridView
      1. USDavveK
    3. CO@CodeBlend, see my edit.
      singulars
      1. POFiltering related data in a DataGridView
      1. USgregsdennis
 

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