How to Retrieve Data from ListView to Display in Textbox using VB.Net

Retrieve Data from ListView to Display in Textbox using VB.Net

Retrieve Data from ListView to Display in Textbox using VB.Net.

In this tutorial, you will learn How to Retrieve Data from ListView to Display in Textbox using VB.Net.

First, create your own project and then follow this sample image:

How to Retrieve Data from ListView to Display in Textbox using VB.Net

To modify your ListView, follow these steps:

  1. Click the small play button located at the upper right side of your listview, then set the View property to Details and click Edit Columns.
  2. On the Edit Columns, add four columns and rename the column header to Name, Gender, Age and Address and adjust its length depending on the size of your listview.

Now on our form load event, we will add line of codes to add values to our list view.

[vbnet]

Dim p As ListViewItem

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
p = New ListViewItem("Kane Hero Cruz")
p.SubItems.Add("Male")
p.SubItems.Add("20")
p.SubItems.Add("Iloilo City")
ListView1.Items.Add(p)
End Sub

[/vbnet]

As you run your system, this will be your output:

How to Retrieve Data from ListView to Display in Textbox using VB.Net

Next, double click your listview and add this line of code for us to retrieve the data from the listview and pass it on our text boxes.

[vbnet]

Private Sub ListView1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ListView1.SelectedIndexChanged
If ListView1.SelectedItems.Count > 0 Then
TextBox1.Text = ListView1.SelectedItems(0).SubItems(0).Text
TextBox2.Text = ListView1.SelectedItems(0).SubItems(1).Text
TextBox3.Text = ListView1.SelectedItems(0).SubItems(2).Text
TextBox4.Text = ListView1.SelectedItems(0).SubItems(3).Text
End If
End Sub

[/vbnet]

Then, run again your system and try to click on Kane Hero Cruz’s details. You can see that it passes the values on our text boxes when we click it. Here’s the result:

How to Retrieve Data from ListView to Display in Textbox using VB.Net

Congratulations! You have learned how to retrieve data from your listview to your text boxes.

For questions or any other concerns or thesis/capstone creation with documentation, you can contact me through the following:

E-Mail: [email protected]

Facebook: facebook.com/kirk.lavapiez

Contact No.: +639771069640

Ian Hero L. Lavapiez

BSIT Graduate

System Analyst and Developer

Related topic(s) that you may like:

 

 

 

Frequently Asked Questions

How does this VB.NET ListView example work?

ListView control in VB.NET WinForms: populating with items + subitems, column sorting, multiple-selection, image-list integration, view modes (Details/LargeIcon/SmallIcon/Tile/List).

What Visual Studio and SQL Server versions does this VB.NET project require?

Most projects use VB.NET WinForms on .NET Framework 4.5+ with SQL Server 2012 Express or higher. To run: install Visual Studio 2019 / 2022 (Community is free) with the ‘Desktop development with .NET’ workload, install SQL Server Express + SSMS, open the .sln file, build, run.

How do I set up the database for this VB.NET project?

Open SQL Server Management Studio (SSMS) and connect to your SQL Server (e.g. localhost\SQLEXPRESS). Right-click Databases, choose Restore Database OR New Database then import the included .sql script. Update the connection string in App.config (or in code-behind Module) with your server name + credentials. Rebuild and run.

Can I use this VB.NET project for a BSIT capstone or thesis?

Yes, VB.NET is one of the most accepted languages by Philippine BSIT panels. Extend it: add role-based access (admin/staff/customer login redirect), Crystal Reports or RDLC reports, dashboards with Chart control, audit log, multi-branch support. Pair with Chapter 1-5 documentation matching your panel’s rubric.

Why am I getting ‘connection error’ or ‘cannot find SQL Server’?

Three common VB.NET issues: (1) Connection error: SQL Server isn’t running. Open SQL Server Configuration Manager and verify SQL Server (SQLEXPRESS) service is started. (2) Wrong server name in connection string. Try .\SQLEXPRESS, (local)\SQLEXPRESS, or your machine name. (3) Login failed: SQL Server is set to ‘Windows-only’ authentication. Switch to Mixed Mode in SSMS Server Properties, Security.

Where can I find more VB.NET projects with source code?

Browse the VB.NET Projects hub for the full library. For C# WinForms alternatives see C# Projects. For ASP.NET web alternatives see ASP.NET Projects. For BSIT capstone idea lists see 150 Best Capstone Project Ideas.

Leave a Comment