I am using these codes to populate a Combo o a Listview. What i want is to populate de List or a Combo depending a selected value.
cn = New SqlConnection(stringdeconexion)
cn.Open()
Dim sql As String
[Code].....
I have the following bit of code which works find but I have been asked to show for the displayvalue the storecode - storename. How can I do this?
sSQL = "SELECT * FROM ST_STORES WHERE ST_RG_CODE = '" & cboRegion.SelectedValue & "' ORDER BY ST_STORENAME"
sqlDSStoresCombo = rppData.tblGetTableData(sSQL, "ST_STORES")
[Code].....
I think I manually need to add the items but don't know how to add an item that has a value and display.
I am getting an error when i try to populate some combo boxes with a value, the combo box has values in and the right amount the code is getting the right number.
the error msg is "Object reference not set to an instance of an object."
I want to populate a listview and leave selected records that are true
I have a DB record which is ID int, desc varchar, selected boolean.
I have tried the code below
LVProducts is a Listview and DS is a dataset
CODE:
I have tested the code for the DataSet and DataAdaptor and both work fine, and as test was able to place the MaxRows variable into one of the text boxes on my form so I know thats all ok. But I am now trying to use the function below to copy the 1st cell of each row into a combo box to populate the options and comes up with a null exception error but cant get my head around it.
[Code]...
I'm trying to populate a combo box with some data from a xml document, but so far all i'm getting is this error message in the combo box[code]...
View 2 RepliesI have the code below and when I try to populate the listview it populates all of the listview items but only the first subitem. No clue what I've got wrong.[code...]
View 2 RepliesHere's my code and It's now working. I put that in "txtSearch.text"
If lvList.View = View.Details AndAlso lvList.Items.Count > 0 Then
Dim lvItem As ListViewItem = lvList.FindItemWithText(txtSearch.Text, True, 0)
[code]....
I am new to Visual Basic and I'm trying to make a simple combo box that automatically populates from dataset. The table is from BaseMaterial with the column Material.
View 5 RepliesI have a form with one combo box and text box and buttons. please refer the snapshot with i have attached.I have the following code:
My Stored Procedure for inserting the data:
/*
Name: usp_InsertBranchSetup
[code]......
I'm trying to populate a combo box with a dataset, this sort of works, but everything is just appearing on the same line. I think this answer might be to put the dataset into an array, then put the array into the combo box.
...problem is, I'm not sure how to do this! My code thus far is,
Dim usernameList As Array
'Retrieve usernames where player has available status
GetFilteredData()
[Code].....
I am currently stuck in one part of my application. I have two combo boxes that i am having the users select from. The first combo box is simply bound to a datatable. that is working properly. The second one i need to populate off another datatable after sorting out what the first one is requesting. Basically it's choosing a line number on the first box and then selecting the machine associated with that line number.[code]...
View 4 Repliescan someone please give me basic steps on how to hard code a combo box to display a column from a database?
View 21 RepliesI want to fill data in my combo box using Add range method.
cboFirst.Items.Add("Sunday")
cboFirst.Items.Add("Monday")
cboFirst.Items.Add("Tuesday")
[Code]....
This is how im filling my combo with days. i want to do the Same but by using Add Range Method.
Im trying to pooulate a combo box in vb.net 2008 with information from my access database, but I have no idea how to do thi :S im trying to get it so that the customer names from the database appear in the combo box this is as far as i've gotten for my form load.[code]
View 4 RepliesI am currently writing a program that needs the use of a database. At the moment I am trying to get a simple combobox working.The problem I am having is that I have never done any work with databases and VB08.I am using an access database that has the fields SMTP, Port, SSL
I want to populate a combo box with the field SMTP and from there I want 2 other labels to be filled in with the port and ssl details I was wondering a) How do I set the connection up with Visual Basic (within the database I am using MySQL to get the information) b) How do I go about populating the combo box?
How to populate a combo box using SQL Data Reader in DAL, BAL and UI atmosphere. Please find below my code snippets and correct me if I'm wrong anywhere in this code.
'DAL Code
Public Function PopulateComboBox() As SqlDataReader
_cnCon = New SqlConnection(_conString)
_cnCon.Open()
[Code]....
What should be the UI code? Is the code specified in DAL and BAL is correct? I knoiw how to fill the combo box with values from SQL Data Reader. But I dont know how this can be done in 3 Tier application.
Is there a way to populate a combox with a list of available drive letters? I've tried the following code but could not gt it to wrok.
[Code]...
So I feel like im pretty close, but I also have a feeling I am mixing up StreamReader and ReadAllLines[code]...
View 1 Repliesi have a combobox and richtextbox, text box. in my rich textbox i have a
Smart BRO 15,SMBRO15
Smart BRO 30,SMBRO30
Smart BRO 50,SMBRO50
Smart BRO 60,SMBRO60
Smart BRO 100,SMBRO100
Smart BRO 115,SMBRO115
i want to split this in to two. i want to load the this in my combobox
ex.
Smart BRO 15
Smart BRO 30
Smart BRO 50
when i select Smart Bro 15 in combobox, the SMBRO15 will show in textbox .
I am a developing an application based on VB 2008 express and a MYSQL database.I have created a database called octupus_db and inside it there is a table called customers.I now have a combo box on my form and i want it to populate its contents from field called town inside the customers table. How do do this? [code]but now connection a table and a field with my application is the next night mare, tried .
View 2 RepliesHow to take a value from a combo box and have it update a field in sql table?
View 1 RepliesI need to populate a Combo Box with sheet names in an Excel File. I Have an openfiledialog that i search for the excel file and put the dirPath to a textbox, now i need to populate the ComboBox with the sheets in that file, the idea is so when i select sheet3 in the ComboBox, i can pass that sheet name to the string for processing.
View 4 Repliesi have a combo box that on form load is populated but i need to know when i click an item, i will be able to code how to populate other combo and text boxes with data about the same person.
View 2 RepliesI'm trying to populate a List Box or Combo Box (either or, I feel like both would be very similar in how the code is written) when you load the form. Here is what I have right now:
<a href="http://s2.photobucket.com/albums/y11/funkyfries222/?action=view¤t=ForumHelp.png" target="_blank"><img src="http://i2.photobucket.com/albums/y11/funkyfries222/ForumHelp.png" border="0" alt="Photobucket"></a>
When you first open the program it gives you a form with either a list box or combo box (not sure which one I want to use yet) and then an add button to add a name to the list. It shows the from where you enter a name and then when you add a name it adds it to a text file that I have saved onto the desktop. It keeps the names on separate lines and I want each line in the text file to be an item in a list box...
Here is the code for the first form:
Public Class frmEmployeesMeat
Private Sub frmEmployeesMeat_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
frmHours.Visible = False
[code]....
I want the files names in a specific folder to show in a combox box. How can I accomplish this?
View 1 RepliesCurrently, i have a simple application that manages the user account on a machine. The functionality includes the adding, deleting and modifying of user account. For deleting a user account, the username has to be entered into a text box. But i want a combo box to be created and named of the user account that are already created on the machine
View 4 RepliesI am trying to populate a combo list box with the results of a web service. The web service returns a dataset with two columns. I want to display column one to the user and capture column two with the user selection of an item from the combox.right now I can display the first column and capture the selection.Not sure how to add the connection of column two, to the combo box and capture the selection
Code so far....
myDataSet1 = proxy3.listSuppLang()
Dim x As Integer
[code].....
I have the following code to insert a record into the database [code]...
View 6 Repliesi am developing a simple vb.net application. i have three forms in my app. the first form has 2 radio buttons from which i need to select one. based on the selection made in my next form a combobox ll be populated.so far so good.there is a back button on my 2nd form which when clicked redirects me to the first form. here when i select the next radio button the combo box in the next form does not populate accordingly. it still holds the old values. \[code]
View 4 Replies