I need to build a SQL statement.
I have 3 ComboBoxes that i need to use for my SELECT statement. This means that if the user selects ONE of them the SQL statement will be different than when he chooses TWO or THREE.
If none is select, then ALL data is displayed.
I have 5 combo boxes all connected to a database by datasets.
The user should be able to select different items but for some reason when one combobox item is selected, the same item becomes selected for every combobox.
I haven't coded anything regarding the cbx's so why is it doing this?
I have not worked with VB in so long that I might as well be a newb.I know this can be done, and if I remember correctly, it is fairly simple, but for the life of me, I can't remember how.I have a textbox that will be used for entering a number.I have a combobox with a list of precreated options.I need to create the combobox as many times as the number entered in the textbox. Essentially I'm creating a list of items, the number of which is determined by the textbox value, the values of which will be chosen from the comboboxes. This means that the comboboxes all need to be linked as a group with sequential numbering.
View 1 RepliesI am having a problem with the if statement that I created in my code. The condition should be:
- Select Both Comboboxes (1&2) to print out a text in TextBox1
- If only One Combobox or No Combobox was selected, an error message appears and Nothing is printed in TextBox1.
The code I wrote did not function as I wanted. It prints out a text after I select Combobox1 which isn't the way it should be. [code]
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]....
vb
Imports System.Net.WebClientImports System.IO Public Class Form1 Dim link As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
[code].....
I have a project where the dropdowns for the Form and controls (left side) and the events (right side) aren't available. I can re-boot, open and close the project or solution and still they do not show. They do show for other projects.how to make them come back?
View 3 RepliesI have problem with a datagridview with combo boxes firing unwanted events handlers.I have a datagridview with 4 columns all data bound. All of these columns have comboboxes. Column 2,3,4 has a custom generated combobox with code with on the 'DataGridView_EditingControlShowing event' and have event handlers (Dropdown,selected Etc). (Data in the custom generated comboboxes needs to be filtered and worked on)
[Code]...
I have 3 Combo boxes that have number 1-9 in each, i would like to make it so that if the first one is set to 9 then the and the second it set to 8 then the first 1 is set to 1, i need them to only equal 9 through all the boxes?
View 6 RepliesI have a program issue I am trying to work on. I have multiple comboboxes(12 total) on a form.I am attempting to update some settings from what ever the user selects from the combo boxes. I am trying to keep the code as small as possible, so I thought about having all the comboboxes have similar names only different by a number being changed at the end. (ex: cbo_1, cbo_2, cbo_3, etc...)And using a For next loop to advance through each combobox and update the settings as the for next loop advances.(This might be a stupid way of doing it, but its the first idea that came to mind.)
[code]...
I need to select all the comboboxes on a form with a for each loop. I have about 19 comboboxes and I need to select each one. I tried to do
for each box as combobox in me.controls
But that gave me an error and i now tried this:
for each box as control in me.controls
if box.name.contains("ComboBox") then
...
end if
next
That selected only the comboboxes but the problem is i need to access some data that is specific to comboboxes (aka the selected item(s), if its blank) but those properties are not present since "box" is a control, not a combo box.
1) Does this code make text the selected items text? If it doesnt then how would I do that?Dim text As String text = ListBox1.SelectedItem.ToString()
2)How would I make it so that if in combobox.items there is an item with the same text as the listbox selecteditem it is removed? This is what I have and it doesnt work.
If ComboBox3.Items.Item(text) Then
ComboBox3.Items.Remove(text)
End If
I have a ComboBox with several names within it. The names are sourced from a database. Once the user has selected a name from the ComboBox, he must input the no. of hours from another ComboBox and then he is able save it to a .txt file through a streamwriter.
Here is a little image I just put together:I want the file name of the .txt file to be whatever is selected from the first combobox. So, by using the example shown above, the file would be called bob.txt. Is this possible?There shouldn't be any save file dialog or anything, I want it to be automated and the name of the .txt file to be selected from the ComboBox.
I have a combobox on my main form and it lists geographical locations that the user creates. How do I make the combo-boxes on the sub forms match the one on the main form?
View 1 RepliesIs there a simple way to make all comboboxes on a form to be readonly upon form load?
Rather than doing:
ComboBox1.ReadOnly = True
Combobox2.ReadOnly = True
And so on...
This post is a continuation of my other post concerning 'List(of) with multiple comboboxes refill problem.'. I threw the list overboard and began anew with a Dataview.
So far I (finally) managed to get 2 comboboxes (will be more, but if it works for 2...) loaded with the same data using different dataviews (DataView1 & DataView2) so I can select a value from each combobox without the other following the selection.
But now I want to filter out the selected value from the other combobox.
This also works.
The only thing is this: If I select in combobox1 the value 3, and select in combobox2 the value 4, combobox1 will change to the value 2.
If I select in combobox1 the value 2, and select in combobox2 the value 1, combobox1 will change to the value 3.
It works also the other way arround. I can't seem to get my hands around the problem..
Does somehow the index of the items in the combobox play's part? I don't use the selectedIndex, so from my point of view it can't be..
The code I use:
(with the item 0 as 'neutral' option)
Public Class Form1
Dim dTable As New DataTable
[Code].....
I'm trying to make a program in which I can import an excel file, read the whole thing and save it in another format. So far so good: can import the file, read it, skip first line or not etc.But.. Now I've been thinking about a sort option.What if the column order of the excel file is in another order than the export file must be in. In stead of opening the excel file and rearrange the columns manually, I would like to sort it in the program. Just for the sake of trying to make it work and gain experience
So, i read the first line which contains the column names and put them in several comboboxes where I can make a selection. No problem here.Now, the selection of combobox1 has to be removed from the other comboboxes and so on, to avoid double selections on one column. That's where my listOld comes in. Everytime a selection is made in a combobox, a sub is called to create the listOld and create the listNew (which contains items you can still choose from).As I make more selections the listOld gains more items and the ListNew grows shorter.But here comes the part where I'm puzzled.In the part "refill the comboboxes" (bottom part) when I disable "cmb2.Items.Clear()" the listOld (previous selected items) contains all selected items correctly.
[Code]...
I'm trying to make a program that'll play the card game "War". I've started to code the dealing process, but it doesn't seem to be working. I currently have 3 comboboxes on the form each with numbers representing different cards, 1 that contains all the cards to be dealt, 1 that contains the user's cards, and 1 that contains the computer's cards. I plan to just draw random numbers from these comboboxes for the dealing. However, nothing happens when I click the tool-strip button that's supposed to deal the cards. [Code]
View 5 RepliesI want to disallow changes to two comboboxes unless the user first clicks a LOCK symbol on the screen. I pop a Y or N into the tag of the picture box when they click it...I've got this - combobox is called LanguageTo
Private Sub LanguageTo_Enter(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LanguageTo.Enter
If Me.languageLock.Tag.ToString = "Y" Then
MessageBox.Show("Click LOCK symbol to allow changes to the Language Pair!", "Language is Locked!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
[code]....
How do I "cancel" the attempt to change that combobox?I don't want to ENABLE=FALSE the combobox - as I don't want it's image to visually change. I want to allow them to attempt the change and then abort it if they didn't unlock first.
I have two comboboxes the first one is for order #, the second one is for the amount of order payments, there could be 1, 2, 3... payments for this order. I would like to get all payments to show in the second combobox that relate to the order # selected in the first, process that payment by changing other values in other textbox's. Then have that payment psoted as processed back to the DB table. I have a binding satament, but it pulls all payments, and not just per order. How can I get this to select just by order #?
View 2 RepliesI have this code that adds items in 2 comboboxes: The first code works fine as it adds the dates into the comboxes
Dim myConnection As OleDbConnection = New OleDbConnection
Dim myCommand As OleDbCommand = New OleDbCommand
Dim myDataReader As OleDbDataReader
myConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Network_Info.mdb"
[Code] .....
But when I try to add items by month I always get this error in these lines:
ComboBox2.Items.Add(myDataReader("DateRecorded"))
ComboBox3.Items.Add(myDataReader("DateRecorded"))
It says: IndexOutOfRangeException was unhandled
[Code] .....
I have a project in which the comboboxes above the code window, below the tabs have disappeared. If I open and close the project, they do not appear. If I open another project, they do appear. As soon as a open the project where they do not appear, they disappear.
View 5 RepliesI have: [code] So, when I select something from cmbx1 it selected in cmbx2. How does it works?Do I need a copy of dt for second combobox to get independed but same values?
View 1 RepliesMy problem in the Combo Box and SQL query .. I have three comboboxes linked to an Access 2007 database
[Code]...
I've been working on a VB project where I use a 1st drop down list to select a movie category and then in the 2nd drop menu, movies from that category will be displayed. The movies are stored in a 2-dimensional array by category. I've been able to edit my array but I'm having problems with my .AddRange() function. What would I have to put in those parentheses for the list (for each category) to appear in my 2nd combobox when the category is selected?
[code]...
I bind the two comboboxes with table. One combo contains product and another contains subproduct. When I clicked first combobox then subproduct of that is filtered in another combo. When I clicked next,previous, it is working properly. But when I go to last record second combo is refreshed means it is not showing proper subproduct. Given the code on 1st combo_selectedIndexChanged. When I go to last record the SelectedIndexChanged event occur.thats why it is not show me last record proper.
Private Sub frmType_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cmd = New SqlCommand("select makeName from Make where status='Add' or status='Edit'")
dt1 = New DataTable
dt1 = ob.getDataTable(cmd)
cmbMakeName.DataSource = dt1
[Code] ......
i have a datagridview with a column with comboboxes. My problem is that the changes that i am doing from comboboxes didn't occur to datagridview immediately but after the user click to another cell.
View 1 RepliesI have a combo box on a form, it has a large number of values in it (about 40000). When the combo box populates it flickers from invisible to visible for about a second.After investigating this I am sure that it is not the call to the database that is causing this but when the combo is drawn.
View 6 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.