Binding Navigator/Binding Source/DataGridView - how to?

• • Reply

  12 years ago

  by bfsog

  bfsog

  UK, United Kingdom

  Joined 15 years ago

  I thought this would be pretty easy but I have been trying for 4 days now.

   What I am trying to do is

  • Query a database
  • Place the query results into a DataSet
  • Set the Binding Source to that DataSet
  • Set the Binding Navigator's DataSource to the Binding Source
  • Set the DataGridView's DataSource to the Binding Source

  However I cannot get the Binding Navigator to actually "navigate" through the returned data. The Navigator appears on my form, but the controls do not work and the row count says 1 whereas the DataGridView has around 300+ rows.

  I do not know what I am doing wrong, I appreciate any help.

  Here is the relevant code.

  </P><FONT size=2> <P>SqlCommand all = new SqlCommand("SELECT IndexNumber, VesselName, Active, Note, Agent, CustomerCode, ShippingAgent, CustomerPO, DeliverylabelReport, LastUpdate, EmailAddress from TableIndex", conn);
  SqlDataAdapter adpt = new SqlDataAdapter(all);
  DataSet ds = new DataSet();
  adpt.Fill(ds, "TableIndex");
  dgvCompanies.DataSource = ds.Tables[0];</P> <P>BindingNavigator _navigator;
  BindingSource _bindsrc = new BindingSource();</P> <P>_bindsrc.Add(ds);</P> <P>_navigator = new BindingNavigator(true);
  _navigator.Parent = this;
  _navigator.BindingSource = _bindsrc;
  _navigator.Dock = DockStyle.Top;</P> <P>dgvCompanies.DataSource = _bindsrc;</P> <P mce_keep="true">&nbsp;</P> <P>

  Report abuse
• • Reply

  12 years ago

  by aronack

  Andy

  , United Kingdom

  Joined 13 years ago

   

  Hi,

   

  This is because the data binding is not correct.  Use BindingSource to bind data with the DataGridView as well as BindingNavigator:

   

  Me.BindingSource1.DataSource = ds.Tables(0)

        Me.DataGridView1.DataSource = Me.BindingSource1

        Me.BindingNavigator1.BindingSource = Me.BindingSource1

   

  Hope this helps.

   

  Regards,

  Vinay

  ComponentOne LLC.

  www.componentone.com

   

   

  Report abuse
• • Reply

  12 years ago

  by bfsog

  bfsog

  UK, United Kingdom

  Joined 15 years ago
  Thanks, I have searched high and low, it's working now.
  
  Report abuse