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 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 RepliesI 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'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]...
What 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 am trying to do an assignment for a programming class. The program works for items that are in the list boxes, but when I test one that is not (and a message box should then pop up) I get this error message instead.ArgumentOutOfRangeException was unhandled the InvalidArgument = Value of '5' is not valid for 'index'Parameter name = index
Here is my code...
Private Sub displayShippingButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles displayShippingButton.Click
Dim isFound As Boolean
[code]....
I get an ArgumentOutOfRangeException was unhandled error,
Specified argument was out of the range of valid values.
Parameter name: index when I try to populate a treeview in VB.Net 2010. Below is my code. How do I fix this error?
[Code]...
When I try to debug this code. I got an error like this.
Module Module1
Public Declare Auto Sub mouse_event Lib "user32.dll" (ByVal dwFlags As Long, ByVal dx As Long, ByVal dy As Long, ByVal cButtons As Long, ByVal dwExtraInfo As Long)
[code]....
It's about "System.Console.SetCursorPosition(130, 345)" how do i fix this?
It's something with "ArgumentOutOfRangeException was not unhandled".
Can 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 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]....
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 my listview using database.
View 2 Replieshow 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 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 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]....
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 RepliesHere 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]....
I would like to enquire how I would go about population a chart (bar graph) in VB 2010 Professional?
I am pulling the information from a MS SQL Database.
I am trying to populate a dropdownlistbox with data returned from the database. I have a ClaimID & ClaimType. I can't seem to get the syntax correct.
View 2 RepliesI am new to winforms and I am trying to populate a dropdownlistbox with data returned from the database. I have a ClaimID & ClaimType
View 7 Repliesit doesnt like my code:
Dim n As Integer
Dim flag As Boolean
Dim i
[code].....
I want to poplate a checked list box based on a column from a datasource or standard listbox based on a selection from a combobox adding each item as I select it in the combo box.
Obviously populating direct from the data source would be best
Is there a way to populate the value in a dropdown? I am using the following command:
ComboBox1.Items.Add(DropDownData)
I am getting the following message from this code and I cant figure out how to fix it: ArgumentOutOfRangeException was unhandled
View 8 RepliesI'm working on a new version of something I had created years ago in VB6. What I was doing then is populating a combobox with lines from a sequential file ("title","URL") like this:
Open "data.dat" For Input As #1
Do While Not (EOF(1))
Input #1, NameInput, URLInput
cmbEntry.AddItem NameInput
Loop
And then checking against it on a button click to load the URL associated with the selected name:
Open "data.dat" For Input As #2
Do While (cmbEntry.Text <> NameInput) And (Not (EOF(2)))
Input #2, NameInput, URLInput
Loop
[Code] .....
What I'm trying to do in Visual Basic 2010 is the same process, though I'll be including a third field ("category","title","URL") to determine which one of four different comboboxes I add the entry to. I know I need to use streamreader, but I'm not finding much in the way of documentation or examples on how to do what I'm trying to do, which is:
- Populate one of four comboboxes with the second value in each line of an external text file, based on the first value in that line
- Set a string to the third value in a line of an external text file, based on the second value of that line
How to read these values from the file.
I am trying to create a basic quoting tool but got stuck on how to clear and change the item collection from within a combobox for a datagrid.What we have is a list of 4 columns like a. Device b.TypeofService c.State d.Price Inside a sql database. Data is also structure like above as well.
I have a datagridview where the user will populate a,b,c and the price will be display and a total at the end. However a,b, and c aren't related in my current application. The combobox will show all possible dinstinct values for each column.
This works fine but I want to refine the application to only show the values of b. which are in the database after the user select the value for a. I have tried searching on how to do this as I assume to the Contry/State/City situation but could not find anything for a datagridview control in VB.NET.
Can anyone point me in the right direction? If I cannot do this dynamically from within a datagridview I was thinking of maybe creating three combo box outside and having it populating the datagridview afterwards but it wouldn't be as nice.