I have my project connected to an Access database, and I was able to sync the data to vb just fine. But on one form, I want to be able to sort through records (there are 15) via the ComboBox. Right now when I select another description from the drop down list, the corresponding data doesn't show on the form with it (the rest of the previous record is stuck there). The Binding Navigator works though. Here is how my form looks:
[Code]...
I have a button on a form and 3 comboboxes, each populated with a list. The outcome I'm attempting to programme is, descriptively; Button Click
[Code]...
I have started a form application using visual studio 2010 express, vb programming. I'm using Access as my database.My goal is to have ComboBox1 display a ProjectID and ComboBox2 display a TestNumber. Once the Test Number is selected I want my textboxes in the form to display fields from the row that the selected Test Number is in.I have 2 tables set up right now "Projects" and "TestData". The "Projects" table has a [ProjectID] field, the remaining fields are just misc. project data. The "TestData" table also has the [ProjectID] field, and then the [TestNumber] field, then the remaining fields are misc. data.
Filling [ProjectID] in textbox1 is easy, in the properties I select DataSource from the Projects table, display [ProjectID] field. Where I'm having troubles is ComboBox2 displaying the TestNumber from the other "TestData" table. If I select that field, it fills the ComboBox with EVERY TestNumber there is. So for Project 1 there is a test 1... over 500 projects, that combobox lists 500 Test 1's, no way to tell what project it belongs to...How do I make ComboBox2 only display Test Numbers that pertain to the Project number selected in ComboBox1?Using this code I can get it to work:
Dim ProjectNo, SQLString As String
Dim dtTableData As New DataTable()
Dim dbDataAdapter As OleDbDataAdapter
[code]....
I also imported system.data.oledb Problem with this code is it will only filter data in ComboBox 2 but when you make your selection from ComboBox2 it won't activate the row so none of my databinding textboxes fill anymore. Before the code/query is ran it fills up the textboxes perfectly after every selection I just have no idea what project that report number belongs to because the whole field is displayed in the dropdown. I can fill the form with ComboBoxes and they display the corresponding row data because I use a "datasource" instead of textbox "databindings" but I don't want to use 20 comboboxes as my entry form...
I want to load data from a txt in a combobox and a listbox. The txt is composed as follows:
ID NAME
0001,name1
0002,name2
0020,name3
[Code].....
In the combobox I want to load 'NAME " And in the listbox I want to load "ID"
I am trying to use the combobox to update/edit/view the saved data (in contact form) from sql server.
My Load_Combobox (in contact form):
Private Sub Load_Combobox()
'Type
cboType.Items.Add("Director")
cboType.Items.Add("Principal")
cboType.Items.Add("Project Manager")
cboType.Items.Add("Technical Manager")
[Code] .....
The problem now is when I saved a record into sql server (EG Technical Manager) and try to view back the saved data, it always show the first item (Director) in combobox. But, my sql server has saved is "Technical Manager" for that saved record.
I have a text file in which there is a list which is composed as follows:
3236, Alberto
5894, Peter
7894: Alonso
and so on ...
What I want is loaded into a listbox the numbers to the first semicolon and load the combobox names.
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.
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
View 3 RepliesPrivate Sub AddIngoing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
I am having issues when trying to populate a combobox that is dependent on another combobox. Populating the first combobox works as expected but attempting to set the value member or display member properties of the first combo box cause its selected index changed event to fire. That event seems to fire before the first combobox is fully loaded. The issue is then raised when trying to populate the second combo box, since it is dependent on having a valid value member to complete the dynamic sql statement, and at that point in time, there is no value member.
I can�t imagine that this is difficult but searching hasn�t yielded me any results. Should I be using a different event? What is the right way to do this?
I have a simple workaround in place - not allowing the second combo box to attempt to populate unless the first combobox has an index greater than zero but this hack is no good since it clearly prevents the user from selecting the first element in the first combo box.
Private Sub SpecialsForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sql As String
Dim dt As New DataTable
[Code].....
I just want to display data in a DataGridView (from SQL - already made the connection) based on what is selected in a ComboBox (data that is also coming from SQL). The 2 are separete on the form. I am using VB 2010.
This doesn't work for me:
objCommand2.CommandText = "SELECT ProductID, Name, Color, Size, ListPrice FROM SalesLT.Product WHERE ProductCategoryID = " & cbCategory.SelectedValue
[code].....
I got the System.Data.DataRowView when I tried to select the data from sql database. These are my code:
......
myCommand = New SqlCommand("SELECT FirstName +' '+ LastName FROM tblVisitor", myConnection)
myAdapter = New SqlDataAdapter(myCommand)
[Code].....
i hve create combobox & text box and add database source to my project...i know how to binding data or load data to combobox using SELECT query..but can i change SELECT to INSERT query cz i wont when i type data into textbox,data will be in database...second..can i binding without add database to project..i mean mydatabase in debug folder..i hve problem binding data if database is not in myproject..
View 7 RepliesI have data in my combobox1 and was wondering if it would be possible to sort the data in the combobox alphabetically? I have spent ages trying to find the answer by searching the forum but couldnt find anything,
[Code]...
I'm trying to bind data to a combo box but it does not appear to be working. I've setup the DataSet and the DataSetBindingSource and all this appears to be working, within the form design I can expand the little arrow in the ComboBox control and preview the data. This appears to be working but when the application is run, nothing appears in the drop down box.
View 5 RepliesThe code below produced the error:
vb.net
Dim i As Integer
Dim strText As String
Dim oExcel As Application = CreateObject("Excel.Application")
[Code]....
error: value can not be Null at Me.ComboBox1.Items.Add(strText) line.
Well here is my problem, I have an XML file and from there I have data going into a drop down ComboBox, what I need is the data from the next column over that corisponds to the same row, ie. the phone # that corisponds to a person's name in a data table.I semi-know what I need to do I just can't figure out the code to take the index of the ComboBox and take the data into the Label.
View 4 Repliesfinally given up trying to make it work with my stored procedure.
Info:
Sql Server - 2005
Table name - venatio_company
Dim con As New SqlConnection
[code].....
I have a combobox where I use datasource to populate it with data, in the key press event I have the following coding which i use to filter the data.
With Me.Combobox1
Dim ToFind As String = .Text.Substring(0, .SelectionStart) & e.KeyChar
Dim Index As Integer = .FindStringExact(ToFind)
[Code]....
I know this would be possible by me changing the style to dropdownlist but its not exactly what I was after.
I am using vb2005, and I am using MS Access 2003 as my database.
This is what I am doing and this is what I would like to happend
I have two combo boxes, combobox1 and combobox2
I have two tables, Application table and Group table
Here is how the data is going to be display:
Combobox1 = Application Table
Combobox2 = Group Table
In the Application Table I have 3 columns ID, Code, Description
The same information applies for the Group table
THis is an example of the Application table
CODE DESCRIPTION
1 Purchasing
2 Stores
3 Assets
[Code]....
I bound my combobox in a datasource.How can I insert a value at the top of my combobox?[code]...
View 7 Repliesi want to insert data into data base from my combobox,which parameter should i use in insert query ? [code]
View 2 Repliesi have an error when executing this
ExecuteReader: CommandText property has not been initialized
i create 2 combobox in form, comboproduct & combomodel. i using accessdatabase and using oledbconnection..database in debug folder... i create 1 table, i name it"stock" & 2 column.. first column is product,second model..
i wont load data in product column into comboproduct and model to combomodel..like binding data..
I am populating data form database in combobox. This data is in the form of numeric codes like 112, 113,
The thing i want to do is on selecting some code like 113 from combobox, it will display it as ABC113 in the combobox.if code like 114 selected from combobox, it will display it as ABC114 in the combobox.
I don't want to store this modified string in database.
Please help me to achieve this.
Provide me some sample code or link for simple combobox or combobox in datagrid.
i think there is no change in code in both above cases.
I am doing a payment system and what I really want to happen is that when I select the payment type(full or installment) the data that I inputted will show on another form. For example, after I filled up my information and selected the payment method, and after I saved it, if my payment method is "full", the information will appear on the "full_pay" form or if I selected "installment_pay" the information will appear on the "installment" form.
[Code]...
I have combobox binded to binding source (NastavniciBindingSource). I wan't to refresh combobox when I add new data.
Dim str As String = InputBox("Enter name:")
Me.NastavniciTableAdapter.Insert(str, "", "", "", "")
Me.Validate()
Me.NastavniciBindingSource.EndEdit()
Me.NastavniciTableAdapter.Update(Me.StudentDSET.Tables("Nastavnici"))
' here I need the code to refresh combobox
I have a data bound combo box which i want to open at a certain row in the table
i can't set the selectedvalue because it is databound
i would like to sort the information inputted on the textbox and make it appear on the listview of another form by using the combobox. like if i inputted my Surname, First_Name and Middle_Name and i chose the "Full" item for my paytype with the id number "txtid" and the "yearlevel". they are all inputted using the textbox except for the yearlevel and paytype. they all should appear on the listview of another formand i click the save button, my surname, first name and middle name, txtid and yearlevel will appear on the listview of my full_pay form.
if paytype.text="full" then
'my information will go to the full_pay form
elseif paytype.text="installment" then
'my information will go to the ins_pay form
I have 2 forms: form1 has a combobox form2 has a textbox for new names and a button to add
Basically I want to be able to type in a new name in the textbox and click add to add the new names to the combox in my form1.
