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...
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
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.
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.
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.
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.
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?
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)
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.
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.
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.
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.
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.
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.
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]
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).
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,
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
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.
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.
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)
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.
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.
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
Is there a way to update source combobox to printer combobox selection?So going from printer1 to printer2 the source will update according to what that printer has to offer.
Populating the combo box with the list of items from the one of the column in table from database.Based on the selection of item in the combo box, the another combobox should be populated with value corresponding to the selected item in the first combo box.[code]The problem with this code only the first row that is populate in the 2nd combo box.
I'm having a problem with combo boxes. I usually use Java and it's been awhile since I used VB but I never remember having this much difficulty.My application is using an SDF file. From Data Sources, I drag the details on one of my Tables to my Form to get all of the fields. Three of them are comboboxes. Each of the three is an INT64 and each corresponds to a primary key in a different table. I click the tasks button on a combobox and for data source I select the appropriate table that has the data to go with the combobox, for display member I select the field that I want users to see, and for value member I select the primary key. Then I run a quick test and start the app, open the form, and add a new record. When I select a value from the combobox the selection won't validate because it doesn't think it's an INT64 like it should be. It seems to be using the display member as the actual value instead because if I change display member to the primary everything works great.
I have two comboBoxes, one is CountryCombo and second is StateCombo.What I want is the that when i the clicks country combo and select a one country then the States of that the country should get populated in the State Combo.I have tried things many many many but nothing working. Below is my code of how my CountryCombo is getting filled.
query="select CountryName from CountryMaster" if dr.hasRows() {[code]......