How I can populate a combobox (combobox2) based on the selection made from another combobox (combobox1)? They are on different forms. Combobox1 lists locations, while combobox2 lists offices for each location. I would like it to work so that when the user clicks on combobox1 and makes a selection, the 2nd form loads with combobox2 showing all the offices for the selected location.
View 6 Replieshow you populate cascading comboboxes? I have one combobox on one form, from which I'm trying to populate another combobox on another form. The first combobox contains Locations while the second combobox contains offices for whichever location is selected in the first combobox. I would like it to work as follows: user clicks on first combobox to select a location, and then the second combobox lists all the offices for that location.As of right now, the second combobox is just displaying the first office that is in the first record for the respective database table it is pulling from.
View 2 RepliesI have two comboboxes say
DDL 1 : Artist
DDL 2: Albums
And a Gridview containing (album name, artist name, no.of tracks, year, etc), What I want to achieve is: when an option(artist1) in DDL1 is chosen, then the albums related to DDL1 needs to display in DDL2 and also it must update the appropriate values in the gridview (artistname, albums(album name -no of songs, year)etc... based on the selection made (language: Asp.net(VB)-Sql server ).
1. A dataset contaning all the tables, views and stored procedures from a db in the Data Sources
2. A stored procedure that makes a query using a parameter
3. 2 comboboxes with their DataSources defined
The first combobox gets populated with a stored procedure (with no params, through the Combobox task). When the user selects an item from this combobox this should trigger an event that populates the second combobox with the second stored procedure that requires a parameter.
Since the Dataset is already add to the Data Sources and contains all the procedures I need, I don't wanna to create more datasets or calls to the data base, however I don't know how to set the query using the procedure I already have passing the parameter.
I have the EXACT same code on another form and it works great, on this form though it is giving me this when loading that is happening when trying to populate the cboItemCode and cboLinePart combo boxes based on what is selected in cboLine (which will be the initial load value)[code]It is happening, I guess on that CInt( in the sql, but why?I don't understand why it is considering cboLine.Selected value as a "DataTypeRow" when it is just looking at the value member? If I remove the CInt() for the cboLine.SelectedValue it will give another error saying "Operator '&' is not a defined for "SELECT LinePartID, LinePartName," and type 'DataRowView'.[code]
View 3 RepliesI have a DataSet with a DataTable that has several numeric columns of Data. The numeric data is composed of distances given in U.S. Standard units. I currently have my ComboBoxes set up and working, but I need to expand on what I currently have in two ways.I need to be able to convert the Decimal numbers in my data column being displayed to Fractions, is there a way to do this and maintain databinding? In this case its the Display Member of the data source...I need to be able to display my drop down options in different sets of units... I've written Unit Conversion classes to help take care of this, but I don't know if I can somehow do this as well and maintain databinding? I'd like to convert the units on the display members as well...
Private Sub ComboBox1_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ComboBox1.SelectionChangeCommitted
Select Case ComboBox1.SelectedItem
[code]....
What is the best approach for using ComboBoxes when dealing with issues such as displaying fractions and units...
I have a master page called SampleMaster.master and this page contains a Repeater control
The Repeater control will be used to display the relevant tags associated with each content page and the tags will vary between content pages
The data extraction method Tags.GetTags() is working but I do not know the best approach to populate the Repeater control in the master page dependent on what the content page is.
Would the code reside in the masterpage page code behind or the content page code behind?
I am writing a mdi app (vb 2008 express) where i want the child forms to start in the same position i.e. on top of each other. Currently the forms are casacading. I know you can set the default mdi layout in the mdiParent using [code]....
View 2 RepliesI have the following class. Basically, i want to populate a bunch of comboboxes. So i want to return an Id and description column almost all the time.
Public Class combodata
Private _id As Long
Private _description As String
[Code]....
how can I return the items as an array. Is converting to an array the best way? I will need to populate a combobox with the returned result
I have 3 comboboxes and want to populate each from XML. What is the best way to do this?Here is the XML:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<root>
<combobox name="cbScreenResolution">
[code]....
I am trying to move over vb6 code that worked through arrays of comboboxes.I have a panel that has 18 comboboxes that each need to be populated the same.I first clear the combo boxes and it loops through them, but keeps going until it gets an error.Likewise on sFillLotNO, it adds the first foundrow to each but bombs out when it tries to get the 19th.[code]
View 2 RepliesI have a form that lists all of the clients in a DataGridView and when I click on a column that is a Link I want the data to populate into the form I use to capture. My problem is that when I click on the link all the TextBoxes on the form are filled correctly but my ComboBoxes are not.[code]
View 1 RepliesI am developing a Windows application in Visual Studio 2005, V2.0 using VB.NET. I am coding part of an Emergency Response Information System. On my form, I have two combo boxes (cboBaseStationID and cboPriority). I am trying to populate the datagrid with records from my database based on what is selected in both comboboxes.
For the first combobox, the user selects a name so the datagrid must only show records with that name. For the second combobox, this is a little more complicated. There are four emergency priorities in the combobox that the user can choose - 1, 2, 3, 4. In the database, there are different response teams (to be dispatched to these emergencies) and each response team has a grade of either 1, 2 or 3. [Code]
I have four comboboxes in my Ist form related to course as.c_type,c_stream,c_major,c_nature.......combobox c_type contains the type of courses like degree,diploma, PG etc,similarly "c_stream" contains stream like engg,medical etc. further c_major contains all courses like computer engg(CE),mechnical(ME), physiotherapy etc. and last c_nature has course nature whether regular or private or distance.Now situation is when i select diploma from c_type, corresponding options must be populate in c_stream like engg. And now when i select engg., CE or ME must be there in c_major combobox .Same is for C_nature.The all 4 combobox must show "please select" text on form load event..i also have 2nd form where i have same combobxs. so is there any way to call the same code without again writing that to 2nd form.
View 1 RepliesI have been setting DataSource for a series of combo boxes to the same table as they all display the same options. However, when I ran the project, any change in any one combo box makes all the others 'flip' to the same selected value. This is obviously wrong.
In Access, you have 'Control Source' which is the db field that is bound to the combo box and 'Row Source' can be a query or whatnot that several combo boxes can run 'independently'.Is there an equivalent option in VB.NET? I DO NOT want to manually enter the exact same options many times as that is hard to maintain, to say the least.
Just to repeat: it is not going to work to say DataSource = Row Source. if two combo boxes are set to the same data source, a selection in one automatically makes the other one select the same value. unless, of course, i am missing something.
I have three comboboxes in a form. The first is the parent of the second, which is the parent of the third. When they are all updated, a datagridview should be updated.
The problem is that the user can choose to change the value of either combobox, so I don't know which combobox's value is being changed. Therefore I now update the datagridview from the third combobox's selectedvaluechanged event. This unfortunately means that if the first combobox is changed, the second and third comboboxes selectedvalue events must trigger. As a consequence, when the first combobox is changed, the datagridview is being updated about six times (which doesn't work for me performancewise).
What I'd like to do is to call the updatedatagridview sub from either one of the three comboboxes, but only if the user has chosen to change that specific combobox's value (that is, get the form to only update the datagridview when the selectedvalues of all three comboboxes have been set).
so yesterday this code was working for my userforms and today its not. Its a simple clear command for textboxes and comboboxes. what is from here?
Dim ctl As Control
ForEach ctl In Controls
IfTypeOf ctl Is TextBox Then ctl.Text = ""
IfTypeOf ctl Is ComboBox Then ctl.Text = ""
Next ctl
I'm trying to detect when the tab key was pressed and intercept it in certain cases. Since the form I'm working with has many fields, I've tried overriding ProcessTabKey so that I don't have a separate sub for each control. However, I've found that after adding a simple ProcessTabKey method, each time I press tab it skips one of the combo boxes. In order to duplicate the situation, using Visual Basic Express 2008, create a new Windows Forms project and add 5 combo boxes to the form - allowing each to automatically get an incrementing TabIndex.
Then add the following code the form:
Public Class Form1
Protected Overrides Function ProcessTabKey(ByVal forward As Boolean) As Boolean
MyBase.ProcessTabKey(forward)
End Function
End Class
Now when you run the project, you'll see that each time you press tab it skips one of the combos.
I have a windows form on which there is a textbox and a command button. When user inputs an integer in the textbox and clicks on the button, the userform grows and adds that many number of comboboxes and textboxes in a panel.
how to add variable number of comboboxes and textboxes at run time.
The maximum value of that integer would be 10.
this is a subset of a previously posted problem, I have narrowed down my issue and am reposting a question from this thread: [URL] I have apparently confused the compiler by renaming some comboboxes in Visual Basic .net express? (See relevant code below) I think the confusion is in who should handle what, with two routines named with variations of ComboBox1 and one handling the other ( it confuses me just trying to interpret it mentally):
[Code]...
I have a form with 4 comboboxes and a button. The first combobox is enabled, but the rest of the controls are disabled. When the form is opened I fill the first combobox (cbxMethod) with a datatable. When the user selects something in cbxMethod the next combobox (cbxStudy) will be filled and so on. When the last combobox (cbxAnalyte) has a selected value I want to enable the button and give it focus so the user can move forward with the program. I basically want to force the user to move from one combobox to the other, until all are filled.I am currently using the SelectionValueChange event, but this event only fires when the user changes the value with their mouse or hits the Enter key, not when the user hits the Tab key.
Public Class frmCalculatedAnalyte
Private cv_dt As New DataTable
Public Sub New()
[code]....
I am trying to populate an array from a listbox.My listbox items contain something like this:
1 for January
10 for February
3 for March
I have code in place and it was working, but I am taking the first character of the listbox item to populate the array. If the value of the listbox is 10 for February, I need to get 10, not just 1. Can I do something with the string that says I want to trim everything from the space to the end? Since they are all formatted the same way, if I could trim out anything from the space on, that would work.
Here's what I currently have:
ReDim m_adecRainfall(m_astrMonths.Length - 1)
For intCount = 0 To m_astrMonths.Length - 1
m_adecRainfall(intCount) = CDec(lstMontlyRainfall.Items(intStart).ToString.Su bstring(0, 1))
intStart += 1
Next
I have a winform that has one combobox. I want to populate that it with a list of folders in a directory. I thought this might be a common thing but I have not found any thing concerning this. For this example lets say the root folder is C:TestingFolder List
[Code]...
I have two dropdown within a DetailsView and I want to work in cascade, the idea is that an area contains various issues and these issues depend on the selected area, but I get the following error: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
[Code]....
I am trying to have cascading comboboxes within a datagridview.I have it partially working. dataset1 has 2 tables, with a parent-child relation built inDatagridview1 contains:column 1: combobox, bound to bindingsource 1 which is bound to dataset1column 2: combobox, bound to bindingsource 2 which is bound to bindingsource 1when column 1 is selected, column 2 choices are limited to those related to column 1however, if column 2 is chosen in a row that previously had data, and was loaded with the form, then its choices stay the same as the last row where column 1 was physically selected before column 2.I seem to need to refresh the binding source somehow to emulate how it works if I was to go into column 1 and make a selection by hand.H
View 1 Repliesfollowing issue I'm having:
I have 2 tables: locations and depot:
Locations:
site_refnbr (primary key)
site_name
depot_refnbr(foreign key)
[Code]...
I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
I have been practicing with the online tutorial on how to do this except my dropdownlist just gets a "method error 500" in the dropdownlist.
View 1 Replieshow 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.
I Need a working example of a cascading drop down list box written in vb.net for my ASP.Net MVC application. I tried converting three examples written in C# but can't seem to figure it out and I have given up.This is my first .net application so I'm a newbie. The biggest problem I'm having is just don't understand the java script code in the views.
View 3 RepliesI have two cascading dropdown lists I'm attempting to bind to two separate SqlDataSources each.
These dropdownlists exist in a FormView's EditItemTemplate. Inside the EditItemTemplate two sqldatasource controls exist that populate the department and the jobname. The DeptID and the JobID are the primary keys in those tables. This creates the "cascading effect" between departments and jobs. When a department is selected, only the jobs associated with that department appear.
This piece is working properly.
<asp:FormView ID="frmProfile" runat="server" DataSourceID="sqlDSProfile"
DataKeyNames="EUID" style="margin-top: 0px">
<EditItemTemplate>
[Code].....