[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 2 comboboxes, textbox and a cmdbutton. When the user makes a selection in one combobox I want it to filter the choices in the second combobox. Then when the user clicks the button it passes the values from the comboboxes to a stored procedure and populates a datagridview. I am using VB.net 2005 and sql server 2005.
View 1 RepliesI have a combox with a bunch of choices already populated.
View 3 RepliesI want to get all items from one column of database table to the combobox items.
View 2 RepliesI have 22 item in combobox which i want place in one table. Why the code below do not work? [Code] I try learn database program but the code add first combobox item 22 times! What wrong with concept I use?
View 6 RepliesI have two table called
1.Register product table
2.Sell product table
Register product table consist of (Product Id (txtProdId.text) and Product Name(txtProdName.text)) NB. All are textboxes Sell product table consist of (Product Name(cboProdName.text) and ProdPrice (txtProdCost.text)). NB. ProductName over here is a combobox.
When someone saves record in the Register product table, items should be added into the combobox into Sell product table.
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]...
When i use the code below to delete an item from a comboox, the text of the combobox deletes but the item still exists in the list
View 7 RepliesIm planing to make a little radio application for my own use,I want a Combobox with list of items and a URLs binded to them.for example i got 3 items in the combobox:
Radio1
Radio2
Radio3
I want it to be like when im choosing the "Radio1" and press my Play button ( AxWindowsMediaPlayer2.Ctlcontrols.play() ), the 1.1.1.1/Radio1.asx will open.
I'm trying to create a Combobox List and I created the following my first try:
Private Sub ComboBox1_DropButtonClick()
ComboBox1.List = Array("LI-3:comparing and contrasting two or more print sources based on
[code].....
I am new to vb.net and I am using visual studio 2010. I have two comboboxes on a form, each combobox is set to DropDownList so that a list of items can show in the combobox, but no text is allowed to be entered.
For combobox A, if user chooses item 1, the list of combobox B should be updated accordingly. I think this is quite common on a lot of applications. But I do not know to implement it. I even do not know the keyword to search for the relevant property or event handler.
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 added a few items in the combobox dropdown list at the form load event. [code] At the runtime I dont want to allow the user to write something in the combobox as a text.The user can only select an item from the dropdown list of the combobox.
View 13 RepliesI need to load a list of tables and linked tables in an MS Access Database into a combo box. I have this.
vb.net Imports System.Data.OleDb
[Code]...
1. How do I load the access tables and the link tables into my combo without the system tables showing up?
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
View 3 Repliesi have a combobox on the form and a datagrid viewer .no i want to display the table which selected on combo box..
View 1 RepliesI 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]...
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.
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 Replies