I have created a comboBox1 on an excel sheet with the following statement
Set MyCombo = Shapes.AddFormControl(xlDropDown, Cells(10, 1).Left, Cells(10, 1).Top, 50, Cells(10, 1).RowHeight)
1.Now how to add items to the comboBox1.
2. How to create a comboBox 2 adjacent to comboBox1 when an item is clicked in comboBox1.
I am using VB.NET together with ADO.NET to create a program. I have set my TableAdapters as needed and bound the correct tables-columns to my comboboxes.My problem though is this:My combobox2 item is bound to a datatable. The table adapter's Fill method (the select command basicaly) includes a public variable in the where clause to fetch the correct results. I ll put some code here to clarify it a bit more.Public Class Frm_inv
[Code]...
I want to get all items from one column of database table to the combobox items.
View 2 Replies[Code]...
I'm making a combobox on a form. I want the combobox to have a list of choices from a table in a db. The two columns are a String and a Date. I want the date column to only show the year. I'm hoping I have the code right as it is above, but I'm not positive I've done the whole date thing right.
I have a form in my vb.net application used to take the data about the returned stock. The form contains two comboboxes. One, named combobox5, contains invoice numbers and the other, named combobox3, contains party codes. Both the comboboxes are pre_loaded using sqldataadapter.
Now what i want is to change the party code in combobox3 when the invoice number is changed in combobox5. Elaborating it further, When Stock is issued the party code is stored along with the invoice number to keep track of to which party was the stock issued. Now when stock is returned i want to keep track that which party has returned the stock and i want that the party code should be automatically selected when the invoice number is changed and it should be what is stored in the database against that particular invoice number....
I'm using the following code for doing so:
Private Sub ComboBox5_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox5.SelectedIndexChanged
' defines a new connection to the database
Dim con As New SqlConnection("Data Source=TAHA;Initial Catalog=ADT;Integrated Security=True")
[Code].....
i'm creating a simple search application which have a TEXT box and some combo boxes and radio buttons and a search button.radio button names "Videos", "Audios", "Pics" etc..when radiobutton of video is selected, a combobox is appear having options "DailyMotion", "Metacafe" etc I want that when i click "Metecafe" item in combobox of video, an other combo box appear having items Like "Entertainment", "How To", "+18" etc(categories of video search).
if combobox1.SelectedItem = "PAKISTAN" Then
combobox2.Visible = True
End if
if combobox1.SelectedItem = "INDIA" Then
[code]....
I have a combobox in an app that auto-populate. Some of the items have the same name and so there is the problem: when an item is selected and there is another one w/ the same name , when the combobox is clicked again, the fisrt item with that name is selected, not the one that was clicked.
for example:
there is a combobox with the following items:
aaa
bbb
ccc
ddd
ccc
I open the combobox. I click the last ccc. I open the combobox again and the first ccc is selected, not the last.
or t As Integer = 1 To combortpnumber.Text rtpkoen(t) = New ComboBox How do i get items into the combobox?
View 21 Repliesi using VB.Net to developing my application.in forms i have comobox, in combobox datas are filled by using datasource from process layer.i want '--Select--' is first items in all combobox. but i tried my ways, i cann't bring it.
View 2 RepliesHow to add item in combobox when combobox has a set datasource property?
those combobox is datasource enable.. when it display data from the database but when i add new item i want to those data from datasource is clear and add new items for selection and those are in bold line but it start process to add those item it gives me error "Items collection cannot be modified when the DataSource property is set."
how could i add item to a combobox with an enable datasource property[code]...
In VB.Net for an ASP project I was able to do the following:
Dim Item As ListItem While DataReader.Read Item = New ListItem Item.Text = DataReader.Item("CustomerName").ToString Item.Value = DataReader.Item("CustomerNumber").ToString Me.lstCustomers.Items.Add(Item) End While
However in a VB.Net Windows Project it won't let me duplicate this.
I need to display the CustomerName but return the CustomerNumber of the selected customer
I am also adding the items in code because they are changing based on changing values.
I Need A Code To Add A List Of Items To A Combobox. Every Item Is Listed In One Textbox,
View 7 RepliesI'm in the process of converting an Access 2007 database to vb.net (in visual studio 2010). I want the user to be able to maintain the items in these comboboxes....adding, updating, and deleting any item they choose. In Access, I had a button which would display the combobox items and allow the user to maintain. Upon leaving this display, the combobox would be refreshed. Is this the best practice for vb.net? Would it be any different than what I'm doing now in Access?
View 5 RepliesSo, I've been reading around on the internet and through MSDN trying to find a way to add thousands of items to a combobox without taking 12 seconds.I KNOW, I'm going to incite reflex-responses involving: bad design; use categories and filter; use BeginUpdate ...Here's the thing.I've read through a lot of similiar forum questions as the one I'm asking and none really seemed to answer the question, but these responses are common.The problem is, there is no way to further categorize.I have thousands of customers and each customer can have anywhere from 1 to tens of thousands of designs.The designs have to IDs: DesignID and DesignTitle. The data entry people sometimes have the one and sometimes have the other. If they have the DesignID than all they've got is a number ranging from 1 to (at this time) 60,000. One Customer has 11000 designs. I don't know of any way to further categorize.The reason I use a combobox is for autocomplete. Also, with most customers there are only 10-20 designs, but for some there are thousands.I have to have one practical solution that handles all possibilities.
As far as BeginUpdate or SuspendLayout is concerned, neither have any effect.The sad thing is, the DataSource takes less than a second to load from my DataBase.It's just the setting of the datasource for the combobox that takes so long.It seems to iterate through the entire list once for the bindingsource and then again when I set the DisplayMember.I can set the display member before I set the binding source but that doesn't make any difference in terms of performance.Performance is improved by almost half when I don't use a BindingSource and just set the Combo's DataSource to the List directly, but, sadly, I need to use the bindingSource because there are multiple Combos using the same list.I know WPF uses virtualization for it's combos,.On the internet I found a Technical document on how to implement a Virtual Combobox in C#, but the code was incomplete and I don't really have the time to spend several days creating and debugging something like that.
I'm trying to compare a item i have to enter in a combo box with an item already in the box (duplicating items). I've use the contains function but i need something that is case sensitive. Here is what i have so far
[Code]...
Is there any option to disable particular items in a combobox?? If No then how can i do that??
I have 4 items in Combobox. For each items( based on combobox selected index change) lots of other calculation is there. i need to display all items but in some cases second item should be disabled.
Is it possible to disable some items in a combobox?Depending on the current mode that my application is in, certain items need to be enabled or disabled.I know that I could remove the items and rebuild the combobox but in this case I think that by showing the items greyed out it gives the user feedback as to what mode they are in and what options would be available to them if they decided to switch modes.
View 17 RepliesI want to disable some items in the Combobox. Is there a way to do that ?
View 1 RepliesI'm trying to add three comboboxes DAY, MONTH, YEAR to the student database column DOB.I'm using the
newStudentClass.dob = CType(comboDobYear.SelectedItem & "-" & comboDobMonth.SelectedValue & "-" & comboDobDay.SelectedItem, Date)
newStudentClass.dob is a function that adds the student DOB to the SQL student database.
[code]....
I'm Using Visual Basic 2010, and what I want know is how I can create different list on a single ComboBox. Practically I've 2 ComboBox... the first with a list of Items inside and I want to create a second ComboBox With Different types of list based on the choice of the first ComboBox..
Example: First Combobox with all the continents and the secondo ComboBox With all the Nations, I want that the Nations list of the Second ComboBox change according to the Country selected from the list of the first ComboBox...
I have a datagridview and I have a column combobox. (First column) I want to add item to combobox of datagrid. But I cant get name of it.
View 1 Repliesi want to retrieve all items from combobox...actually i am making a marriage bureau desktop application for that i have made a form named partner search...i have retrieved partner_profile_ids from database to the combobox...and displayed their information of selected profile_id(i.e.selected combobox item) on a form.but there is a next button on form and i want that when i click next button next item i.e. next partner_profile_id in combobox should be selected..
View 1 RepliesI have 2 combobox with different items. Now i need to insert all items from combobox1 to combobox2.
For example:
+ combobox1 has 3 items: item_a, item_b, item_c
+ combobox2 has 2 items: item_1, item_2
Now, i press the button, and the result is:
+ combobox2 has 5 items: item_1, item_2, item_a, item_b, item_c
i have a combobox with a datasource set to a table from a dataset. however i would wish to add more items into the combobox
Private
Class
ComboxItem
[code].....
I tried using this methode to add the same items to 15 comboboxes:
for x as integer=1 to 15
me.controls("missionT" & x.tostring).items.add ("hi")
next
[code].....
I want to update the contents of a combobox in a VB program. So I change the underlying data structure (which is an ArrayList), and according to the documentation in [URL] there's a RefreshList method which should do this. But Visual Studio tells me that there's no such method, and when I type it in manually I get an error saying that RefreshList is not a member of System.Windows.Forms.ComboBox.
[Code]....
On my program I am trying to make so the combo-box's items save after when the user adds something to it. Like if the user closes the program and re-opens it can the items that the user added still be there?
View 5 Repliesi have 6 combobox and all of them have the same items. the items are random numbers. the problem is that i want the user to select a number from the first combobox but i dont want him to select the same number from the second one or the third. I hope you can understand what i mean.
View 3 Repliesin vb 6.0 Dim cnview As New ADODB.connection
Dim rsview As New ADODB.recordset
Call connection(cnview, App.Path & "aa.mdb", "")
Call recordset(rsview, cnview, "SELECT id FROM emp")
With rsview
[Code]...
I am looking to be able to add items to a combox in a gridview at runtime. The only code that I have found is for an editable datagrid combobox not one that items can be added on runtime. Is anyone now of a free datagridview control that does this?
View 3 Replies