I have 2 comboboxes. When I choose a country in cboLand I want only the states to show in cboStaat that are associated with the country from cboLand. I tried the code below but I get all different error messages. Perhaps you can see something in my code that I missed.
[Code]...
So im trying to fill a combo box with data from a database but depending on how much a pregressbar is filled THis is what im trying:
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Form1.ProgressBar9.Value <= 10 Then
Me.Level1TableAdapter.Fill(Me.CTDBDataSet1.Level1)
[code]....
How to fill another combobox depending on the value selected from first combobox?
View 2 RepliesI have 2 combo boxes. One is in a form called subcat_selector.vb
on the button Pick Sub Catagory.click event it shows the subcat_selector form. form there, the onload event:
Dim button As DialogResult
[Code].....
I have a web page that I need to log in, the first page is not a problem I can log in as it only has the company name to enter, but from here is where I have problems, as when the first page is done, I am directed to a second page with two fields that has to be filled, filename and author, then depending on the action you have to click on in button,out,button delay button, here is where I need help, how do I fill the second page fields and how to chose the right button depending the action to take.
View 9 RepliesI have achieve to populate my combobox from sql and from this combobox to populate a textbox but now I have to do something more complicated.I would like to populate a combobox from an other combobox choice. And what i mean is that I have a table with Streenames and Postcodes. What I want to do is fistly to choose the Streetname from the one combobox and the interface to appear the Postcodes to the second combobox. Secondly, the postcode combobox should appear more than one postcodes because it is probable that the same streetname maybe belongs to more than one region(postcode).
View 4 RepliesI have a form with a combobox and a textbox. The combobox is used to select a username and the textbox displays the staff No. I use the following code to populate the combobox.Private Sub DeleteUser_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
[Code]...
i have a DB table and a form the following fields , combobox and textboxes, what i need is how to write a query to retrieve data from the table when the user select some record from combobox
View 7 RepliesI have a small section of a windows form that allows users to select when a customer should be called (i.e. day of the week, time and inbound or outbound)When the form is loaded I will extract the information using a dataset and bind to form controls. I want to use a combo box for call stautus - inbound or outbound - however wish to give the user the choice at runtime.My thoughts are I would need to set a static list (so the user could choose) and set the default or displayed value to the info the dataset has extracted.This code to select the index doesnt work when I am comparing the dataset result to the "Outbound" string even though I am using the ToString method.
Private Sub TestTelesalesForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.Telesales_DEV004016TableAdapter1.Fill(TelesalesDataset1.Telesales_DEV004016)
Me.comboCallStatus.Items.Add("Outbound")
[code]....
I am trying to fill a combo box from SQL Server 2008. Getting the Combo Box to populate isn't the problem. What I need to do is have the text field read the field value that goes with a specific id that I search by, while keeping all other fields available to chose from to change the value for that specific id and save back to the database. I know this isn't clear here is the best example I can think of:
COMBOBOX --FieldValue------->
--DropDownField1--> Ten
--DropDownField2--> Twenty
[Code].....
I seriously might have to infest in some Rogaine if I have to spend another ten minutes on this. I do know that I am missing an id to compare to but when I add the id into the sql statement the combo box only fills with the one value that it equals to without the option to chose from the several others to change.
how can i fill two value in combo box . first one for visible and second one for backend(key column) like in vb (Item data)[code]
View 1 RepliesHow do I fill a combo box at run time and set the selected value as well? I'm filling the the combo box from a database.
View 11 RepliesI have two comboBoxes, one is CountryCombo and second is StateCombo.What I want is the that when i the clicks country combo and select a one country then the States of that the country should get populated in the State Combo.I have tried things many many many but nothing working. Below is my code of how my CountryCombo is getting filled.
query="select CountryName from CountryMaster"
if dr.hasRows()
{[code]......
I ahve a combox (cbnames) on a login form which is populated with items. I make a selection and click on ok. Form1 appears and I have a textbox which I want to fill with the selected item from the combo box.
However, on form1 (view code) I don't appear to see cbnames. cbnames is available on the login form. How do i make a combobox public? or accessible to other forms?
I have a binding source, a Data Table, a Table Adapter and a combo box. How to fill a combo box using these parts? When I fget done I am Showing System.Data.... Example.JPG
[Code]...
I want to choose a value dynamically from comboBox depending of the values selected previously in two comboBoxes.the code that loads the comboBoxes:
Private Sub LightClassComboBox_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles AreaClasificationComboBox.DropDown
TrafficDensityComboBox.DropDown,.....
[code]....
The problem is that in the last Sub in the If sentence gives an error of: Null Reference Exception, because the compiler thinks that in that event the data are not loaded, although the data are loaded when loadcomboBoxes sub is executed.
I've already found evidence of another having this problem. You can see this on this post by someone else:
http:groups.google...096b3fcaa?pli=1
The problem is that when one navigates the combobox via the keyboard, the combobox's information doesn't update. If you click a value with your mouse, though, everything works wonderfully. The link I've mentioned suggests changing the binding from the Text property to the SelectedItem property. I'm very deep into this project and it would be a bit of a nuisance to change the setup so as to allow it to be bound to the SelectedItem property.What I'm wondering is whether or not I can detect the user changing the selected entry in the combobox and tell VB that they "clicked" the value, if that makes any sense.
Employee emp = new Employee();
comHandledBySQt.DataSource = emp.GetDataFromTable("1");
comHandledBySQt.DisplayMember = "FirstName";
The above code displays drop list of employees first names in a combo box. I want first name and last name to be displayed. How can i do it?I tried to include two columns FirstName and LastName as below but didn't work.
comHandledBySQt.DisplayMember = "FirstName" + " " + "LastName";
As the title suggests I have a ComboBox and 2 listBoxes on a form. I need to fill the left ListBox with items not now asssociated with the ComboBox selection and the ListBox on the right with items already associated with the ComboBox selection. Is it possible to populate the ComboBox and each ListBox using only one query and returning a dataset of ALL the data to do so, or do I need to Populate the ComboBox, then use 2 queries, one for each ListBox?
View 6 RepliesIs it possible to fill a Combo Box with the names of the fields of a table(from a database)?
View 6 RepliesI have an Access 2007 database and and select data from it using and try to add the items to a combo box on a form.[code]...
View 1 RepliesI have the following query that executes when my form loads. It's the rowsource for my combo box. The query is fine and populates the combo perfect, however, when i click into the combo box I cannot click out of it or even close the form. I have tried taking out the line of code that fills the form via table adapter on load and it works fine (opening the form unbound by the main table). Has anyone run into this before? I have another combo box on the form setup the exact same way and this is not happening. I've experimented with different datatypes etc....
code to populate combo box:
Public Shared Function LoadCallSource() As String
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and Settingsdiw07My DocumentsDaily Backupsphone memo backend.mdb"
[code]....
If I take out the line
Me.MemoTableAdapter.Fill(Me.Table_Memo.Tables("Memo"), intMemoID)
The Combo boxes do not act up or "Lock"
I want to fill the both combobox in this website [URL]
I can fill the main category but I cannot fill the subcategory, I already tried but I cannot.
I would like to fill a textbox with my selected text in combobox. Could you tel me which code I have to add to following code? [Code]
View 3 RepliesOkay so i have set up a database connection and got my combo box to fill from my table but it only fills with the first 4 records even though there are 5. There will be even more records depending on how many bookings are made so i need it to fill with all the records [code]...
View 3 RepliesI am trying to fill a combobox with data from an xml file. I have it setup on form load to call a loadXMLdata function. In the loadXMLdata function it reads the xml file. I would like to know how I would return each of the elements to populate the combobox. I have mostly done php work and in php i could do an array like this: array[book] = "VB.Net Programming". Is there a way to do something like this with an array such as xmlData("Server 1") = "255.255.255.255"
HTML
<config>
<connection>
<servers>
[Code]...
I know there are some things missing in my code like setting the counter integer.
I want to fill a combobox with the values that I have in a datatable. How can I do that? Below is the code for the population of the datatable:
[Code]...
I am creating a form for entering technical data about a part into an Access database. In the same form I have several ComboBoxs that need to have their lists filled from the same reference table in my database. I have a number and unit field for the twist and bending radius properties. I made the unit fields ComboBoxes and I am trying to bind them to referance table in my database called UnitsLength. The relevant structure is as follows....
Form: NewPartForm
Database: CableDataSet
Main Table: PartMechanical - with fields: TwistNom, TwistUnits, BendingRadiusNom, BendingRadiusUnits
Reference Table: UnitsLength - with fields: Unit, Shorthand, Conversion Factor
First tired the following settings....
Data Source: Other Data Sources > NewPartForm List Instances > CableDatase
Display Member: UnitsLength.Shorthand
Value Member: UnitsLength.Unit
SelectedValue: PartMechanicalBindingSource > [The associated unit field]
But the lists didn't populate.... Then I tried these settings
Data Source: UnitsLengthBindingSource
Display Member: Shorthand
Value Member: Unit
SelectedValue: PartMechanicalBindingSource > [The associated unit field]
But now every ComboBox displays the same value but still stores the data in the proper field... it just sets them all the same.
I am having a problem with filling a combobox with unique values.Im not very good at vb either so I will explain what I have done so far.
1. I added a combobox to my form called Combobox1
2. I clicked the little triangle widget thing on the ComboBox1 set the dataset to MyDATASETDataSet1
3. Display Member: CurrencyCountry, Value Member: FCode, Selected Value = None
4. I fill MyDATASETDataSet1 when the form loads using:
PricesTableAdapter.ComboBoxQuery(CurrencY_DATABASEDataSet1.Prices)
ComboBoxQuery =
SELECT DISTINCT [CurrencyCountry], [FCode] FROM [Prices]
The form does not load, i get the error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.If I replace ComboQuery with Fill Query (which is the default fill command) it displays results....but not unique results, i see the same items being repeated throughout the list in the combobox.I guess my questions are:
1. when you fill a dataset do you need to select all the fields when you are creating your query?
2. if i simply wanted to perform the following lookup:
SELECT DISTINCT [CurrencyCountry], [FCode] FROM [Prices]and set the combobox Display Member: CurrencyCountry, Value Member: FCode how would I do this in the code?
3. how can i change my query to display only unique values, distinct doesnt seem to be working?
I'm trying to fill combobox with my SQL query result.[code]...
View 2 Replies