Programmatically Binding DataSource To ComboBox In Multiple Ways

Sign in to leave a comment.

• JW

  Jason Woolf4y agoPosted May 9, 2022, 1:07 PM

  What a Brilliant set of examples!!!! - Thank you
• SI

  Shehroz Imran6y agoPosted Feb 25, 2020, 4:09 AM

  Hi Mr Hemant, After filling combo box with dataset, How to assign that to class object for other uses, specially when i want to make insert funcation using class objects.
• MM

  Mukul Mohal7y agoPosted Jun 4, 2019, 9:13 AM

  I was getting an exception that "DataGridViewComboBoxCell value is not valid." then follwed this with DataError event and now i am getting error "Items collection cannot be modified when the DataSource property is set." can you please help me
• IM

  inlay mamun8y agoPosted Oct 1, 2018, 3:08 AM

  This is very helpfull
• IM

  inlay mamun8y agoPosted Oct 1, 2018, 3:08 AM

  Very Nice thanks
• RM

  Reza MoghayadNia8y agoPosted Aug 17, 2018, 3:35 AM

  I set DataSource = myDataTable and ValueMember = "ID" and DisplayMember = "SubDefineName". both columns are available in myDataTable. but myComboBox display "ID" values and don't display "SubDefineName".
• 

  SHENYAUNG WANG8y agoPosted May 21, 2018, 12:49 AM

  My combobox datasource is from SQL Server.I want to add an value to server and then combobox's display member and value will also update.But it need to restart fourm again.Can it update synchronously?
  • 

    SHENYAUNG WANG8y agoPosted May 21, 2018, 9:07 PM

    @Hemant ,I've add a code in the method. It finally can work. this.departmentTableAdapter.Fill(this.dataSet4.Department); thx for ur advice~
  • 

    Hemant Srivastava8y agoPosted May 22, 2018, 9:28 AM

    Good to hear that it's working now.
  • 

    Hemant Srivastava8y agoPosted May 21, 2018, 3:51 PM

    You need to query database to load fresh data on the combobox whenever for is loaded. This you could do either ADO.Net way or through Entity framework.
• HO

  Hercules Oberholzer8y agoPosted Feb 18, 2018, 4:38 AM

  I have tried binding ComboBox Datasource to DataTable but when I use ComboBox.SelectedValue.ToString() I get "System.Data.DataRowView"
  • 

    Hemant Srivastava8y agoPosted Feb 21, 2018, 3:00 PM

    Hi Hercules, Sometimes it happens when DisplayMember and ValueMember properties of ComboBox don't exact match with respective column names of your data Table. Then DisplayMember could not understand which column needs to be bound and display "System.Data.DataRowView".
• MA

  Mitul ahir9y agoPosted Aug 22, 2017, 6:14 AM

  How to add default value in combo box after binding it with database directly
• JN

  J N11y agoPosted Oct 17, 2015, 2:14 AM

  Sorry but you're data set, data table and data viewer crash. Where do you write that stored procedure, please? In a C# class, I don't exactly follow?
  • 

    Hemant Srivastava10y agoPosted Dec 28, 2015, 2:51 PM

    You need to create a table in a database (e.g. in SQL Server). In this case, I have already created a database named "HKS" and a Table "ADDRESS" in HKS Database on SQL Server. Then you need to create a stored procedure in your database with the given script in the article.