sfDatagrid with bindingnavigator to textboxes

Question

Hi,i have a WinForm with sfdatagrid. In load-Event i set sfdatagrid.datasource to an datatable.Now i need separated textboxes in the form with bind also to the datatable ... OK to here is more crtitical problems.But, how i can combine the databinding from sfdatagrid over an bindingnavigator with the dabinding from textboxes ... change selection (record) in sfdatagrid = change the position from bindingnavigator to set value in textboxes.what is the "best" practice to dev this?i hope you can understand me, because my english ist not the best :)best regards Daniel

Vijayarasan Sivanandham · Accepted Answer

Daniel,

Your requirement to update the current position in the related binding source
in SfDataGrid can be achieved by using the CurrentItem in SfDataGrid. Refer to
the below code snippet,

// Event Subscription
  this.sfDataGrid1.SelectionChanged +=
  OnSelectionChanged;
   
  //Event Customization
  private void
  OnSelectionChanged(object sender,
  Syncfusion.WinForms.DataGrid.Events.SelectionChangedEventArgs e)
  {
      // Get the current position of the binding
  source.
      var
  index = this.bindingNavigator1.BindingSource.CurrencyManager.List.IndexOf(sfDataGrid1.CurrentItem);
      // Set the position of the binding source
  to the corresponding row index in the grid.
      this.bindingNavigator1.BindingSource.Position
  = index;
      // Display the index in TextBox
      this.bindingNavigatorPositionItem.Text =
  index.ToString();
  }

UG Link: https://help.syncfusion.com/windowsforms/datagrid/selection#retrieving-the-current-item-and-display-in-message-box

https://help.syncfusion.com/windowsforms/datagrid/selection#currentitem-vs-selecteditem

https://help.syncfusion.com/windowsforms/datagrid/selection#process-current-cell

Find the modified sample in the attachment.

Regards,
Vijayarasan S

If this post is helpful, please consider Accepting it as the solution so that
other members can locate it more quickly.Attachment: ModifiedSample_903dd25e.zip

Sathiyathanam Jeyakumar · Answer

Hi Daniel,We suspect that your
requirement is to change the selection in the sfdatagrid when clicking the
MoveNext or MovePrevious button in the BindingNavigator. Additionally, you want
to change the selection when the BindingNavigator TextBox TextChanged event
occurs. Could you please confirm if this is your exact requirement? If we have misunderstood your
scenario, please provide us with more information, along with screenshots or
video illustrations, regarding your requirements.Regards,Sathiyathanam

Daniel · Answer

Hi,i want to change the "number in BindingNavigator" (Textbox) when i click in the SfDataGrid (set active Cell).RegardsDaniel

Sathiyathanam Jeyakumar · Answer

Daniel,You can update the BindingNavigator Textbox by using the
SelectionChanged event in SfDataGrid. Refer to the below code snippets.

this.sfDataGrid1.SelectionChanged
  += SfDataGrid1_SelectionChanged;
   
  private void SfDataGrid1_SelectionChanged(object sender,
  Syncfusion.WinForms.DataGrid.Events.SelectionChangedEventArgs e)
  {
      this.bindingNavigatorPositionItem.Text
  = this.sfDataGrid1.SelectedIndex.ToString();
  }

If we have misunderstood your scenario, please provide us with more information, along with your requirements.Attachment: EditingDemo_cd35f0ba.zip

Daniel · Answer

Hi,thanks for the answer, but sorry, i expressed myself wrong.I need to set "BindingNavigator.BindingSource.Position = x"But my problem: x is not the real rowindex. If i create a columngroup or sort a column than "x!=x"(example: the item in row 2 before sort have an id = 12 and after sort ... is that item in row 10. the bindingposition is already 2)

Daniel · Answer

Thank you very much, this works for me 👍Sorry for my late reply, i have a hard work-week

Vijayarasan Sivanandham · Answer

Daniel,We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊.