Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The code you posted looks fine to me. I replicated your code (in C#, but I tried to keep it as close to your code as possible) and it just worked. The only code you didn't post is the event handler of the <code>Add</code> button. Did you check that it is actually called and that a new item is added to the collection?</p> <p>Anyway here is my code, maybe you can spot where the difference is between this and your version:</p> <p>CollectionOfBlogs.cs:</p> <pre><code>public class CollectionOfBlogs : INotifyPropertyChanged { public event PropertyChangedEventHandler PropertyChanged; private string _FullName; public string FullName { get { return this._FullName; } set { if (this._FullName != value) { this._FullName = value; this.OnPropertyChanged("FullName"); } } } public CollectionOfBlogs(string name) { this._FullName = name; } public virtual void OnPropertyChanged(string propertyName) { if (this.PropertyChanged != null) { this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); } } public override string ToString() { return this._FullName; } } </code></pre> <p>ITRSBlogs.cs:</p> <pre><code>public class ITRSBlogs { public ObservableCollection&lt;CollectionOfBlogs&gt; blogNamesList = new ObservableCollection&lt;CollectionOfBlogs&gt;(); public void AddBlog(string fullName) { this.blogNamesList.Add(new CollectionOfBlogs(fullName)); } public void FillBlogList() { this.blogNamesList.Clear(); this.AddBlog("First blog"); this.AddBlog("Another blog"); } } </code></pre> <p>MainWindow.xaml:</p> <pre><code>&lt;Window x:Class="ObservableRefreshDemo.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" Height="350" Width="525" Loaded="Window_Loaded"&gt; &lt;Grid&gt; &lt;ListBox Name="BloggingMenuListBox"/&gt; &lt;Button Content="Add" Height="23" HorizontalAlignment="Left" Margin="154,276,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" /&gt; &lt;TextBox Height="23" HorizontalAlignment="Left" Margin="12,276,0,0" Name="txtName" VerticalAlignment="Top" Width="120" /&gt; &lt;/Grid&gt; &lt;/Window&gt; </code></pre> <p>MainWindow.xaml.cs:</p> <pre><code>public partial class MainWindow : Window { private ITRSBlogs blogClass = new ITRSBlogs(); public MainWindow() { InitializeComponent(); } private void Window_Loaded(object sender, RoutedEventArgs e) { this.blogClass.FillBlogList(); this.BloggingMenuListBox.ItemsSource = this.blogClass.blogNamesList; } private void button1_Click(object sender, RoutedEventArgs e) { this.blogClass.AddBlog(this.txtName.Text); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POListbox bound to ObservableCollection (in VB.NET and Silverlight)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USTomBot
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POListbox bound to ObservableCollection (in VB.NET and Silverlight)
      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
    1. COThanks TomBot, I think I understand what's wrong, but I don't know how to fix it. I did leave out some important points I see. On my MainPage I have a menu with lots of choices, one of those choices is to add a new blog. When you click that button, it loads a different page where the actual textbox and save button are. So, this page also has a Dim blogClass as New ITRSBlogs, and it does call the addblog method and add the name in the textbox to the collection. However I dont have a good understanding of how the listbox bound to the collection back on the mainpage get's updated.
      singulars
      1. PO
      1. USChris Phelps
    2. COIn other words, I think I've got multiple copies of the collection going, and I'm not sure how that all works. How do I ensure that I'm looking at the same collection on both pages?
      singulars
      1. PO
      1. USChris Phelps
    3. COYou definitely have to make sure that you only have one collection. The simplest solution would be that the collection is in the MainPage, and when you open the AddDialog, you give a reference to the collection to it. Something like AddDialog dlg = new AddDialog(); dlg.Collction = this.Collection; dlg.ShowDialog();
      singulars
      1. PO
      1. USTomBot
 

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