Populating Textboxes Based On A Combobox Selection Using A Datareader?
Mar 26, 2012
I have a database with table "Customer" that will be the datasource for my form controls. My form has a combobox and various textboxes that need to change based on the selectedvalue in the combobox, cboCustNo. Firstly, I'm try to get the combobox to populate with the customer names on the table but have the value member of the combobox set to their customer numbers (just for ease of indexing). Based on the user's selection I'm trying to have various textboxes show the corresponding data (Address, City, Balance, etc.). The code I have so far is below:
Dim cnnDB As New Data.OleDb.OleDbConnection
Dim cmdSelect As New OleDb.OleDbCommand
Dim rdCustomer As OleDb.OleDbDataReader
Dim CustTable As New DataTable
[Code]....
View 3 Replies
ADVERTISEMENT
Jan 8, 2010
I'm trying to populate textboxes on one form based on a selection on a combobox on another form. All data will be pulling from the same SQL table. I've got the combox to work fine to show the correct data in one of the textboxes by using the lines:
Dim connectionString As String = "Data Source=F03D3S-DEV01; Initial Catalog=dos_track;" _
& "Integrated Security=True"
[Code].....
,but not sure how to get the other textboxes to fill with the correct data (from the same SQL table row) associated with the combobox selection. I've spent SO MUCH time on this trying to figure it out, but am getting nowhere fast...
View 4 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
Feb 7, 2012
I have a form with a DataGridView and ComboBox, both of which are populated with data from an Excel spreadsheet, the source is unbound. My problem is in repopulating the DataGridView with data from another worksheet in the same Excel file when the user selects the corresponding value from the ComboBox. For example if they were to select January from the ComboBox then the DataGridView would load in and display the data contained on say Sheet2, selecting February would load Sheet 3 and so on. I am running Visual Studio 2008.
View 6 Replies
Feb 20, 2011
in my windows form i have 2 combobox. populating combobox2 according to selection of combo1. combo1 i am binding on formload.
[Code]...
View 3 Replies
Feb 23, 2012
assist in the proper way to populate a value in a txtbox based on a combobox selection? I basically have a table (tblStudent) that has two fields (Range, Amt). The range records are 1-5,6-10,11-20,21-50, >50. Amt are 0 by default.
four more Tables
(tblPA,tblNY,tblNJ,tbMD) with 2 fields (pctgStud,amount) where prctgStud are
ranges (0, 1-10,11-25,26-50,51-100). Amount are 0 by default.
My form has a 5 simple comboBoxes that allows one of the ranges to be selected for each of them. I also have 5 txtBox relating to the corresponding (Amt) fields. How do I populate the textboxes with the related AMT based on the range selected from the comboBox. On a side note, I want to ultimately increment all the textbox values by one in the tables when submit is clicked.
View 10 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
Jan 31, 2009
I have VS2005, Microsoft Access 2003
ComboA is binded to the Customerstbl and displays the CustomerNames. ComboB is Binded to the CustomerContactstbl for the selected customer above and displays all Contacts for that customer is a second cbobox.
I am having a hell of a time with this, When I select a customers name in ComboA, I want ComboB to automattically query the contacts in ComboB based on ComboA's selection. where do I create the query for getting the contacts for that customer?
In the Customer or Contacts tbl?
Is this something that would be better hard coding or is VS2005 that much improved that its ok to use these binding features?
View 1 Replies
Feb 17, 2010
I have a combobox populated from the DB with:
-ID
-State
-Tax
State is the only value that is shown.I'm trying to get the hidden value, Tax, from the combobox based on the selection but can't figure it out.
View 5 Replies
Apr 9, 2009
how to generate unique ID based on combobox selection?
View 5 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
Jun 3, 2010
I am creating a program that will allow me to manage server EXE's for which I have the method to do so already completed. The problem comes when I want my front end to be able to use a database of different server configs stored in a dataset.
My Database has 4 columns (ServerID | ServerName | ServerPath | ServerMod)
I wish to be able to select the ServerName in a combo box (already done via Datasource/DataMember) and then load the ServerPATH and ServerMOD for that row into two variables.
View 1 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
Apr 3, 2009
I'm running into a little problem making one combo box dependent on the selection of another combo box. I'm using a access back-end to this project. I have two tables: MajorCategoryTbl and MinorCategoryTbl , MajorCategoryTbl has PK and description field, MinorCategoryTbl has a PK, MajorID (foreign key), and description field. I have two combo boxes on my form, one that displays the Major description, and one that displays the MinorCategoryTbl description, but the stored value is the PK for both. I want the selection of the minor category combobox to depend on what was selected in the major category combobox.
View 2 Replies
Apr 14, 2010
I'm writing a standalone application in VB.NET using Visual Studio 2005. I want to display/hide a bunch of Buttons based on the selected value of a ComboBox. Each selection would have a different set of Buttons to display, and I'd like to have them arranged in a nice grid.
Driving a TabControl with the ComboBox value would be the kind of behavior I want, but I don't want it to look like a TabControl to the user because it might be confusing.Is there a way to do this?
Basically, I'd like Selection1 of the ComboBox to show Buttons 1-4, Selection2 to show Buttons 5-11, Selection3 to show (maybe) Buttons 1, 3, 5, 6, and 8, etc., have them arranged nicely, and have the GUI show only the ComboBox and the buttons.
View 3 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
Mar 18, 2008
How Do I show the values from the dataset to the text box based on the selection from the combobox list i already populated the combobox my code is. [code]
View 3 Replies
Apr 9, 2012
I have a chart control and datagrid in the same page.
I want in a single button click, to populate them both using a datareader.
I have this code:
dg.datasource=reader
dg.databind()
Chart1.Series("series1").Points.DataBind(
[Code].....
The problem is that only one of them is populated (the first databind in the code) and the other databind isn't working.
View 2 Replies
Jun 30, 2010
I am not sure how to phrase my question properly but I want to achieve something like this.
I have a class named Products public class Products
private ID as Integer
private Name as String
Public Property ProductID()
Get
Return ID
[Code]...
When I do the same, I am getting an error "Object Reference Not Set to an Instance of an Object.
View 1 Replies
Oct 15, 2011
I got a problem about the arraylist function. Now I want to create and return an arraylist with each student ID for populating listboxes.
Public Function StudentIDs() As ArrayList
End Function
To display the student ID in the listbox by calling this function. (I need to read student information from text file. There are 6 student, so the result should be 100,101,102,103,104,105).
View 5 Replies
Feb 6, 2012
I have this code:
Private Sub EditPage_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load'TODO: This line of code loads data into the 'InventorySysDataSet.tb_master_products' table. You can move, or remove it, as needed.
Me.Tb_master_productsTableAdapter.Fill(Me.InventorySysDataSet.tb_master_products)
sqlCnn = New SqlConnection("Data Source=ZEREYSQLEXPRESS2008;Initial Catalog=InventorySys;Integrated Security=SSPI")
[Code]...
what i want to do is to automatically change the selected option of the cboProductCode on page load depending on the result of a query executed onload also.
View 1 Replies
Mar 20, 2011
Im just pulling information from SQL and populating textboxes etc.My question is firstly i have an issue because i can figure out how to do it, and secondly is there an easier way of writing this.So my Issue, i wrote a function to connect to SQL and pull information back which is fine it fills DS(Dataset) and then i want to be able to assign the relevant information within the DS to the desired textboxes,
[Code]...
View 6 Replies
May 8, 2012
I'm having trouble reading in the file and populating the textboxes accordingly. After loading the file (I think that is) nothing is being populated in any of the textboxes listed below. Basically I'm not sure if the file is being read or not.
If OpenFileDialog2.ShowDialog() = DialogResult.OK Then
If My.Computer.FileSystem.FileExists("path_to_file") Then
Dim ioFile As New System.IO.StreamReader("path_to_file" + "filename")
TextBox1.Text = ioFile.ReadLine() 'Adds the first line
TextBox2.Text = ioFile.ReadLine() 'Adds the second line
TextBox3.Text = ioFile.ReadLine() 'Adds the third line
TextBox4.Text = ioFile.ReadLine() 'Adds the fourth line
TextBox5.Text = ioFile.ReadLine() 'Adds the fifth line
End If
End If
View 1 Replies
May 2, 2009
Have a main form with textboxes on it. When the user clicks a hyperlink on that main form it pops up a new form that they drag and drop files to either a listbox or textboxes, that part works fine. All the seperate form is doing is simply grabbing the filename to bring back to the mainform. That is working correctly. What it is then supposed back on the main form is read the files, again the reading part is working fine, based on the read it's supposed to populate the textboxes on the main form. When I have the listbox that the user drops the file into on the main form rather than a seperate form it works fine, form size limitaton and aestetics are why I'm using a seperate form. When I debug it it's working fine, I can't figure out where it's dropping the info because line by line it does everything right and it shows the values in debug correctly, however when the main form regains focus the values do not appear as they would if I loaded the file directly into that main form.
View 1 Replies
May 22, 2012
I am having trouble with .net again. I have a series of 10 text boxes. I want to be able to populate them from an array and read there values into another array. In vb6 I would create a text box array with 10 text boxes / indices. I could then populate them by txtbox(i).text = arrVal(i) and to reference them arrVal(i) = txtbox(i). I am stumped I can create 10 text boxes on a form if I have to, but I want them somehow tied to each other as they were in vb6.
View 1 Replies
Jan 22, 2009
this is how I set up my data object for a file parser. (
Dim mytable As New List(Of String(,))()
mytable.Add(New String(4, 16) {})
and it loads mytable like this:
mytable(x)(y, i) = sToken(i)
Let me explain the indices, I have a form with a tab control. In mytable,x is the tab number. Each tab has up to 5 groups which is y. Each group has 17 text boxes, i.Each group also has 17 labels.I started looking at Me.controls, and looking at control properties like tabindex for some way to iterate through the textboxes and mytable to load the textboxes.
so I started with:
for x = 0 to 31
msgbox(group1.control(x).text
next x
and I saw how all my objects are not in sequence as it descending halfway through my label controls, then switched to my textboxes, and then seemingly finished randomly. I am at a total loss without the old index property and what I want to do is something like (forgive my syntax)
Form(0).Tab(x).group(y).textbox(i).text = mytable(x)(y, i)
I was thinking of manually setting the tabindex of all textboxes in group1 to sequential order to try something like:
group1.component.tabindex(i).text = mytable(x)(y, i)
To me this is fun and challenging, but also very frustrating and makes me miss coding in assembly As I can't seem to find any reference to the tree structure of accessing components indirectly, if that makes sense.
View 8 Replies
Mar 16, 2010
The code works fine, but I don't know if is necessary while sentence, maybe there is another option..
Dim CMD As New OleDb.OleDbCommand
CMD.Connection = otraConexion
CMD.CommandText = "SELECT * from procedencias"
[Code]....
View 3 Replies
Jun 10, 2011
I've been trying to figure out the easiest way to populate a menu to allow for easy updating in the future. I would like to add anything to a specific folder and when the program runs it would be populated by the contents of the specific folder. Is this possible? What should I look into to do this? Not sure of the process to use to do this, that is if it is even possible.
View 8 Replies
Feb 22, 2012
I have 3 textboxes TextBox1, TextBox2, TextBox3 and a button, I want to do the followingIf I enter a value in TexBox1 and press the button, some text will be set in textbox2 and textbox3; if I enter a value in TextBox2 and press the button, some data will be displayed in TextBox1 and TextBox3.I have no idea how to make the code check if the textbox1 value is not null and the textbox2 value is null, to execute a certain statement and set a value to Textbox2 and textbox3; and if the value of Textbox2 value is null and the textbox2 value is not null, to excecute a certain statement and set a value to Textbox1 and textbox3
View 1 Replies
