Multiple Combo Box Selection
Jan 7, 2010
I'm new to VB.NET and looking for some help with combo boxes. I was wondering if it is possible to link 2 combo boxes to each other based on user selection? [code]If the user selects Dept Name "Bakery" from the first combo box the second combo box should fill with the appropriate Section Name i.e. "Bread", "Cakes" etc.I am using VS2008 and the DB is SQL Server 2008. Both combo boxes are currently bound to the above Tables and displaying all Dept and Section Names.
View 2 Replies
ADVERTISEMENT
Jan 12, 2012
I've got some code like the following. I want it so that when I chose an item in 'select 1' it changes the in the second combo box but I'm not sure of the best way to go about it. Does it have to be AJax or can it be done with just Javascript?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
[code].....
View 5 Replies
Apr 15, 2012
I have a problem to make a selection by using combo box(cbChoice). if I have 2 item [name], [age], [id_number]. After click SEARCH button, the data from database will display to textbox. this my code but its not work
myCommand = New MySqlCommand("SELECT * FROM daftarpelajar WHERE " & cbChoice.Text & " Like '%" & txtSearch.Text & "%' ORDER by id_pelajar ", conn)
[code].....
View 1 Replies
Jul 8, 2011
The combobox is bound via binding source to a table. How can I display the list of look up options while having the first option say [None} and if selected, clears the value from the list.
View 2 Replies
Oct 4, 2011
I'm trying to select a company name from a data bound combo box, then display the relevant record in a data bound datagridview.
I've currently used the Data Sources wizard to set the connection string, create the dataset and dragged the combo box and datagridview onto my form.[code]...
View 3 Replies
Sep 27, 2010
ok, got a question here, two really. first i'll ask the hard one, as i think i have my other one out of the way so i'll save it for later but i made a program where a user enters in dimensions in several text boxes in inches. there are radio boxes that the user decides what thickness of wood they would like to use. what i'd like to do is add metric into the program and use two combo boxes. one combo box drops down and you can select inches, centimeters, or millimeters. the other one drops down to choose the thickness of the wood.ok now here's my question. say i pick inches in the first combo box, i'd like the second one to display only the thickness of the wood in inches, no metric. if i pick centimeters, i'd like the second combo box to display the thickness of the wood in only centimeters, no millimeters or inches. and the same goes for millimeters.i also have the program on a timer that runs at 100 milliseconds so the user can quickly see the differences in dimensions they put in instead of having to hit the calculate button over and over and over (not sure if that really matters or not, had a couple issues with the boxes earlier but don't think it was timer related now)but is this possible? basically just looking for the kinds of drop boxes that you see on a page like autotrader.com where you select dodge, and then only the dodge cars are listed, select chevy and the chevy cars are listed, etc.
View 7 Replies
Jun 22, 2010
I am currently stuck in one part of my application. I have two combo boxes that i am having the users select from. The first combo box is simply bound to a datatable. that is working properly. The second one i need to populate off another datatable after sorting out what the first one is requesting. Basically it's choosing a line number on the first box and then selecting the machine associated with that line number.[code]...
View 4 Replies
Apr 4, 2009
lets see if I can explain my self. I have 2 fields in the country the country table "CountryName & Countrycoed" . My question is how to display the Contrycoed in a textbox after selecting the country in a combobox. For example if I select Canada in the combo I would like CND to be displayed in the textbox. This is the SQL I have to load the combobox
comType.CommandText = String.Format("select CountryName,Countrycoed from Country ")
View 8 Replies
Apr 23, 2009
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 Replies
Feb 22, 2012
In my below forms, the user select a name from the combo box list and enters an amount for the name selected. The user can enter as many entries. Every time the total button is clicked, I would like the total for each person to be display on the labels.
View 1 Replies
Oct 22, 2011
I am still having issues with the combo box. I have the correct query. I have four tables in MS Access. I need to create a form in Visual Basic that has a combo box and a datagrid. The selection from the combo box will display all relevant information about that person on the datagrid. For example, if I select John Doe (from the combo box) the datagrid should display: [Code] How do I add John Doe to the combo box and link this query to it, when upon being selected, it displays the result in the datagrid?
View 1 Replies
Jul 18, 2011
I have a combo box on few of my vb.net 2010 programs. The end users that use my program have touch screens and they have a hard time making selections on the combo box. I have an Android cell phone and when ever there is a combo box it will open another screen and making the selection is a breeze.
View 1 Replies
Mar 22, 2009
this is the wrong forum because I am quite new to this :S and I am actually unsure what this fits under. I am using Visual Studio 2008 windows form in .vb so I am taking a guess at it being Visual Basic 6.0Well the question is this. On a form I have 3 Datagrids. The first one shows information about a case including client name and ID. The second shows a table that contains all the jobs registered to the company by the clients. lient can have up to 8 Jobs. The third is a list of all case numbers that clients have
View 4 Replies
Mar 19, 2009
How can I remove multiple Item selection from list box ?
Private Sub rf_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rf.Click
If Not (pb.Image Is Nothing) Then
[code].....
View 1 Replies
May 22, 2009
where I want to use the Select All and Deselect All CheckBox. There is no Visual Studio installed there. They want everything in Access. Visual Basic is not installed, it is within the Access interface. Is there a way I can use VB code to have a Select All and Deselect All option. I dont want any code. Just want to know if it is possib
View 1 Replies
Feb 27, 2012
I have a datatable loaded from a database. I bind the datatable to a gridview on page_load. Now I want to filter the gridview by a user selection so I made a checkboxlist and wrote some code as follow at CheckBoxList1_SelectedIndexChanged
[Code]...
With this code above, it can filter if there is only one selection on the checkboxlist. I try to loop the checkboxlist myself but always ended up in errors. Hope someone can help me out to make this work.
View 1 Replies
May 1, 2009
I need to update a link Table with the data I select from multiple grids, the problem is only the last command statement takes effect, therefore I am only updating the link table from the last command statement, is there a way to update the link table with all the command statements?
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aop29.mdb"
Dim objConnection As New OleDb.OleDbConnection(ConnectionString)
[Code].....
View 4 Replies
Feb 19, 2012
I am enrolled in a college course using Visual Basic 2010 Express.My current assignment calls for the following:Create a small program that allows a user to enter the total amount of purchases for the purpose of calculating rewards points based on the purchase totals vs. their membership level of basic, standard and premium.The user selects their membership level via 3 radio buttons, basic, standard or premium.
The total of purchases and their rewards points depend on the membership level. Example, if you are a basic customer and your total purchase is under $75, you receive 5% in rewards points (70 x 0.95). Additionally, if the total is between $75 and $149.99, you receive 7.5% rewards.Here is what I have so far, but I am getting errors on the ElseIf statements:
If basicRadioButton.Checked = True And totalTextBox.Text < 75 Then rewards = total * 0.95
ElseIf basicRadioButton.Checked = True And totalTextBox.Text > 74 AndAlso totalTextBox.Text < 149.99 then rewards = total * 0.925
ElseIf basicRadioButton.Checked = True And totalTextBox.Text > 150 Then rewards = total * 0.9
[code]....
View 5 Replies
Apr 23, 2012
So I have a datagridview being populated with data from a database.At this point a user may or may not selected (via mouse click / key press) one or more rows within the datagridview.I need to (upon selection) create a new dataset, datatable and add rows with the some data from the said datagridview.
For example, if a table had nothing but names, e.g.
Joe
Sean
Larry
Chris
Upon the user clicking, dragging a selection over Sean and Larry to add those names to a new dataset so I can pass it to another method for further processing.
[Code]...
Input array is longer than the number of columns in this table.It looks like I'm either missing a column declaration or adding the table to the set?
View 1 Replies
Mar 4, 2009
How would I display list items from multiple selection listbox in order they are clicked?
View 4 Replies
Jun 8, 2011
I know that title is kinda miss leading, but i couldnt figure out another way to explain it. I know theres a way, but I dont know how to do it.Ive got a Save code that I have about 5 differnet times in my application. How do I make it so that I can just type in something like Do Save, and it locates the save code and follows it through, then returns to where it was.
View 3 Replies
Oct 3, 2011
I have a listbox that allows a user to have multiple selection and a button to transfer these selected items to another listbox, now theres a new requirement which I also need to indicate the quantity for each respective items. I currently have a Source items select box and a Selected items select box. how to go about designing this feature?
Multiple select box selected Quantity
E.g. Eggs ---> Eggs ---> X 4
Vegetables Potato X 5
Potato
View 1 Replies
Jun 1, 2010
A couple of questions about the FolderBrowserDialog in VB .NET Express 2005...
1. How can I make it so this control allows selection of multiple folders at a time?
2. It remembers the folder I selected last time (in the same session), and highlights that folder, which is good, but that selected folder appears near the bottom of the window. Is there a way to make it so the previously selected folder appears in the middle of the window (i.e. the scroll bar is further down the window)? See screen shot attached for how it currently looks when the window opens.
View 2 Replies
Apr 16, 2010
I have a little problem with a little VB.NET application that I am building. This is a winforms applications not WPF.I have a checkedlistbox with a few items and I want to allow user to select more than one using arrows keys or mouse clicks combined with shift and ctrl keys so I set selectionMode property to multiExtended. In design time it is not possible I get an error: It says value property is not valid.and if I set it in runtime by doing:
clbEmployees.SelectionMode = SelectionMode.MultiSimple
I get an error too: It says CheckedListBox is not compatible with multiple selection.
View 1 Replies
Sep 1, 2009
I would like to know how to select multiple records from a gridview, (ie checkboxes in itemtemplate) and process SQL statements on the records. So in short, its basically selecting records from a grid view by ticking the check boxes, and clicking a process button which then proceeds to execute the SQL statements corresponding to the records selected.[URL]..
View 1 Replies
Mar 24, 2012
I have a problem with my combo box. Currently when i select the drop down option I get only one row that is picked from the database. However I would like two Columns to be seen. The Table is [User] with fields - ID, Position, Details.
It currently shows 'Position' However I would like it to drop down with:
______________
ID | Position |
View 8 Replies
May 17, 2011
I have a school project where i have a form that works as a class registration. There is cboGradeLevel and cboCourse and cboNumber. If cboGrade level is freshman i only want the numbers that start with 1 in cboName to be displayed, sophomore =2, junior =3, senior =3. Then i want cboCourse to work the same for the second number in cboNumber. english=1, history=2, math=3, science=4. So if freshman and history were selected i only want the numbers that start with 12- to be displayed. What can I use to make this happen?
View 2 Replies
May 13, 2011
I am very new to VB 2010 and SQL This is my first project.
Have multiple combo boxes that can use the same dataset.
The issue I have is that when I select data in one combo box the other combo box will change to what i selected fo rthe first box and visa-versa.
The only way I found around this is to create a new dataset for each combo box.
View 8 Replies
Jun 5, 2012
Is it possible to show multiple columns and headers inside of a combo box/dropdown list in asp.net and show related columns values, for an example, if I click on a country name then it should show me all the cities for that country and clicking on city name should show me all the related places.
[Code]...
View 2 Replies
May 3, 2012
First i am pretty new to coding and everything so yeah...I wish to make a distance and fuel calculator as my project. Included will be multiple combo boxes with different sets of information (The manufacturer of the vehicle, model of vehicle, the vehicles fuel use per 100Km, its transmission type, users choice of where they will depart from and arrive etc.) Is it possible to achieve this without using a lot of combo boxes? I've experimented using if statements for example:
if combobox1.selected item = "Holden" then
combobox2.visible = true (it's bad i know)
Then from this they would choose their model type in another combo box and then choose their transmission type etc..I don't want to use this because then it will mean i will have to do it for each and every combo box for each and every different set of data because making one 'visible = true' i will have to make the other 'visible = false' and this will cause problems when i start adding a lot onto it.
View 11 Replies
