How to load data from database into listview in C#

Question

Hello, How to load data from database into listview in C# (By Executing Some Query)?

Satyapriya Nayak · Answer

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 { listView1.Items.Add(dt.Rows[i].ItemArray[0].ToString()); listView1.Items[i].SubItems.Add(dt.Rows[i].ItemArray[1].ToString()); } } } } Thanks If this post helps you mark it as answer

Nirmal G · Answer

I have two listview boxes and their respective data is being stored in the database. What code I write in code event SelectIndexChanged. Ex: str = "select judgement from casetab WHERE partyname='" + listView1.Items + "'"; Please advise. Thank you, Nirmal

How to load data from database into listview in C#

Hello,

How to load data from database into listview in C# (By Executing Some Query)?

Answers (2)