I'm trying to read from a sql server database to add a large image and underneath the image, the text, to the listview. I thought I had it correct. However it is only adding the text and no image. Is there something I'm missing?
public void DisplayUsers()
{
listView1.Items.Clear();
SqlConnection c = new SqlConnection("Integrated Security=True;initial catalog=BugTracker;data source=(local)");
c.Open();
using (c)
{
SqlCommand sqlCmd = new SqlCommand("select UserName, Photo from [User]", c);
sqlCmd.ExecuteNonQuery();
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
DataSet list = new DataSet();
adapter.Fill(list);
for (int i = 0; i < list.Tables[0].Rows.Count; i++)
{
string userName = tree.Tables[0].Rows[0].ToString();
ListViewItem item = new ListViewItem(userName);
int nImage = _userImageList.Images.Count;
_userImageList.Images.Add((Image)tree.Tables[0].Rows[1]);
listView1.LargeImageList = _userImageList;
listView1.Items.Add(userName, nImage);
}
}
c.Close();
// Always when adding new elements into a List view, make sure that
// at least one item is selected.
if (listView1.Items.Count > 0)
{
listView1.Focus();
listView1.Items[0].Selected = true;
}
}
public void DisplayUsers()
{
listView1.Items.Clear();
SqlConnection c = new SqlConnection("Integrated Security=True;initial catalog=BugTracker;data source=(local)");
c.Open();
using (c)
{
SqlCommand sqlCmd = new SqlCommand("select UserName, Photo from [User]", c);
sqlCmd.ExecuteNonQuery();
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
DataSet list = new DataSet();
adapter.Fill(list);
for (int i = 0; i < list.Tables[0].Rows.Count; i++)
{
string userName = tree.Tables[0].Rows[0].ToString();
ListViewItem item = new ListViewItem(userName);
int nImage = _userImageList.Images.Count;
_userImageList.Images.Add((Image)tree.Tables[0].Rows[1]);
listView1.LargeImageList = _userImageList;
listView1.Items.Add(userName, nImage);
}
}
c.Close();
// Always when adding new elements into a List view, make sure that
// at least one item is selected.
if (listView1.Items.Count > 0)
{
listView1.Focus();
listView1.Items[0].Selected = true;
}
}