I want retrieve from database data to a text box that equal to selected from a combo box. ex:- i'm selecting a item_code from item code combo box after item name should come to the item name text box.how can i writ that.
View 2 RepliesI'm doing a project in vb.net back-end is MSACCESS...
I don't know how to store data from COMBO BOX and to RETRIVE data from database to COMBO BOX.[code]...
I populate the emp id in combo box . if am select the id i need to display the others datas in the text box.
View 1 Repliesi want to retrieve data from text file and save it to sql database bt i just have to implement some conditions like if there are 3 entries exists in text file with the same ID but i just have to get only 2 of them so in what manner should i write the code....
Dim sbIDs As New System.Text.StringBuilder
Dim sbPunchDateStamp As New System.Text.StringBuilder
Dim sbPunchTimeStamp As New System.Text.StringBuilder
[Code].....
I have a combo box on a form named cboGender, I am using a data reader to retrieve data into the combo box as follows[code]...
the value of Gender shows in the combo box if the Drop Down Style property is Simple or Drop Down. However if I set the Drop Down Style property to Drop Down List which cannot be edited, the combo box is empty.
I have a Form with a Tab control on it, one of the fields is the Apartment number which is a Combobox. It is displaying properly, however since it sits on one of the tabs when you scroll through the records its hard to remember what tenant you are dealing with.
I have a label on the top of the screen that shows the Tenant First/Last Name.
I also want to at what Apartment Number they are looking at.
I currently am trying this: I have also tried:
SelectedItem
SelectedText
SelectedValue
Column 0 of my combobox is the ID and Column 1 is the Text description.
[Code]....
My problem is retrieved data from database but when i run the coding, the combo box do not display anything.The below is my coding:
[Code].....
I have employee_id 1000,1001,1002,1003,1004... likewise. And my other fields are employee_name,employee_age,employee_mobile likewise.,.
what i need now is i get a employee_id in combo box. if i select the employee_id in combo box in the below text boxes i want to display the other fields like employee_name,employee_age,employee_mobile..
how can i retrieve the data that i've stored in an access db column and display it in a combo box in a vb2008 project?
View 1 RepliesI have a form (vb.net, VS2010) which retrieves product orders and displays the result to a datagridview and text fields. I also have a combo box which displays a list of all products in a product file. I need to set the displayed text of the combo box to match the product name of the ordered product.[code]...
View 2 RepliesHow can we Find newly selected text in Combo Box. Whenever I do this, I get the old text instead of the one they just changed to.[code]
View 10 RepliesIm trying to develop a frontend for a database project I have been working on, I am using a combobox to select a meal_name and need the primary key to update another table for orders, How can I retreive the primary key using the meal name selected.below is the code I am using to add meal names to the combobox
Private Sub ComboBox1_MouseEnter(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox1.MouseEnter
Dim myRow As DataRow
Dim CmdStr As String[code].........
I have a data grid view control which i populate using a random access file. What i want to do is when a user clicks on a cell, i want the data held in all the cells in the particular row to be used to populate some textboxes. i have searched everywhere and they all use sql databases.
View 2 RepliesI have a combo box with font families and another with font sizes.i know how to change the text font properties according to the combo boxes.but now i want to change the combo box selected items according to the text font properties where the cursor is located.but i can't do that.[code]...
View 1 RepliesI have the following code to insert a record into the database [code]...
View 6 RepliesI'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.
The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
I've already asked on other forums and people are where replying giving me third party programs that I could use to implement this, something I don't really want to do.
I'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
How do you manipulate a string that you have selected from a Combo Box that has been upated dynamically from an MS Access Database table?I have strings that are "1, Surname, Forename" and need to get both the number, and the surname out to put back into a different database table.
View 4 RepliesI have a combobox where the user can type the sql server name. Then a connect button that, when the user click, I want it to populate another combobox with all the databases from the server in the previous combobox. Unfortunately, I am getting the error object reference is not set....!
Here is where I am getting the error:
For Each objDB As Database In Me.SMOServer.Databases
I am new to VB ...I'm using vb2008 connecting to sql server 2005.
Here is my complete code:
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
Public Class Form1
'Public Class frmSQLConnection
Private m_objServer As Server
[Code] .....
I am building a form in access database.
I have a combo box which is linked to a query which is looking up a unique reference number from a table called Tbl_Submitted_Requests.
What I need the form to do is auto populate the other text boxes when the user selects the unique reference from the combo box. How can I get the text boxes to auto populate with the data that is associated with each unique reference?
I am using a not equal operator <> in my sql statement but it doesn't retrieve any record which is not equal to the selected date.
CODE:
Command = New SqlCommand("SELECT * FROM [Products] WHERE [ParkingStartDate] <> @StartDate", myConn)
Command.Parameters.AddWithValue("@StartDate", StartDate1)
Ok so I have a combo box that lists a set of names. What I want to do is match a selected name to a text file and read from it. The text file contains the same name and has grades listed below:
ex.
Johnny Bravo
30
10
I have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error: Failed to retrieve data from the database. Details: [Database Vendor Code 9421]
Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.
how do i program by saying if a certain item is selected in a combo box then that item will not appear in a second combo box. i have this code for now but it does not work
[Code]...
I have three tables in SQL server which I would like to show and access on a form. Table 1 contains account data, address, contact details etc. Table two contains data attached to a Person, tel no , Mobile no, Email etc. Table three contains details on what awards the person holds, i.e. one person can hold several awards.
Therefore I have a one many relationship between the first two tables and a one many relationship between the second two tables. This is set up in SQL
The first two tables are shown on a form, table 1 via a set of text boxes, table 2 via a datagrid control.
I would like the functionality whereby I could select a row in the datagrid showing the persons name and find the Persons_ID number then use that as a filter to a second datagrid view so that only the selected persons awards show in the datagrid.
i need to be able to compare data from a text file with the collection of a combo box.My algorithm currently populates the combo box with data from the text file on the form load event.I have included an update button that updates the combo box collection.[code]
View 1 Replieswe want to retrieve all data in our database but we dont know how to do it.. hmm.. we just use to retrieve data one by one.. its just by the search button.
View 4 RepliesI am trying this..
Imports System.Data.OleDb
Public Class Form1
Dim conn As OleDbConnection
Dim cmd As OleDbCommand
[code]....
I get an error: object reference not set to an instance of an object
can someone please give me basic steps on how to hard code a combo box to display a column from a database?
View 21 RepliesVisual Basic 2008 I want to put data in combo box from MySQL database.
View 19 Replies