Populate Combobox From Selection Of Another Combobox?
Jan 1, 2012
I currently have a form with two comboxes. The first cbo is being populated with a project number, which is being pulled from the first column of a spreadsheet. I now want the second cbo to read the first cbo and then find that project number on the spreadsheet; when it finds that project number, I then need it to copy data from the row the project number is on. I have converted to vb from vba. Below is the code I used in vba (which obviously does not work). I only need certain cells from the project row.
Dim proj_num, rng As Range
Dim data, i As Long, j As Long
With Sheet1
[code].....
View 20 Replies
ADVERTISEMENT
Apr 9, 2012
How can i bind a comobox selection to a datagridview without writting code...
i Need to select an item from a combox and based on that item refresh the datagrdiview. I did something like that in Access but i don't know how to make it work in visual studio 2008.
once i select the datagridview itme that i want to edit i'd like to be able to update back to the database. I know i need to write code for this but at least i'll have the data refreshed on the datagridview.
View 3 Replies
Jan 30, 2012
I need to populate a combobox using the selected value in another combo. The coding that i use doesn't produce the required output. i have an excel sheet with columns called "BaseStation" & "SectorID". Combobox2 must display the related sector id with respect to the selected BaseStation[code]...
View 1 Replies
May 17, 2012
I'm new to programming and I'm using vb.net 2010 and I'm stuck with this problem. So here are the details, I have 2 tables in my database, a product table and a category table. In my product table I have product no, product description and category no. In the category table i have category no and category desciption. So this is where Ive been stuck for the entire day, I want my combox(product) to populate based on what is in the combobox(category). For example I have "Chair" in my combobox(category), then what would appear in the combobox(product) would be "sofas", "dining chair" etc.'the part below is where the program will read the category description from my database
Sub fillcomboDesc()
Dim fillcatDesc As MySqlCommand = New MySqlCommand("Select catDesc from category;", connection)
[code]....
View 2 Replies
Apr 27, 2010
I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
Private Sub frmLocation_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn.Open()
[Code] .....
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
View 14 Replies
Apr 27, 2010
how to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
[Code]...
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
View 4 Replies
Apr 14, 2009
I have a product table with ProductId,ProductName,ProductCode as fields. I've populated a combobox with productnames. Next I have two other tables called Result_Header and Result_Detail. The Result_Header table has ProductId as a foreign key and BatchNo,TestDate etc. The Result_Detail table has ResultId as a foreign key which is the ResultHeaders Primary Key and other fields such as Result,SpecHi etc. What I need is when I select a Product from my combobox my two datagridviews must be populated via the Result_header and Result_detail tables respectively.
View 20 Replies
Nov 29, 2011
Visual Basic 2010 Express: I have a form with a combobox that is populated with the names of locations from a datagrid which in turn was imported at run-time (Form_Load) from an Excel database. The Excel database (and the datagrid) also stores the information for addresses and phone numbers for their respective locations.
What I would like to do is have the phone number and address text boxes automatically be updated with the proper corresponding data when the user selects a location from the combobox. Whether the text boxes are updated from the datagrid or Excel database is not a concern; I'm mainly looking for whichever way is simpler.
View 3 Replies
Mar 27, 2011
Is there a way to update source combobox to printer combobox selection?So going from printer1 to printer2 the source will update according to what that printer has to offer.
View 8 Replies
Jan 27, 2011
I need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 Replies
Feb 22, 2012
I'm having a problem with combo boxes. I usually use Java and it's been awhile since I used VB but I never remember having this much difficulty.My application is using an SDF file. From Data Sources, I drag the details on one of my Tables to my Form to get all of the fields. Three of them are comboboxes. Each of the three is an INT64 and each corresponds to a primary key in a different table. I click the tasks button on a combobox and for data source I select the appropriate table that has the data to go with the combobox, for display member I select the field that I want users to see, and for value member I select the primary key. Then I run a quick test and start the app, open the form, and add a new record. When I select a value from the combobox the selection won't validate because it doesn't think it's an INT64 like it should be. It seems to be using the display member as the actual value instead because if I change display member to the primary everything works great.
View 11 Replies
Jan 15, 2012
I 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]......
View 3 Replies
Jul 29, 2011
I have two ComboBoxes
<ComboBox Name="cmbMake" DisplayMemberPath="MakeName" SelectedValuePath="MakeID"/>
<ComboBox Name="cmbModel" DisplayMemberPath="ModelName"/>
I use LINQ-to-Entities to populate the cmbGroup ComboBox
Dim db as myDataEntity
cmbGroup.ItemsSource = db.Makes
How do I populate my second ComboBox (cmbModels) based on the selection of the first ComboBox (cmbMake) using XAML so that whatever I select in the first ComboBox automatically filters the ItemsSource in the second ComboBox?
View 3 Replies
Aug 15, 2011
i have used the following code to populate a DataGrid based on the contents of a textbox. the users searches for a name which is populated into a combobox based on the name in the combobox several textboxes are populated with data based on the data in one of these text boxes Private bindingSource1 As New BindingSource
[Code]...
View 9 Replies
Jan 28, 2012
I have put all of the items from my Database into a Checkbox Selection, I now want to take the selection that the user makes from the checkbox and turn that into a string that I can then COMPARE through antoehr table.[code]...
View 7 Replies
Mar 26, 2009
Load a combobox with a selection from another?[code]....
View 2 Replies
Jun 18, 2012
Basically, I need a combobox populated by data in a table column that I have created.The user will need to be able to pick more than one option.
For example:
Pizza Topping
+ onion
[code]......
View 3 Replies
Jan 18, 2011
I know this seems like a .Net 101 question but everybody has their own way of programming and I'm curious as to what is the preferred event for checking a ComboBox when a user makes a selection?
View 2 Replies
Mar 7, 2011
Is it possible to have a different selection of values in the 2nd combobox depending what was picked on the first combobox? For example an American state is picked in the first combo box and the second combo box loads the cities in that state? I'm just using a basic form in Visual basic 2010 there is no database behind it.
View 6 Replies
Feb 6, 2012
I have a vb application sitting on an sql server with 4 different tables. I want a scenario where when I select any table from the combobox, every query I will run should use that table as a reference.
E.g. ComboBox values(tables)=A,B,C,D
If A is selected then
SQLQuery="Select * from A "
If B is selected then
SQLQuery="Select * from B " etc
View 3 Replies
Apr 20, 2009
On my form I have three fields and a datagrid view.One field is a combo box.All fields are databound.The datagridview is a detail grid, bound in the "normal" way. Scrolling through records, etc., all work fine.What doesn't work is when a selection is made using the combo box.The underlying table has a self-join of one-to-many: ParentID, ChildID. ChildID is the main ID for the underlying table.Children may have a parent This is just by way of example.So, the combo box's Value is bound to ChildID, and the SelectedValue is bound to the ParentID.On the form one chooses the Parent with this combo box.When I test this arrangement, I select a Parent, then click Save (using the default toolbar actions). However, the combobox seems to "reset" the selection to the first in the list.
View 1 Replies
Jan 22, 2012
I have a ticketing system that reads a MS 2003 MDB. I can easily fill the DataGrid view with all of the items on the data set How ever I need to be able to have agents filter the rows by login(key)
I have a large list
made this way
csrLogin.Add("james", "TomJim")
I select agents on the menu strip and the combo box populates all the names in that collection (combo box displays TomJim in this instance
I have an SQL query made (I think it is correct)
[Code].....
View 2 Replies
Nov 26, 2009
I have a combobox with multiple names. When I select one of the names from the combobox I want to display a value(number) instead of the name itself. How could I do that?
View 3 Replies
Nov 22, 2009
Wanted users to choose two options 1.(tick) 2 blank text so they can write things.
Was thinkin how this can be achieved using a comboBox. ?
View 1 Replies
Sep 18, 2010
I cannot seem to load the saved .rtf document into the richtextbox when i click on that file in a combobox. I checked msdn and tried what it suggested, but got no results.
View 1 Replies
Feb 3, 2009
I have a combo box that has multiple options, when the user selects one of the options (world wide city destinations) a specific value is assigned to a variable. For example if "New York" is selected the variable "x" is assigned the number 155. What I want to do is output the destination that has been selected ie "New York" in a label called "lblOutput1", do I need to store the destination as a seperate variable to be able to produce it in this label as I cannot seem to get it to work:
At the moment I am using:
lblOutput1.Text = "bla bla bla " + cmbDestination.SelectedText + " bla bla bla " + Today()
View 6 Replies
Jun 17, 2010
I have an app I'm working on with multiple forms. One of the forms, frmLocationInfo, has textboxes and comboboxes which are automatically populated based on a combobox selection from a previous form, frmLocations. I've been able to get any changes made to frmLocationInfo's textboxes to save to the SQL database, however, when attempting to select a different item from any of its comboboxes, it's not saving to the database and instead, I receive a "Procedure or function...has too many arguments specified" error.
Here is the code for the Save button:
'Save changes to Locations db
Private Sub btnSaveClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
View 14 Replies
Apr 3, 2010
I have the following constants declared:
Private Const LuxuryRate As Double = 74.84
Private Const FullSizeRate As Double = 48.44
Private Const MidSizeRate As Double = 44.91
Private Const CompactRate As Double = 30.46
And a combobox that lists each option. How can I set an if statement that uses these values if the option is chosen from the combobox? This is going to be part of a calculation performed when the button is pressed.
View 3 Replies
Jan 23, 2012
I have a Win Forms app written in vb.neIn it, I have a combo box with an OwnerDraw Item routineUsing this routine, I am able to implement an application-wide default value for a selection color like shown below:This works great except for one tidbit:ction color again in teh textbox portion of the control
View 5 Replies
Jul 23, 2009
I select first value from a combobox1 but combobox2 was not populated corresponding to value selected from first one. Again I select same value now combobox was populated
View 2 Replies