Take The Section Combo Box An Have It Only Display The Sections Out Of The Dataset?
Jul 30, 2009
I have a form that i am using for my ticket software where i am wanting to take the section combo box an have it only display the sections out of my dataset. here is something like i am wanting to do. this is my data table
Section Row No. Seat No.
A A 2
A A 4
A A 6
Then it go to
A B 2
A B 4
I want to have a combo box for each one Section, Row#, Seat# and when I drop down the box for section it will just give me the section and then when I go to the Row# box and drop it down it will give me just the rows in that section and then in the seat box it just gives me the seats in that row.
View 3 Replies
ADVERTISEMENT
Jan 13, 2009
I am trying to create a combo box that would display data from a dataset, and also a 'Please Select' as the first item. I have written the following code which derives from a combo box and it works fine in visual studio 2003 but in 2008 would not display the comboboxtext (which is 'Please select').
Public Class DoubleDataSourceCombo
Inherits ComboBox
Dim myDataTable As DataTable
[Code]....
View 4 Replies
Jul 18, 2011
I am having a problem with a entering sections of text into the same textbox without the other section of text disapearing. In other words, I have several buttons with strings attached to them. When the user presses one of the buttons the string does enter into the textbox. However, when the users presses another button the string from the first button disapears while the second string enters the textbox.
For example: The following code is what I have:
button nine_click
tbxResultSource.Text = CStr(9)
'button plus_click
tbxResultSource.Text = CStr("+")
View 9 Replies
Aug 13, 2009
I am having very odd behaviour from my compiler when i run my program, i have two practically identical snippets of code that are doing pretty much the same thing: both are populating nodes on a treeview using information from the treenode above but when the program runs one of the snippets tells me at runtime that something i have defined is nothing. [code] section and title are columns in a dataset defined by dtName that exists, and the where bit is refering to a column where the entries match the value assigned to volume. which is 1 in the first iteration.
View 2 Replies
Feb 21, 2012
How to use a databound combo box to display one field in the drop down, and another as the combo box text on roll up? Using VS 2005... For example, I have a datatable that has 2 fields. One called "ShortDesc" and one called "LongDesc". I want to be able to see the "LongDesc" column values in the drop down on the combo box. When I make a selection, I want the text in the combo box to read the corresponding "ShortDesc" value.
[Code]...
View 4 Replies
Apr 25, 2011
i want to display a certain section of my form based on the number selected by radio button.( scale 1 to 5) by default 1 is clicked . if they click 5 then the same portion will be repeated 5 times .i have the database table structure to support this . but how to code the radio button to do the same .
View 8 Replies
May 8, 2012
I am new to Visual Basic and I'm trying to make a simple combo box that automatically populates from dataset. The table is from BaseMaterial with the column Material.
View 5 Replies
May 23, 2011
I am trying to fill a combo box using a dataset and data adapt. I am struggling too work out how to do it. I thought it would have been easy but I was wrong. i can set the text to read the first line of the colomn but nothing else. I was wondering if anyone could help me out with what I have to do. I think I have to increment inc and add a line underneath but I don't know how to do that
comboMaps.Text = datSet.Tables("TheLastShot").Rows(inc).Item("Maps")
View 28 Replies
Mar 12, 2009
I'm trying to populate a combo box with a dataset, this sort of works, but everything is just appearing on the same line. I think this answer might be to put the dataset into an array, then put the array into the combo box.
...problem is, I'm not sure how to do this! My code thus far is,
Dim usernameList As Array
'Retrieve usernames where player has available status
GetFilteredData()
[Code].....
View 1 Replies
Dec 11, 2011
I am trying to get my head around datasets, etc. The following code pulls data from an sql server and stores it in a data set. I then set the grid's datasoure to this data set. Now I want to populate a combo box on 'form load' with information from a field (surname) within the authors table.How do I approach this? I can do it in design mode but I want to do it in code as I feel you get a better understanding of what is happening under the hood.
[Code]...
View 14 Replies
Apr 6, 2011
I'm using Visual Basic 2010. I have my dataset in my program. I'm have several combo boxes on the form that I was able to bind the particular table with the information from each table to most of the combo boxes by dragging and dropping them onto the combo boxes. However, one combo box in particular must be populated by code. When a user selects, let's say "a" from one combo box, I need the next combo box to display information in certain tables only, based upon their choices in the previous combo box.
View 2 Replies
May 13, 2011
I am very new to VB 2010 and SQL This is my first project.
Have multiple combo boxes that can use the same dataset.
The issue I have is that when I select data in one combo box the other combo box will change to what i selected fo rthe first box and visa-versa.
The only way I found around this is to create a new dataset for each combo box.
View 8 Replies
Feb 24, 2008
I am writing a school project in VB2005 and am trying to hook up a second combo box that gets its information of what to display from the first combo box. My application is where a student takes a "test" but they can choose what instructor they want in the first combo box. From there, they choose from a test of what each instructor offers in the second combo box. As of right now, my first combo box works great and my second combo box has nothing in it. Just a note, when I debug, it shows my iUserID value as 0.
[Code]...
View 1 Replies
Feb 3, 2012
I am trying to populate a combo list box with the results of a web service. The web service returns a dataset with two columns. I want to display column one to the user and capture column two with the user selection of an item from the combox.right now I can display the first column and capture the selection.Not sure how to add the connection of column two, to the combo box and capture the selection
Code so far....
myDataSet1 = proxy3.listSuppLang()
Dim x As Integer
[code].....
View 1 Replies
Apr 10, 2012
get my Price list, and my Section list to display on two separate?
View 2 Replies
Apr 14, 2009
Visual studio 2005 - vb.net..I have a user control on a form containing 15 combo boxes.All contain Y, N, and blank (for Yes, No, or blank) in the Items Collection property.Each of the combo boxes have a binding source to the same table, different fields.When you select a value Y, N, or blank for any of the fields and do a save, the values save while the application is open.Once you close and reopen, the values are gone.It appears the dataset does not recognize the change, so the values are not getting stored in the database table. Is there something I can do or put in one of the events that would identify this as a change.
View 3 Replies
May 25, 2010
I have a form that queries a database into a dataset then sets textboxes to values from the query. I have a status field I want to be able to control so I created a combo box with typed in values(Active, Inactive, Missing, Broken,Calibration). The purpose of this form is to view the current information on the item and edit if need be. I want to display the current status in the combo box. I can't get the combo box to display the value from the query. How do I do that.
View 6 Replies
Jun 5, 2011
When insert in the first char then it display the related item the combo box
View 9 Replies
Mar 20, 2009
I have a combobox with a list of items in it. Now when the user enters a character I want the combox show the list of items that starts with the specified character.
View 7 Replies
Nov 21, 2011
Sub CboSO_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboSO.DropDown
If functionmode = "UPDATE" Then
[Code].....
View 1 Replies
Feb 18, 2011
let me explain further i have table account. in the table are 2 columns namely account_type,Account_name.So on the forms, i want the combo to show the 2 columns even though ony one column would be saved. Am able to do this in access as attached.[code]...
View 5 Replies
Apr 25, 2012
Make all the buttons code work properly with the help of combo box The combo box will show the category.Suppose there are 2 categories A and B.When we click on A then the code given inside 4 buttons should work.I tried in this way ,I checked the condition of selecteditem based on that added all 4buttons sub code.
[Code]...
View 4 Replies
Nov 22, 2011
Sub CboSO_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboSO.DropDown[code]...
View 1 Replies
May 9, 2011
I'm trying to creat a search form so far ive looked EVERY wher with no luck ive been doing this for a week now ands its really ratteling me that i cant do it.
So i want to populate a combo box with data from my database in access and ive been able to do this ill show the code below, but then i want to be able to click someones name for example "Christopher" and once i click "christopher" i want the textbox's on the form to be filled with the correct information eg address age phone number[code]...
View 12 Replies
Aug 20, 2009
I've used VB to connect to Excel and get the titles of the different columns in a spreadsheet. These then display in a drop down combo box for the user to choose from. I'm getting lots of empty values in my combo box because not all the columns in Excel have titles. How would I go about telling it not to display them?
Excuse the easy question but I've only started learning to code a week ago.
View 9 Replies
Jan 21, 2012
I have been battling with this problem for months with virtually no success.
I am using Visual Studio 2008 Professional. The database is Microsoft SQL 2005.
I have an unbound datagridview with two combo boxes � both bound to database tables. These are:
Combo box 1 is for VAT and is bound to the VAT table. This table has 3 columns configured as shown below[code]...
View 3 Replies
Mar 19, 2010
I have the following bit of code which works find but I have been asked to show for the displayvalue the storecode - storename. How can I do this?
sSQL = "SELECT * FROM ST_STORES WHERE ST_RG_CODE = '" & cboRegion.SelectedValue & "' ORDER BY ST_STORENAME"
sqlDSStoresCombo = rppData.tblGetTableData(sSQL, "ST_STORES")
[Code].....
I think I manually need to add the items but don't know how to add an item that has a value and display.
View 3 Replies
May 2, 2012
I am creating a custom config section that will allow me to manage what ELMAH exceptions I want to ignore from my VB.NET/ASP.NET app. Here's my code. I made it easy to paste in a blank code file if anyone's up to the challenge of diagnosing the problem.
CODE:
When I execute this code:
CODE:
I get the error An error occurred creating the configuration section handler for IgnoredExceptionSection: Could not load file or assembly 'WEB' or one of its dependencies..
What boggles my mind is that this all works fine in my C# console test app after I convert the code from VB.NET using a web utility. However, when I paste the VB code from my web app into my VB.NET console test app, it doesn't work there, either, so it appears to be a C#/VB issue. What am I doing wrong here?
View 1 Replies
Apr 4, 2009
lets see if I can explain my self. I have 2 fields in the country the country table "CountryName & Countrycoed" . My question is how to display the Contrycoed in a textbox after selecting the country in a combobox. For example if I select Canada in the combo I would like CND to be displayed in the textbox. This is the SQL I have to load the combobox
comType.CommandText = String.Format("select CountryName,Countrycoed from Country ")
View 8 Replies
Jan 25, 2011
I need some help displaying the contents of a cell in excel into a combo box. I've been able to display if the contents of excel are numbers but can't seem to figure out how to display text.
View 1 Replies
