Hello,
I am very new to vb.net and I would appreciate any help offered!
I have a simple form with the following items placed on it:
Two ComboBoxes: cmbLanguage and cmbLanguageVars.
Two DataAdapters: daLanguage and daLanguageVars
Two DataSets: dsLanguage and dsLanguageVars
Both comboBoxes are databound (Microsoft Access).
As the form loads, cmbLanguage is populated with the names of different languages, cmbLanguageVars is simply left blank.
The aim is that when a language is selected from cmbLanguage, then cmbLanguageVars is populated.
The SQL query for daLanguage:
SELECT LANG_NAME, LANG_ID FROM tblLanguage
The SQL query for daLanguageVars:
SELECT LANG_NAME, VAR_NAME FROM tblLanguageVars WHERE (LANG_ID = )
It should be noted that "LANG_ID" from daLanguage is used in the second SQL query.
I can offer this information about the databinding:
cmbLanguage
DataSource:dsLanguage.tblLanguage
DisplayMember:LANG_NAME
ValueMember:LANG_ID
cmbLanguageVars
DataSource:dsLanguageVars.tblLanguageVars
DisplayMember:VAR_NAME
As the form loads, cmbLanguage gets populated:
daLanguage.Fill(dsLanguage)
As the SelectedIndex from cmbLanguage changes, I populate cmbLanguageVars:
daLanguageVars.SelectCommand.Parameters("LANG_ID").Value = cmbLanguage.SelectedValue
daLanguageVars.Fill(DsLanguageVars)
This all works fine.
The second ComboBox cmbLanguageVars gets populated with the language variables in the selected language.
The problem is that if the user changes his mind and selects another language, then the variables are added to the existing items in the cmbLanguageVars!
I thought that if I cleared the ComboBox beforehand:
cmbTest.Items.Clear()
then the problem would be solved.
Unfortunately, I receive the following error:
Can't modify the Items collection when the DataSource property is set.
As I need to have the controls databound, this is a problem.
Thank you for your time taken in reading this,
Andreas.
Refreshing databound ComboBox error
Hot Topic
- Data Binding Custom Object
- Problem with inserting objects
- Textbox scrollbar
- Conditionally deploy SQL Server Express
- Sample Code to Re-Use MenuStrip items directly as Context Menus without having to create the menu twice.
- Is it possible to add a checkbox for every column???
- extendeding the TextBox control
- Standard to Professional upgrade
- Images do not appear on TabControl when using VisualStyles
- Full Screen App: Tough Print Preview Control Question
Windows Forms
- Binding button.Enable with textBox.Text!=""?
- Hanging Indent with DrawString
- VS.NET Toolbox
- Error: PInvoke item (field,method) must be Static.
- second form setting first form field
- Data grid binding
- Setting the index = -1 in Databound combo box
- How Can I Disable the VisualStyles From One Control ??
- DateTimePicker and DataBinding, 2005EE, VB
- error "Object type cannot be converted to target type." in task list
Refreshing databound ComboBox error
dlawler
You dould go DSlanguagevars.tables("mytable").rows.clear
Hope this helps, you can find other useful datagrid information here
http://www.syncfusion.com/FAQ/WinForms/default.asp#44
Tadek
thank you ever so much for your help.
I'll check it out tomorrow (it's 01:40 here now!) and let you know how I got on.
Thanks once again!