I am currently using the NorthWindDataSet from the msdn tutorials.So far, here is what I have to populate one of the listboxes on my form:[code] I make a selection in ListBox2 I would like ListBox3 on my form to be populated with that particular person's Order #'s.
View 2 Replies
I'm curently trying to get information displayed in a listbox from a selection made in a datagridview. For example a user selects an artist from the treeview control and it displays all the albums by that artist in the datagridview. Once a user selects an album all information for that album is displayed below the datagridview in either a listbox or listview control. I've tried dragging the conrols from the datasource and it' won't drag onto the listbox. What do I need to do to get it so that it will display album, artist and track information?
View 9 RepliesI am currently pulling data from a database into a comboBox. My intent is to have the description of the selected option in the comboBox displayed in a listbox. How to i get this data to be displayed in a listbox?
Here is the code that I have so far:-
Imports
System.Data.SqlClient
Imports
[code]....
Can you populate a Listbox and not have a default item selected?(Usually I see the first item in the list automatically selected at creation).
View 5 RepliesIf I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ListBox1.Visible = False
ListBox1.IntegralHeight = True
[CODE]...
I have a listbox (20 Items) with multiselection and label that disply the selection and one button. So I wrote (it works fine)
[code]...
Now when I click on button the label show lets say Item2,Item5,Item10,How do I take off the last ","
somthing like that Item2,Item5,Item10
I used to do: Dim s As String = Trim(Label1.Text)Label1.Text = s.Substring(0, s.Length - 1) but it give me an error converting intiger to string
I have a relatively simple application that uses a series of combo boxes to ask questions. These combo boxes are bound to a table with 2 columns in it "RSN" and "RSN_ID". I'm using one table adapter to feed the form (and these boxes) once the main form is loaded. The problem I'm having is when I change one of the boxes, they all change to the same value, almost like they have the exact data source (which they do) but shouldn't you be able to make different selections even using the same table adapter? I have to run 20 queries at loadtime, or create 20 table adapters.
My current setup is like this:
Data Source: table that feeds the combobox
Display Member: RSN (from combo box table)
Value Member: RSN_ID(from combo box table)
Selected Value: Form's main binding source, unique to each combo box, where the selection is actually saved.
This works perfect when using one combobox, but as soon as I bound all of them I ran across this...
I am trying to create a dynamic dropdown after a dropdown has been selested (in asp.net vb)
For example: I have a dropdown question that asks: What brand of car do you drive (Toyota, Ford, Honda, Nissan, Chevrolet)
When the brand is selected I want another dropdown to appear under it with new chocies
For example: If Nissan is chosen, the second dropdown will be populated (from the database) with (Altima, Maxima, etc...)
And in some cases I would like a text box to appear, but If I can figure out the dropdown portion, I am sure I can figure out the textbox.
I have a DGV with a CB column in VS2008. I would like an event when a DGVCB selection is made (without leaving the cell). It will probably have to be a DGV cell or row event but I can't find one that fires as soon as a DGVCB selection is made.
View 3 RepliesI am currently stuck in one part of my application. I have two combo boxes that i am having the users select from. The first combo box is simply bound to a datatable. that is working properly. The second one i need to populate off another datatable after sorting out what the first one is requesting. Basically it's choosing a line number on the first box and then selecting the machine associated with that line number.[code]...
View 4 RepliesHow can i bind a comobox selection to a datagridview without writting code...
i Need to select an item from a combox and based on that item refresh the datagrdiview. I did something like that in Access but i don't know how to make it work in visual studio 2008.
once i select the datagridview itme that i want to edit i'd like to be able to update back to the database. I know i need to write code for this but at least i'll have the data refreshed on the datagridview.
I have a web page where I am trying to populate the PSI # into the txtPSI depending on which customer is selected in ddlCustomers.I have written it a way it has worked on a past project and it compiles with no errors, however it doesn't work when it runs.
The code adder is not working so I had to add it manually.
Protected
Sub ddlCustomers_SelectedIndexChanged(ByVal
sender As
[code]....
May i have a working sample on how to retrieve records from a DB & populate the relevant textboxes after a selection at a dropdownlist. What i have is definitely not working & im working on VS 2008. Can anyone show me the way?
[Code]...
I need to populate a combobox using the selected value in another combo. The coding that i use doesn't produce the required output. i have an excel sheet with columns called "BaseStation" & "SectorID". Combobox2 must display the related sector id with respect to the selected BaseStation[code]...
View 1 RepliesI'm new to programming and I'm using vb.net 2010 and I'm stuck with this problem. So here are the details, I have 2 tables in my database, a product table and a category table. In my product table I have product no, product description and category no. In the category table i have category no and category desciption. So this is where Ive been stuck for the entire day, I want my combox(product) to populate based on what is in the combobox(category). For example I have "Chair" in my combobox(category), then what would appear in the combobox(product) would be "sofas", "dining chair" etc.'the part below is where the program will read the category description from my database
Sub fillcomboDesc()
Dim fillcatDesc As MySqlCommand = New MySqlCommand("Select catDesc from category;", connection)
[code]....
I have four comboboxes in my Ist form related to course as.c_type,c_stream,c_major,c_nature.......combobox c_type contains the type of courses like degree,diploma, PG etc,similarly "c_stream" contains stream like engg,medical etc. further c_major contains all courses like computer engg(CE),mechnical(ME), physiotherapy etc. and last c_nature has course nature whether regular or private or distance.Now situation is when i select diploma from c_type, corresponding options must be populate in c_stream like engg. And now when i select engg., CE or ME must be there in c_major combobox .Same is for C_nature.The all 4 combobox must show "please select" text on form load event..i also have 2nd form where i have same combobxs. so is there any way to call the same code without again writing that to 2nd form.
View 1 RepliesI have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
Private Sub frmLocation_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn.Open()
[Code] .....
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
Working on a project that contains a listView (populated from a database already) and several textboxes. What I am trying to do, and cannot figure out, is to program this so that when a user makes a selection in the listview, it hits a specific database, and based on certain values within that databse, the textboxes are populated with things such as name and address, etc..
View 2 Replieshow to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
[Code]...
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
I have a listbox and i populate it with data in my code like this on the page load....
[code]...
So say one item in the list is displayed Ted Jones (123) and its valuefield should be 123. Im just not understanding what i am doing wrong here.
I have a midterm project where we must replicate what our teacher has made, it is a convenience store program. I am having trouble calling the functions, he wants us to use these:
PopulateItems => Populate Items listbox based on the category selected
GetItemPrice => Retrieve the price for a given item
GetItemPriceFromPurchases => Retrieve the item price from the purchases list box (optional. You may not need
[CODE]...
So far I have the first list box populated when the form loads. However outside of that I do not know where to call the function in order to populate the second list box upon selection of the first.
I have a product table with ProductId,ProductName,ProductCode as fields. I've populated a combobox with productnames. Next I have two other tables called Result_Header and Result_Detail. The Result_Header table has ProductId as a foreign key and BatchNo,TestDate etc. The Result_Detail table has ResultId as a foreign key which is the ResultHeaders Primary Key and other fields such as Result,SpecHi etc. What I need is when I select a Product from my combobox my two datagridviews must be populated via the Result_header and Result_detail tables respectively.
View 20 RepliesVisual Basic 2010 Express: I have a form with a combobox that is populated with the names of locations from a datagrid which in turn was imported at run-time (Form_Load) from an Excel database. The Excel database (and the datagrid) also stores the information for addresses and phone numbers for their respective locations.
What I would like to do is have the phone number and address text boxes automatically be updated with the proper corresponding data when the user selects a location from the combobox. Whether the text boxes are updated from the datagrid or Excel database is not a concern; I'm mainly looking for whichever way is simpler.
I am a new student of Visual Basic. I am using Vis. Studio 2010. Is there some sample VB code that I can gain access to that shows how to test on multiple selections that were selected within a listbox using the "For each" construct? In this scenario, multiple items have been selected but not 100% of them. I need to know how to test on which ones are selected as I examine each one in the list using the "For each" construct.
View 2 Repliesi made a mp3 music player and i used listbox to let the users see what songs they have added but i want them t be able save and load their song list. How can i do that?
View 11 RepliesIs there any way to limit the listbox selection to just 2 I have done this code
Protected Sub ListBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged
If ListBox1.GetSelectedIndices.Length > 3 Then
[code]....
I have been given the following piece of code which allows a checkbox selection to be made and an associated piece of text be printed in a textbox.
How would i be able to do exactly the same thing but for a listbox?
Also how would i be able to get something to clear from the listbox when then checkbox is unchecked without getting to complicated?
I have a listbox with five items
I am trying to code a button that will randomly choose one of the items and then display in an output textbox
textbox code so far
txtOutput.Text = "The computer has chosen " &
I've been making a scheduling program using the calendar object.I can manage to select any date with a single click with a message box pop up entering a memo for the date selected. After pressing ok, the memo is displayed in a list box, with date.
1.Unfortunately the date is being displayed twice - perhaps because i used .selectedrange in the handler ? i would like it to be listed only once
2. the memo comes up on a separate line, ideally id like it to be displayed on the same line as the date.i tried ListBox1.Items.Add(whendate, memo) but it cant compile, so ive had to put each line in seperately
3. I would like to mark the sundays and national holidays in red color (the calendar is only set for a year so i dont mind doing them by hand, however the only tool i can find in the Monthcalendar1 properties is MonthlyBoldedDates, and no color assignment [code]
I am doing a lab where you have to connect to the database using the Database Configuration Wizard in Visual Basic (Visual Studio 2008). The database connection is there since the form will display the records.The problem is the user is supposed to be able to click on the combobox arrow to select a stock rating (high, low, etc) and then the listbox will display only the stocks with that rating. I thought this would work but nothing is showing up in the listbox.
' strSql is a SQL statement which selects all the fields from the Team database.
Dim strSql As String = "SELECT * FROM Stocks"
'strPath provides the database type and path of the Team database[code]...
