Populate Text Box Based On Value Selected On Combobox?
Sep 13, 2011
I have the following code which add items to a combobox in my form:
Public Class Contas_Bancarias Private Sub Contas_Bancarias_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:BDadosBANKREC.accdb;Persist Security Info = False"
[Code]...
View 5 Replies
ADVERTISEMENT
Jul 29, 2011
I have two ComboBoxes
<ComboBox Name="cmbMake" DisplayMemberPath="MakeName" SelectedValuePath="MakeID"/>
<ComboBox Name="cmbModel" DisplayMemberPath="ModelName"/>
I use LINQ-to-Entities to populate the cmbGroup ComboBox
Dim db as myDataEntity
cmbGroup.ItemsSource = db.Makes
How do I populate my second ComboBox (cmbModels) based on the selection of the first ComboBox (cmbMake) using XAML so that whatever I select in the first ComboBox automatically filters the ItemsSource in the second ComboBox?
View 3 Replies
Apr 17, 2009
Have populated a dgv with records from a database. I have created a button >> which needs to transfer all the selected records from dgv to dgv2. Any tips on how to accomplish this ?
[code..]
At this point all is good. Now not sure on how to do next bit.
View 10 Replies
Dec 13, 2010
How do i populate my state combobox,such that when i select the appropriate country my combobox will automatically display the appropriate state?
View 7 Replies
Aug 31, 2011
I have a combobox wich I want to populate based on the value of another combobox.[code
View 2 Replies
May 17, 2012
I'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]....
View 2 Replies
Apr 27, 2010
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
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.
View 14 Replies
Feb 7, 2009
I had a combobox which is generating auto number from DB. i need to get data automatically to the ramain ing textbox , if i select a no from combo.[code]...
View 2 Replies
Apr 27, 2010
how 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.
View 4 Replies
Apr 14, 2009
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 Replies
Nov 29, 2011
Visual 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.
View 3 Replies
May 8, 2011
I have combobox, listbox and textbox. Combobox has datasource datamember values assigned i would like to select a customer from a combobox and save the datarow based on that selected value to an array it could be a list or whatever created in memory as variable and this will be my listview Datasource. I understand within that current row there is ID value which is interger.[code]...
View 4 Replies
Jan 10, 2012
I want to populate the combobox based on the selected item in the first combobox. The following code is written in vb.net 2008
Public Class Form1 Sub fillcombo()
strsql = "select * from device"
Dim cmd As New OleDb.OleDbCommand
cmd.CommandText = strsql
cmd.Connection = con
[Code] .....
For this code I am able to populate the first combobox and when I select the specific item in combobox then the second combobox shows only the first element of that item.
In MS access 2007 I have created 2 tables:
1) Contains the device ex:computer
2) Contains the device and its parts ex: cpu, monitor so here the device has duplicate values
Table names are device and parts.
View 7 Replies
Jun 27, 2010
I am trying to display a record in my datagridview based on the value selected from a combobox. I tried the code below using SQL Management studio and it works perfectly.
[Code]....
View 14 Replies
Feb 2, 2012
i have a databound combobox using VB2010 and MS access as the DB.. When i click on a button, the selected item in the combobox will be deleted from the database and no longer display in the combobox...
View 1 Replies
Aug 15, 2011
I have a form which populates a TextBox I want to use the textBox.text to then load a gridView with the results
[code]...
View 13 Replies
Jun 16, 2011
This task is a little out of my reach so i dont even really know where to start...I want a user to click the command field "select" in my gridview. I then want them to be redirected ( response.redirect()) to an input form that will have its various asp.net text boxes filled with data from that selected item. I also need the ability to do this logical process:
IF the form is loaded from user
selecting item in gridview THEN
''Populate controls with data from selected gridview item Else Load
[code].....
View 1 Replies
Nov 10, 2010
I have the following code to insert a record into the database [code]...
View 6 Replies
Mar 4, 2010
I have 2 tables: locations and depot:[code]I have 2 forms, frm1 and frm2. Frm1 has a combobox, cboLocations which pulls from the Locations table. Frm2 has textboxes which populate based upon the location selected from cboLocations on frm1. Frm2 also has a combobox, cboDepot, which pulls from the Depot table.So far, I've been able to get cboDepot to populate with the first depot_refnbr. This is not the corresponding depot_refnbr that matches with the selected Location; it is just the first depot_refnbr in the Depot table.I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
View 11 Replies
Jun 16, 2011
I got a problem how can i populate the combo box with a list on text file separated by comma. ex: in text file "aaa,1". i want to put the aaa in combobox when selected in aaa in combo box the 1 will go to textbox1.text is this possible?
View 5 Replies
Mar 31, 2012
I have created a simple conversion program, I have two comboBoxes that are populated by a text file called 'data.txt'. It all works perfectly apart from when i have the squared units in it, instead of getting the '�' symbol that is in the text file, i get a diamond shape with a question mark inside.
I would think that you must have to put some sort of code before the squared symbol in the text file, but I cannot figure it out.
HTML
Public Sub DataLoad(ByVal Switch As String)
Dim tfLines() As String = System.IO.File.ReadAllLines("data.txt") ' File to load.
For Each line As String In tfLines ' Load and read all lines in file.
[Code]....
View 10 Replies
May 10, 2011
I want to change the text of two labels based on the the selected row of a gridview.I keep getting an error that says the public member row does not exist on linkbutton
Protected Sub LinkButton1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim LinkButton1 As LinkButton = DirectCast(sender, LinkButton)
Dim tour As Label = CType(sender.Row.FindControl("label2"), Label)
Dim depart As Label = CType(sender.Row.FindControl("label3"), Label)
[code]....
View 1 Replies
Oct 12, 2011
When a SelectedIndex in a ListBox is changed I would like a textbox below the listbox that gives a description to be populated with the value from a description field in SQL.I have the following code so far, but I get an error that says "Must declare the scalar variable "@ReportName"
[code]...
View 1 Replies
Apr 12, 2012
I have a Radio Button List that lists different business categories. The last option is the Other category. When the user selects the Other category, I want to be able to enable a text box that the user can then enter further information to explain the Other selection.[code]...
View 2 Replies
Mar 4, 2010
following issue I'm having:
I have 2 tables: locations and depot:
Locations:
site_refnbr (primary key)
site_name
depot_refnbr(foreign key)
[Code]...
I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
View 19 Replies
May 12, 2010
I'm rewriting a VB6 application in VB.Net. So far I have 2 forms, frmLocations (frm1) and frmLocationInfo (frm2). frmLocations has a combobox, cboLocations, from which a selection is made and an "Ok" button is clicked, which then loads frmLocationInfo. frmLocationInfo has a series of textboxes to display info corresponding to the location that was selected - Location, Location Number, Phone, Fax, Email. There are also 3 comboboxes on frmLocationInfo - cboDepot, cboFreight, and cboDispatcher. I need their text property along with items to be populated, also with data corresponding to the initial selection made on frmLocations. I'll spare you all the difficulties I'm having w/the other comboboxes, and instead focus on cboDepot. I have gotten it to populate its text property to display the corresponding Depot, however, the items are not populating and all you see now when you click on the dropdown arrow is only the depot that shows up in the text property.
Here is the code for this portion.
frmLocationInfo
Private Sub FillDepotCombo()
Dim sql As String = "Select distinct depot.depot_name, depot.depot_refnbr, locations.site from depot inner join locations on depot.depot_refnbr =
[Code]....
View 8 Replies
Sep 20, 2011
I am wondering if it is possible to change the text of certain values in a combobox based on if a value is true in the sql datatable.what i have is a Roles Table with 3 columns RoleID, Role and Role not used.if Role Not used i want it to be displayed in bold.
View 8 Replies
Jan 27, 2011
I need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 Replies
Feb 1, 2010
This is my first web-based application using VB 2008. I had no idea where to start so I just chose the 'Wpf Browser Application' and started adding the controls on the form and naming them the same as I would do with a normal non-web-based vb app. I ran the XBAB file under bin/debug using IE and the form showed up but I couldn't enter text or anything even though the textbox was set to enabled?
View 7 Replies
Oct 27, 2010
I have a combobox with whose contents get populated via code. Works ok. But When I select something in the list and hit 'OK' it always returns as: nothing, "", or -1 (tried with .selectedValue, .SelectedText, and .SelectedIndex respectively)
Question is, How do you access the text in a ComboBox's selected Value??
View 3 Replies