Load data into ListView from DataBase in C#

Handling vast volumes of data is becoming a normal practice in today’s digital era, and storing them in a database is a crucial part. However, getting and showing this data in an understandable manner might be difficult. In this post, we’ll look at how to use C# to Load data into ListView from DataBase in C#.

Understanding Listview

Before we go into the specifics of loading data into Listview from a SQL Server database, it’s important to understand what Listview is. The Listview control in C# displays data in a tabular style. It enables users to effortlessly sort, filter, and pick data. Listview is a great control for displaying big amounts of data because it has a lot of customization possibilities and is very user-friendly.

Creating a Connection to the SQL Server Database

Following the installation of the SQL Server database, the following step is to connect to it using C#. The SqlConnection class is one of the most often used techniques in C# for establishing a connection to the SQL Server database.

SqlConnection cnn = new SqlConnection("Data Source=MachineName;Initial Catalog=DatabaseName;Integrated Security=True");

Data Loading into a Listview

Following the establishment of the connection, the data from the database is loaded into a listview. The instructions below demonstrate how to load data into a listview using C#:

Create Query to Retrieve Data from SQL Server Database

String sql = "Select Employeeid, FirstName, LastName from Employees";

SqlCommand cmd=new SqlCommand(sql,cnn);

 SqlDataReader Reader = cmd.ExecuteReader();

while(Reader.Read())
            {
 
 ListViewItemlv = new ListViewItem(Reader.GetInt32(0).ToString());
                lv.SubItems.Add(Reader.GetString(1));
                lv.SubItems.Add(Reader.GetString(2));
                listView1.Items.Add(lv);
 
 
            }

Full Source Code

usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
 
namespaceListViewTutorial
{
    public partial class Form1 : Form
    {
       stringcon = "Data Source=MachineName;Initial Catalog=DatabaseName;Integrated Security=True";
 
        publicForm1()
        {
            InitializeComponent();
        }
 
        privatevoid Form1_Load(objectsender, EventArgs e)
        {
            listView1.GridLines = true;
            listView1.View = View.Details;
 
            //Add Column Header
 
            listView1.Columns.Add("Employee ID", 150);
            listView1.Columns.Add("First Name", 150);
            listView1.Columns.Add("Last Name", 150);
        }
 
 
        privatevoid button1_Click(objectsender, EventArgs e)
        {
            
   // Chnage sqlquery and table name
 
         stringsql = "Select Employeeid,FirstName,LastName from Employees";
            SqlConnectioncnn = new SqlConnection(con);
            cnn.Open();
            SqlCommandcmd=new SqlCommand(sql,cnn);
            SqlDataReaderReader = cmd.ExecuteReader();
 
            listView1.Items.Clear();
 
            while(Reader.Read())
            {
 
 ListViewItemlv = new ListViewItem(Reader.GetInt32(0).ToString());
                lv.SubItems.Add(Reader.GetString(1));
                lv.SubItems.Add(Reader.GetString(2));
                listView1.Items.Add(lv);
 
 
            }
 
             Reader.Close();
            cnn.Close();
 
        }

Listview Customization

Listview allows for extensive customization, such as changing the background color, font, and size, as well as adding photos to the control. You can make the listview more user-friendly by customizing it to match the theme of your application.

Conclusion

In this post, we looked at how to use C# to Load data into ListView from DataBase in C#. We’ve seen that Listview is an amazing control for displaying big amounts of data, with numerous customization possibilities. You may quickly load data from a SQL Server database into a listview control and provide a user-friendly interface to your application by following the methods outlined above.

More Related Post

How to Load Data into ListView from MySQL, Remove Special Characters in a string

FAQs

What exactly is a listview in C#?

In C#, a listview is a control that shows data in tabular format. It enables users to effortlessly sort, filter, and pick data.

What exactly is SQL Server?

SQL Server is a relational database management system. It is commonly used for data storage and retrieval.

How can I create a C# connection to a SQL Server database?

In C#, you may use the SqlConnection class to connect to a SQL Server database. You must supply the required connection string, which includes the server name, database name, username, and password.

In C#, how do I load data from a SQL Server database into a listview?

To load data from a SQL Server database into a listview control in C#, first, create a query to retrieve the data, then a SqlCommand object, then a SqlDataAdapter object, then a DataTable object to store the data, then fill the DataTable with data from the SqlDataAdapter, and finally load data from the DataTable to the listview control.

Is it possible to modify the listview control in C#?

Yes, the listview control can be customized in C#. To complement the theme of your application and make it more user-friendly, you can modify the background color, font, and size, as well as add photos to the control.