I am wondering how to detect that the values in the combobox are the same, as i am doing a application that will show the dates from the combobox. So if there is identical dates in the database, it will show only one date, and when the user clicks on that date which has many entries, it will show all relevant data to that date to a listbox for example.
I have 8 comboBoxes and 8 identical items in each comboBox.If I select one of the items in comboBox1, how can make this item to disappear from all other comboBoxes ?
View 8 Replieshow to compare two list boxes and remove identical values or add them to a 3rd list box, but for some reason it's not working when I retrieve the data from a mySQL database using ADODB, here's my work cut down by a fair bit for it to be easy to understand.
For k As Integer = lstFriends.Items.Count - 1 To 0 Step -1
If lstDBFriends.Items.Contains(lstFriends.Items(k)) Then
lstFriends.Items.RemoveAt(k)
End If
Next
I've tried everything from changing the data type on the mySQL database to storing the retrieved data from the database to String declaration and it simply wont compare the two listboxes
How do I concat combo box data. E.g. value in combo box 1 is "L1" and value in combobox 2 is "03". How do I combine them together into L103? Part of the code looks like this. I am trying to combine two combo box values into one single string and save it in my database. I tried to run the program, but when I click the save button, nothing happen. And I look into my database, no data being added.
Dim strInsert, psID As String
psID = cboLevel.Text & cboLNumber.Text
strInsert = "INSERT INTO
[Code] ....
How Do I show the values from the dataset to the text box based on the selection from the combobox list i already populated the combobox my code is. [code]
View 3 RepliesI am designing a test launch tool that I want the user to be able to select a product type from a list and then choose a station type from another list. Depending on what they choose will determine what is run (what is passed out).
The data will look like the following :
Product Station Test to load Config file to use
10-9890-1 mfgtest1 Progamming.xml config5.conf
10-9890-1 mfgtest2 Configuration.xml config92.conf
[Code].....
I have filled a DVG with information and added another column to index(8) pragmatically Now i want to create a combobox with values depending on values in other cells on the same row so each row will have a combo box with different selections. below i have placed the code and hoped someone would have some input on how to approach this. i have tried datagridviewcolumn but that fills every row with the same information regaurdless of a if statement
[Code]...
I have ComboBoxes and DatagridViews for which I've written code to automatically adjust the width of the ComboBox dropdown list or DataGridView columns depending upon the available space for them and certain conditions.The problem is when a vertical scrollbar appears. I then need to adjust for the width it takes, but am not able to find how to detect this using code.Ive been looking at .ScrollBars, but with this I can only set/get for them to be able to be there or not.
For the ComboBox:
-How can I detect if it has a vertical scrollbar before opening its dropdownlist, if at all possible?
-If not, how do I check using code if it has a vertical scrollbar?
For the DataGridView:
-How do I detect using code if it has a vertical scrollbar
I am creating an xml file with LINQ as follows...
Public Sub CreateXml()
Dim db As New MDataContext
Dim Customers = <gallery columns="3" rows="3">
[code]....
Could i mix local values with the ones returned from the LINQ query...Something like the following?
Public Sub CreateXml(ByVal **Col** As String, ByVal **Row** As String)
Dim db As New MDataContext
Dim Customers = <gallery columns="& **Col** &" rows="& **Row** &">
[code]...
Private Sub AddIngoing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
I was useing VB a lot for some years ago and now I have started again..then, think I was useing VB3 or VB4 there was a property on ComboBox and listboxes that allows only to select the values in the Combox.. Not able to write own values..
View 1 RepliesThis is so confusing, i've been trying all day but it doesn't seem to work.
IN my database i have Vendor tables, i have 2 records
VendorName
a
b
I'm trying to get the comboxbox to get "a" and "b"
[Code]...
I have an XML file, and a ListView control shows the data through aDataGridView control as shown below.Now,This Japanese web site helps me understand how to get cell values.And I'm trying to populate ListBox and ComboBox with the values from ListView's
Column 2.
For j As Integer = 0 To ListView1.Items.Count - 1
ComboBox1.Items.Add(ListView1.Items(j).SubItems(1).Text)
Next j
[code].....
i am developing vb.net windows application. i have a combobox. In that i added items in its properties as follows
<- - - select- - - >
school
hospital
office
others
when i run my application i need to display the selected item as "<- - - select- - - >" but it display empty.....
Im trying to set values for every combox item for example if I have an item name of "currentyear" it should return the year.
View 4 RepliesI want to setup values for a combobox in vb.net through code. But I don't know what's the code for setting it up. I want to do something like this:
if combobox1.selecteditem="1" then
combobox2.values=("x", "y", "z")
end if
I display some values in a combobox that come from an array.By default the selected index of the combobox should be the first item.
If cboAtt.Items.Count = 0 Then
For i = 0 To nums(att)
cboAtt.Items.Add(cat(att)(i))
Next
[code]....
This works perfectly, but now I want the combobox to display the new (initial) value that is swapped, except than when I do that the cboAtt_SelectedIndexChanged event is triggered which results to an infinite loop --> crash.
Is there any way to type a value to comobox which is not on the list of item in the combobox I have tried but it always throws an exception
View 10 RepliesHere is my code.
for example TextBox1.Text= 12,34,45,67,67
Dim process_string As String() = TextBox1.Text.Split(New Char() {","})
Dim process As Integer
[Code]....
i want to add values in reversed order in combobox2 that are available in combobox1
but when i run the application the second combobox remains empty and not showing any value.
When I update but do not really made any changes to the value and press the update button, the data becomes null. And it will seem that I deleted the value.I've taught of a solution, that is to add both combobox1.selectedtext and combobox1.selecteditem to the function. But it doesn't work.
combobox1.selecteditem is working when you try to alter the values when you update. But will save a null value when you don't alter the values using the combobox combobox1.selectedtext will save the data into the database even without altering.But will not save the data if you try to alter it.-And I incorporated both of them, but still only one is performing, and I think it is the one that I added first:
Dim shikai As New Updater
Try
shikai.id = TextBox1.Text
shikai.fname = TextBox2.Text
shikai.mi = TextBox3.Text
[code]....
I'm using ms access 03 to fill a datagridview no problem. I have 4 fields(id, first, last, points), but I just want to fill one in a combobox I have. Here is what I'm using to fill the datagridview:
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsPC #6My Documentsstudent.mdb")
Dim sql As String = "Select first,last,points from student"
Dim oledbAdapter As OleDbDataAdapter
Dim ds As New DataSet
[Code] .....
How could I get a combobox to just display just one field, like idk if I'm explaining myself correctly, like a SQL statement look like this:
Dim sql As String = "Select first from student" but just for my combobox.
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 RepliesMy code is:
sqlsub = "SELECT distinct field1, field2"
sqlsub += " FROM tbl I
Dim da As OleDbDataAdapter
Dim lsdataset As New DataSet
[code].....
My prob is how should I bind the combo with field1+"("+ thpr+ ")" thpr is the string i get from function by passing field value 2 from query my combobox should be displayed as field1 + (thpr).
I want to check if two combobox values are equal. The comboboxes are in a datagridview.I found you need to use datagridview_EditingControlShowing to add a handler to the comobo boxes for selectedindexchanged. I can do this with this code.
Code:
Private Sub dgridRegisters_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles dgridRegisters.EditingControlShowing
Dim combo As ComboBox = CType(e.Control, ComboBox)
[code]....
However, the message box comes up for every combobox in my datagrid when I change the index, not just the cmbPort2. I would like to have something like this...
If cmbPort1.selectedindex == cmbport2.selectedindex then
'do something
endif
..but it doesn't seem possible.
How I could go about checking a typed value in a combo to the values in the combo box. I am making a system to select lockerID and Supplier ID I want the user to be able to enter the value in the combo box as well as select the value form the list in the combo box. Here is the code I have been trying.
If cboStockID.Text = "" And cboStockID.Text <> cboStockID.Items.ToString Then
MsgBox("Please enter Stock ID")
Exit Sub
ElseIf cboSupplierID.Text = "" Then
MsgBox("Please Enter Supplier ID")
Exit Sub
End If
the combox is bound database table,but it is not displaying the contents of table in database,instead it is displaying corresponding null values(blank).it is showing just "select" and the blank spaces corresponding to the number of items in database
here is my
Function combobfill() As DataSet
addconnection.Open()
Dim selectstring As String = "select materialsname from materialtype_table"
[Code]....
I have a form with a number of controls based on those controls and a database i filter what data i want to be in AllowableHeightsCombobox. I am using an Arraylist to hold the data. The problem i am encountering is that after filling allowableHeightsCombobox once, it will not update or change the values in it. this is the only place where i change the AllowableHeightscombox's datasource.
[Code]...
In a VS2008 VB project, I have a combobox that gets its values from a SQL Express table. This table has three columns. I want to display the value from one column in the combobox, and obviously the user will select from this. I want to then write the value of the selected record from a second column back to a different table, and I also want to change the value of a radio button (on the same form as the combobox) based on the value of the third column of the selected record.I'm setting the ComboBox.Text value to be the first column, the ComboBox.SelectedValue to be the second column, but how would I change the radio buttons in the most efficient way? If it was VB6, I'd probably make another trip to the database to find the value of the third column based on the selected value from the combobox. I'm not familiar enough with the tableadapter concept but I suspect I should use them to do what I need.
View 15 RepliesIs possible to have different values of combobox on the multi same form?
Actually I want to make a multi same form, but with one combobox to set the authority. When different persons to use this same form, I will have different selection limited on this combobox,
the code display 2 colunms in one combo box from a table. i have table with 2 columns account_type and account_name. the account_type is an abbreviation(codes) which would be stored in a new table when selected. I want the code when the combo is click, would display the code-account_type and account_name in the same combo box.
Private Sub cboAccount_type_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboAccount_type.SelectedIndexChanged
Dim cn As New SqlConnection(ConnectionString)
Dim query As String = "Select Concat(Account_type, ' - ', Account_Name) As AccountDesc, Account_type from Accounts"
[code]....