Load data into listview from Mysql Database using C#

- by Ahmed S

In this article, we will see how to load data into listview from MySql Database using C sharp Windows Application. 

Install the Xampp or Wamp server in your computer or laptop and run it. Now open Visual Studio and create a new project.

Add Mysql.data.dll 

using System;

using Syst.emCollections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;
namespace ListViewTutorial

{

    public partial class frmListview : Form

    {

        public frmListview()

        {

            InitializeComponent();

        }

        private voidbutton5_Click(object sender, EventArgs e)

        {

             string con1 = “Data Source=localhost;Initial Catalog=test;uid=root”;

                       

            MySqlConnection  cnn = new MySqlConnection(con1);

            cnn.Open();

            string sql = “Select * from student”;

            MySqlCommand   cmd = new MySqlCommand(sql, cnn);

            MySqlDataReader  Reader = cmd.ExecuteReader();

            listView1.Items.Clear();

            while (Reader.Read())

            {

                ListViewItem lv = new ListViewItem(Reader.GetInt32(0).ToString());

                lv.SubItems.Add(Reader.GetString(1));

                lv.SubItems.Add(Reader.GetString(2));

                listView1.Items.Add(lv);

            }

            Reader.Close();

            cmd.Dispose();

            cnn.Close();

        }

        private voidfrmListview_Load(object sender, 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);

        }

    }

}



Related Posts

About Ahmed S

View all posts by Ahmed S →

One Comment on “Load data into listview from Mysql Database using C#”

Leave a Reply

Your email address will not be published. Required fields are marked *