I have a listbox and i populate it with data in my code like this on the page load....
[code]...
So say one item in the list is displayed Ted Jones (123) and its valuefield should be 123. Im just not understanding what i am doing wrong here.
i think the answer is to loop each of the cells/columns/rows in excel then show it in the listbox... i think.. the problem is i don't know how...
is populating from a text file the same with populating from an excel file?
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
[Code].....
My Access database has one column named 'Term' and the Table name is 'ATG'. I require to populate my listbox with data in the 'Term' columns. I'm unable to do that using this code. Can anyone tell me what's wrong with this (it displays numbers from 1 to 10 and not the database data)
Imports System.Data.OleDb
Public Class Form1
Dim dbConnection As OleDbConnection
Dim dbCommand As OleDbCommand
[code].....
Populating a listbox with data from a database
View 2 RepliesI have a function that fills a listbox with data from sql server 2000 database. Here is the code: (It's in a class)
[Code]...
Ok I have a Listbox that is populated by a Datasource or the datasource is a listbox. When I try and retrieve the selected item It is blank. How do I retrieve the selectedItem?
View 9 Repliesi want to populate a listbox from a sql database and foll is the code i encountered error with:
Dim con As SqlConnection
Dim cmd As SqlCommand
Dim lrd As SqlDataReader
[code].....
I need to populate data (Patient ID and name) from a MS Access Database table (PetientInfo) into a listbox depending on date (Datetimepicker). The listbox item will change upon date changed.
When I select a item from listbox the details of the patient will show to the textboxes.
[Code]...
when u select s1 then u click save it so the txt file will have items s1 only and when u select s2 and click the save button then in txt file u have 2 items
form1 it have a panel1 with 3 buttons in it.what i want is when you click each item in list then panel1 popup and shows up near that item.[code]
View 2 RepliesI am building a WinForms application. On one user control I have a CheckedListBox on the left and a ListBox on the right. Within both controls, the selected item(s) become completely transparent. Not only transparent, but if I was to click within the transparent area(s), I would actually be clicking whatever is underneath the application. So, if the WinForms app is loaded up and sitting on top of a browser, when I click one of the items within either list control, I could actually click a link within the browser underneath. At first I thought that I had changed a setting of each control. I thought there might be something like SelectedItemTransparent = True/False, but upon further looking, I think it might be an application-wide setting. I have confirmed that it isn't just this one machine. I have loaded the project into VS 2008 on both my laptop and desktop with the exact same results.
View 2 RepliesI'm using a listbox to list my custom objects. I need to use the ListboxSelected event and treat the SelectedItem as MyObject, so I can get certain properties from it... How do I do this?
View 1 RepliesI have inherited some code from an external contractor that I have to modify. Firstly, he uses a strongly typed dataset to retrieve some data from an SQL database and then uses that data to populate a listbox. I have decided to use a dropdown list (as the user can only ever select one value at a time).This is the code that populates the DropDownList
Private Sub FillUserComputer(ByVal userId As String)
Try
TraceDebug("Begin FillUserComputer"[code]....
This works well for the first two entries in the DropDownList. However, whenever I select one of the other options and click the Send Request button it "jumps back" to the 2nd entry in the list and sends that data instead, completely ignoring the option I selected.I think I have narrowed down the problem to the fact that the DataValue for the second entry in the list is a Null value.
There have an error:
"Object Reference not set to an instance of an object"
when using objusername.intuserid=listbox1.selecteditem.value.
I have a user control which contains several buttons and a listbox. Clicking a buttondetermines what items are in the listbox. When a user clicks an item in the listbox I want the selecteditem passed to the parent form.
View 6 RepliesIs it possible to select an item in one listbox and then display the data of another listbox with the same indexed position? I am planning a project and this is something I would like to attempt but I haven't figured out how to do it.[code..]
I tried doing the above code but instead of displaying the listbox text the message box just returned false.
If I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ListBox1.Visible = False
ListBox1.IntegralHeight = True
[CODE]...
I've pretty much just started in playing with Visual Basic Studio 2010 and have been using this site for lots of answers so thought I'd join up and harass more directlyI've been trying to move items between two lists, one is databound to a bindingsource, the other isn't. I found out that you can't really move items from databound lists, but you can remove from the datasource instead. This works fine until I want to move the item back - it fills a blank line with seemingly no data.
View 6 RepliesThis code bellow to compile a single listBox on form1 to listBox on form2 then listBox on form3.
I want to modified this code to compile 169 of ListBoxs on form1 to 169 listboxs on form2
and 169 listBoxs on form3.Try this code,not need the new coding.
Original code from JoOl and modified by John Anthony oliver
[Code]...
1 when my listbox returns resaults it only brings back 10 how do I set it to return lets say 500
and question 2 is when I click on my links in listbox it's not opening webpage as I would expect it...
This is my code
[Code]...
I'm trying to write some code which parses data and then populates a listbox. I'm using the IPWorks IPPort component which basically does the reading of port 30003. The ipport1_OnDataIn event is where all the action is. I parse the data, which works great.. however when I try and do something simple such as add text to a listbox, I get the dreaded error "Cross-thread operation not valid: Control 'lstListBox1' accessed from a thread other than the thread it was created on".I've googled the error and tried copy and pasting some workarounds but nothing seems to fix the issue.
If anyone can offer help, it would be greatly appreciated. If you could possibly show the code already implemented into mine, it would be even better so I can see how it works. It would make more sense to me. My code is below. The part i'm trying to get working is the lstlistbox1.items.add("Test") in Case "2". This is to just get it working.. I'll be adding listbox items in the other cases as well, and they'll be parsed values instead of "Test". This is just to simplify things at the moment.
[Code]...
I have a Report I created with Visual Studio's VB.Net ( I guess this makes my report embedded), which I can select a date range like starting and ending date but the drop-down listbox for the Name is empty and I have to type a name into it to work. I need to be able to choose the name because I won't know who is on the list.
View 1 RepliesI've given up on my harder stuff and have simplified it to something else. There are no errors that pop up now but the list box doesn't populate! I took the code from a book and there's a data adapter, data connection, and data set on the form already (they're not named in this code though, since the book didn't say to). When the program opens, the list box has a line of text in it and the list box doesn't fill with the right items.
Private Sub EditStock_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
Dim dsitemlist As New DataSet
Dim itemlistadapter As New OleDbDataAdapter _
("SELECT ItemName FROM Stock", ConnectString)
[Code] .....
And here's what shows in the box.
system.data.dataviewmanagerlistitemtypedescriptor
I come from Access and I am developing now my first windows form app in visual basic 2010 based on a Access database *.mdb. The thing is i have an access db with 5 tables. I have created the forms, connected to the database, all is working great. Parent- child relations are working, datagrids and comboboxes populate the right way, buttons are working.
But now I want to populate listbox, and combox from tables with queries. Like in access I would like, for example to populate two different listboxes bound to the same table with different queries, so that the listboxes give different results, based on different variables or textboxes.
But I don't know how to attack the problem: the query works against the tableadapter, so the info it gives back is always the same. I have tried to duplicate the tableadapter of the table i want to query, writing different sql queries in both, but it does not seem to work. I don't know in what direction I should ivestigate: LINQ, sql queriess, coded queries, filtering the listbox...
I've been working on this for three days now and I can't seem to get my listbox to populate. I'm connecting to an sql database. Where am I going wrong? Dim cmd As New SqlCommand("SELECT DISTINCT natureport FROM rates ORDER BY natureport", conn)
[Code]...
I'm trying to populate a listbox with every file that was last accessed more than a year ago but I've hit a snag, i cannot get the fileinfo for some files because the path is too deep, is there a way round this
Dim drivestring As String = lstBoxDrives.SelectedItem.ToString
Dim directoryName As String
Dim fileName As String
Dim accesstime As Date
Dim FileProps As IO.FileInfo
[Code]...
The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.
I can get a single column but how do I get 2?
myTenConnection.Open()
myTenAdapter = New MySql.Data.MySqlClient.MySqlDataAdapter("SELECT ten_name, ten_contact FROM tenants ORDER BY ten_name, ten_contact", myTenConnection)
[Code]....
I have a class with a collection of objects of type clsCDImage
clsAllCDs:
Imports System.Data.OleDb
Public Class clsImages
Private mAllCDimages As New Collection
[Code].....
I'm doing a win form application in visual studio 2008 and using 7 listboxes where my sql query will populate all customer from customertable. It's 7 cause it's one for each day, my problem is to get customerid when I select one of the customers from any of the listboxes to my textbox. Since there are 7 listboxes I can't use "data bound item" function, in that case it would be easy to write code like this: textbox1.text = listbox1.selectedvalue.tostring(
View 6 Repliesthis is a library management system, i dont know why it doesnt work, my code in the issue form is just the same as the return form but it doesn't work right here. it just populate the listbox with the info. from the database. my code is here,
Dim nnn As Integer
Dim mmm As Boolean
Dim xxx As Integer
[Code]....