if this question has already been answered many times, but I am new to VB and I don't really understand any of the examples I have found by trying to research this topic. I am using VB 2008 Express Edition. My List View is called listView.
View 4 Replies
I am trying to populate listview with the code below:
Public constr As String = "Data Source=adesina-pc;Initial Catalog=AdventureWorks;Integrated Security=True"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]....
how to populate my listview using database.
View 2 RepliesCan someone help me with this code? I just need to make it so there is no limitation on how much data is loaded in the columns or rows, it populates very nicely for smaller comma delimited files , but if I try to load something that goes for example over to AV column, it errors out.I don't care about VIEWING this data, I am just trying to get it into a LISTVIEW so I can access the data for other methods in my code.Index was outside the bounds of the array. [code]
View 3 RepliesI'm playing with an Access database file. And I want to populate a ListView control with Access data. I'm not going to use the DataGridView control. The following is my Access file, which has a table labeled Employ1 with three fields (Usernames, FNames, LNames) as you see below.
[Code]....
I googled, searched and tried houres but I can not find a simple code/class that does the following: I have a SQL database and I want to show some colums of a table in a listview... Not so difficult I thought, in VB6 it was fixed in 2 minutes but now I'm struggeling for houres... I found Imports System.Data.SqlClient but further then this, I fail...
View 3 RepliesWhat I want to do is gather the data that displays in my listview (called 'lstData') when selected and populate my textfields with it's information.[code]
View 2 RepliesI want to create a 2 dimensional array and populate it with data from database. I wrote this following code.I made some mistakes here with the arrays.
[Code]...
I am developing an application in visual basic 2008. I want to populate a drop down list onthe fly with values extracted from the database. I want both the displayed and value items to come from the same.
View 1 RepliesI have a few drop down lists that I'd like to populate from a table in an SQL database. I tried setting it in the DataBindings section of Properties but I guess that doesn't work.
View 11 RepliesWhat I want it to do, is when a id is selected to be modified, another form will pop up with the fields are filled in with the relative data. Every time I run this I keep getting the following error -- "Syntax error in string in query expression '(the wombat ID selected)'"when it gets to the following line of "fillformDataReader = fillformCommand.ExecuteReader()"What is going wrong and how do I go about fixing this error so the new form is populated with the correct data?
Dim fillformCommand As New OleDbCommand
Dim nameView, idView, regionView, sexView, ageView, weightView, lengthView, sampleView, commieView, descriptionView As String
[code].....
I have a field in an access database with decimals in it. I am using ADO to read in the data and are trying to assign it to a textbox in a form. This works fine when its a whole number. But it doesnt seem to work when its a decimal for some reason.
I have declared the variable i have assigned the access field to as a double, but when i set up a test textbox which i point the variable at and times it by 1000, it doesnt work. Works perfectly when i change the access field entry to a whole number though.
This sounds like im not using the right syntax or something.
I have a vb-2008 program that contains a (listview) control.
View = details
AllowColumnReorder = true
Lets say the table has 3 columns (a,b,c) and 1 row of data.
a b c
1 2 3
I want the user to be able to re-arrange the columns (by dragging the column headers) before printing the contents of the table.
c a b
3 1 2
Statements like:
.. ListViewX.Columns(2).Text
.. ListViewX.Columns.Item(2).Text
.. ListViewX.Items(0).SubItems(2).ToString
Give the column-name (c) and cell-contents (3) of the origional table .. not the (3rd) column (b) of the re-arranged table.
How can i get the column-name and cell-contents of the (3rd) column of the re-arranged table?
i am developing a point of sales system. currently i have my product code scanned and displayed in a listview. lets say that i have 5 product codes displayed in my first listview. By clicking on a button, how can i use these codes to call upon the details (prices, product name, etc.) of the corresponding codes and display in another listview?
i am using Visual Basic 2008 and MsAccess as my database. who have the idea on solving my question. (As my last thread has not been answered at all..
I have started the familiarize myself with WPF and have gotten stuck with the ListView I've read a lot of documentation about binding and I can't seem to find how to populate a ListView programmatically. It seems like a lot of work to create the binding and classes, etc, just to fill a ListView.
1. If you want to populate a ListView with data that a user has inputted, is the correct way in WPF to populate the ListView with binded data?
2. How do you add items and subitems to a ListView in code? (There doesn't seem to be a subitems in WPF.)
how to populate a 3 column ListView with an array? I'm using this code
For k = 0 To (strArr.Length / 3) - 1
For i = 0 To 2
ThisRow(i) = strArr(i)
Next
[code]....
but I am getting the following output if I were to have the following in my array : the, quick, brown, fox, jumped, over
=================================
| Column1 | Column 2 | Column 3 |
=================================
| the | quick | brown |
| the | quick | brown |
I want it to display:
=================================
| Column1 | Column 2 | Column 3 |
=================================
| the | quick | brown |
| fox | jumped | over |
what was wrong with the code it only show the last record in list view.
Public Sub loadRecords()
Dim itmListItem As New ListViewItem
itmListItem = New ListViewItem
[Code]....
I have a listview with 6 columns. The first, hidden, is a key value. The other five are FirstName, MI, LastName, Gender, and CurrentGrade. When I go to populate the listview, I pull a datatable and do this:
For Each dr As DataRow In dt.Rows
Dim lvi As New ListViewItem(dr("StudentKey").ToString)
For i As Integer = 1 To 4
lvi.SubItems.Add("")
[Code] .....
But when the form loads, I get the MI in the FirstName column, the First Name in the LastName column, the LastName in the Gender column, and the Gender in the CurrentGrade column. The MI is blank. I've run it in debug, and the correct values are in the correct subitems. But for some reason, when the ListViewItem is added to the ListView, the subitems get all jumbled.
I feel like I must be missing something obvious.I have a listview with 6 columns. The first, hidden, is a key value. The other five are FirstName, MI, LastName, Gender, and CurrentGrade.When I go to populate the listview, I pull a datatable and do this:
For Each dr As DataRow In dt.Rows
Dim lvi As New ListViewItem(dr("StudentKey").ToString)
For i As Integer = 1 To 4
[code].....
Im desperately trying to populate my Listview called "Listview1" with my stored procedure that I have create on my SQL Server 2005. Ive got quite far as seen below but I still dont know to to effectively populate the Listview1 with the data retrieved from my Stored Procedure. The below connection does work but I dont know how to use it now with my Listview.
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I'm having this
vb.net
Dim strQuery As String = "SELECT * FROM tblHistory" ' ORDER BY moniDate DESC"
Try
'~~~ Create the connection
[code]....
This is in the Form_Load to populate a ListView control. But I'm getting the following error:
InvalidArgument=Value of '1' is not valid for 'index'.
Parameter name: index
Where am I doing it wrong?
I have a tab control in my form and inside it I put a listview. What I wanted to do is populate the listview everytime I clicked on each tab. But I don't know how to do it.
Here is the bit of my code
Public Class Form2
Private Sub PopulateRecords()
Dim TSR As New ADODB.Recordset
Dim STRSQL As String = ""
[code]....
I want to show a list of files and folders (names + their icons) inside a given directory with a ListView control or equivalent. I understand that ExtractAssociatedIcon gives you the icon of a file, not a folder. So what are my options for this objective? I don't really have a problem if I have to separate folders and files like the following.
Dim fi As New IO.DirectoryInfo(f) 'f is the path of a given directory
For Each subfolder As IO.DirectoryInfo In fi.GetDirectories()
ImageList1.Images.Add(My.Resources.FolderIcon)
[Code]....
I'm doing an MP3 playlist project for uni and I'm struggling with populating the List View with the XML received from a web service.
[Code]...
Here is the code I am playing around I am getting error populating the table cells into my listview. In my codes it is always add only in one cloumn in my lv.
Private Sub DumpTables()
Dim t, c As Integer ' Used to count tables and cells.
Dim IWebDocument As HTMLDocument
[Code]....
Most of the project I do, I use the datagridview to display the data from the database. What is the different between the datagridview and listview? If I want to display the data from the database, should I use the datagridview or the listview?
View 4 Repliesi'm have a payment form and a listview in this form. i'm adding about 3 item in the listview, so it has 3 row. but how can i insert the items in one of the column into database.
for example for listview
id item netmount
123 Stock1 113.00
[code]....
What I want is that when i select the data from the listview1 it will also delete the corresponding data in the database im using mysql database...these is my code
Dim Button = MessageBox.Show _
("Are you sure you want to delete this Data?", _
"Message", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1)
[Code].....
so far that is my code..it work but in order to delete the data from database i use the datagridview does not what i want ,what I want is that when i select the item in the listview the corresponding data in the listview it will also delete in database... that code i post is that u need to select the data in listview1 and also select the data from the datagridview in order to delete the data in database..
i have codes for adding data to listview from database but there's a problem ..
Public Sub showmyrecords()
Dim lvi As ListViewItem
Dim dt As New DataTable
[code].....
My first thread to as for something here but i like daniweb a lot i'm trying to save data from listview to sql server[code]...
View 10 Replies
