Display records in a listview (windows) from the database

In this blog we will know how to display records in a listview (windows) from the database.

 

 

 

Code

 

App.config

 

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<appSettings>

            <add key="dsn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\EMP.mdb" />

      </appSettings>

</configuration>

 

 

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Listview_display

{

    public partial class Form1 : Form

    {

        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];

        OleDbCommand com;

        OleDbDataAdapter oledbda;

        string str;

        DataSet ds;

        DataTable dt;

 

        public Form1()

        {

            InitializeComponent();

        }

 

        private void Form1_Load(object sender, EventArgs e)

        {

            listView1.Columns.Add("ID", 70, HorizontalAlignment.Center);

            listView1.Columns.Add("GRADE", 70, HorizontalAlignment.Center);

            listView1.View = View.Details;

            listView1.GridLines = true;

            listView1.BackColor = Color.Aqua;

            listView1.ForeColor = Color.Blue;

            OleDbConnection con = new OleDbConnection(ConnectionString);

            con.Open();

            str = "select * from test Query";

            com = new OleDbCommand(str, con);

            oledbda = new OleDbDataAdapter(com);

            ds = new DataSet();

            oledbda.Fill(ds, "test Query");

            con.Close();

            dt = ds.Tables["test Query"];

            int i;

            for (i = 0; i <= dt.Rows.Count - 1; i++)

            {

                listView1.Items.Add(dt.Rows[i].ItemArray[0].ToString());

                listView1.Items[i].SubItems.Add(dt.Rows[i].ItemArray[1].ToString());

            }

        }

    }

}

 

 

Thanks for reading