Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First of all, you have named variables employees and holidays, but that does mean the tables within the dataset have names changed; they are still set to the default names, which, in your case are table and table1. (They would normally be table, table1 ... tableN) That means that your display member property should be as follows:</p> <pre><code>listBox1.DisplayMember = "table.relation.start"; </code></pre> <p>Also, make sure you databind to the dataset itself rather than the holiday table within the dataset as follows:</p> <pre><code>listBox1.DataSource = d; </code></pre> <p>With these two changes, you should find that it works; this.BindingContext should help in navigating the parent records as you will notice only 1 set of child (holiday) results are shown at at time.</p> <p>Complete modified code as follows:</p> <pre><code> var command = new SQLiteCommand("SELECT * FROM employees; SELECT * FROM holidays"); var connection=new SQLiteConnection(@"data source=C:\employees.db"); command.Connection = connection; SQLiteDataAdapter adapter = new SQLiteDataAdapter(command); DataSet d = new DataSet(); adapter.Fill(d); DataTable employees = d.Tables[0]; // [...] // here I'm databinding my textboxes etc. to various columns // of the employees data table - this works fine, navigation works well etc. // [...] DataTable holidays = d.Tables[1]; DataRelation relation; DataColumn master = employees.Columns["id"]; DataColumn slave = holidays.Columns["employeeid"]; relation = new DataRelation("relation", master, slave); d.Relations.Add(relation); listBox1.DisplayMember = "table.relation.start"; // &lt;= it wouldn't look good like that of course, but I just want to get the thing to work for now listBox1.DataSource = d; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PODataRelation between two data tables - can't bind data to a listbox (C# .NET 3.5)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USMartin Booth
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODataRelation between two data tables - can't bind data to a listbox (C# .NET 3.5)
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt does return filtered holidays - thank you very much Martin! I still have problems with enabling the navigation though... how do I retrieve the CurrencyManager common for BOTH master and detail controls (so they stay coordinated)?? I tried cam=(CurrencyManager)this.BindingContext[d,"table"]; but only the holidays listbox changes its contents as cam.Position changes. BindingContext[d]? all of them are dead. If I add textBox1.DataBindings[0].BindingManagerBase.Position = cam.Position; in both Prev_Click and Next_Click event handlers of my navigation buttons..it works, but that's kinda hack
      singulars
      1. PO
      1. USKonrad Morawski
 

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