I cannot get my listView to display my database

Question

With my code I have been able to actually access the database and add to it but I will not display in my list view. If someone could help that would be amazing. It is also an access database with oledb

Amit Mohanty · Answer

Hey John, below example may help you.

First set listView1 View property to Details

string connStr = "Data Source=.; Initial Catalog=DemoTest; Integrated Security=SSPI";
string sql = "SELECT Name, City, Department FROM tblEmployee";
listView1.Columns.Add("Name", listView1.Width / 2);
listView1.Columns.Add("City", listView1.Width / 4);
listView1.Columns.Add("Department", listView1.Width / 4);
using (SqlConnection connection = new SqlConnection(connStr))
{
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ListViewItem lvi = new ListViewItem(reader[0].ToString());
for (int i = 0; i <= reader.FieldCount - 1; i++)
{
lvi.SubItems.Add(reader[i].ToString());
}
listView1.Items.Add(lvi);
}
reader.Close();
connection.Close();
}
}
}

Jignesh Kumar · Answer

Hey John,   Please find below link which will help you to resolve your query, https://www.aspsnippets.com/Articles/Populate-Bind-ListView-from-Database-in-Windows-Forms-Application-using-C-and-VBNet.aspx

Laxmidhar Sahoo · Answer

please convey the details like .net window form or wpf or other with some code

Ashutosh Gupta · Answer

John, it is also important form hwere this populate is getting called? are you calling from intilize?

John Runyan · Answer

This is where it populates.

John Runyan · Answer

there is no break point. it's i believe in my form load and it just skips it

Ashutosh Gupta · Answer

i am not sure if your client is wpf, if it is wpf here is solution.   create client side view model and two propeties public Observablecollection Items and public string selectedItem, bind these two with ItemSource and SelectedItem respectivley.

Laxmidhar Sahoo · Answer

hi place the brake point and the show the exception point of line with code