How do I add an image to the listviewbox?

Question

1.00/5 (1 vote)

See more:

Hello,

I've written some code to pull information from my SQL server and it is working marvelously, however I don't have the slightest idea how it can populate the actual image within SQL.

VB

UserListView.View = View.Details
        UserListView.GridLines = True
        Dim strQ As String = String.Empty
        strQ = ("SELECT tblUser.UserPicture AS 'Picture', tblUser.EmployeeNum AS 'Employee#', tblUser.UserLastName AS 'Last Name', tblUser.UserFirstName AS 'First Name', tblUser.UserEmail AS 'Email', tblUser.UserInactive AS 'Inactive' FROM tblUser INNER JOIN tblUserTerminals ON tblUser.XID=tblUserTerminals.UserXID WHERE tblUserTerminals.TerminalXID = '" & ValueTextBox.Text & "' AND tblUser.EmployeeNum <> '0' ORDER BY tblUser.UserLastName, tblUser.UserFirstName ASC")
        command = New SqlCommand(strQ, con2)
        DA = New SqlDataAdapter(command)
        DS = New DataSet
        DA.Fill(DS, "Table")
        Dim i As Integer = 0
        Dim j As Integer = 0
        'Adds the columns to UserListView
        For i = 0 To DS.Tables(0).Columns.Count - 1
            UserListView.Columns.Add(DS.Tables(0).Columns(i).ColumnName.ToString())
        Next
        'Adds the items to UserListView
        For i = 0 To DS.Tables(0).Rows.Count - 1
            For j = 0 To DS.Tables(0).Columns.Count - 1
                ItemColl(j) = DS.Tables(0).Rows(i)(j).ToString()
            Next
            Dim lvi As New ListViewItem(ItemColl)
            UserListView.Items.Add(lvi)
            Dim lviimage As New ListViewItem(ItemColl)

        Next

Any help would be greatly appreciated!

Thanks!

Posted 29-Apr-15 10:52am

kaniption

Add a Solution

Comments

Sergey Alexandrovich Kryukov 29-Apr-15 17:00pm

What is "listviewbox"?
And what would you mean by "ListView". Which one? Full type name, please.
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Accepted Answer · 2015-04-29T11:07:00

Major part of this question has been asked so many times that it would be bad to answer it again. Please see: http://www.codeproject.com/search.aspx?q=database+store+%28bitmaps+OR+images+OR+pictures%29+%28%22ADO.NET%22+OR+%22C%23%22+OR+%22VB.NET%22%29&doctypeid=1%3b5[^].

In many cases, such as with Web sites/application, it would be more practical to store just the image names and store the images themselves in the file system on server side.

Remaining problem is showing images in ListView. But the problem is: you did not specify which type do you mean, exactly. There are different unrelated (but similar) types using this name as a simple type name, so which one? I don't want any guesswork. Always specify full type name. Better yet, just read documentation on this type.

[EDIT]

As to presenting images in the instance of System.Windows.Forms.ListView, you can get the idea in this MSDN articles:
https://msdn.microsoft.com/en-us/library/system.windows.forms.listview.smallimagelist%28v=vs.110%29.aspx[^],
https://msdn.microsoft.com/en-us/library/system.windows.forms.listview.largeimagelist%28v=vs.110%29.aspx[^].

Main thing here is: you have to collect all images in one object of the type System.Windows.Forms.ImageList, the property of the ListView. Then the images shown in the list view will be defined by the indices assigned to the property ImageIndex of the item.

The presentation of the list view depends on the value of View property:
https://msdn.microsoft.com/en-us/library/system.windows.forms.listview.view%28v=vs.110%29.aspx[^],
https://msdn.microsoft.com/en-us/library/system.windows.forms.view%28v=vs.110%29.aspx[^].

—SA