[RESOLVED] ListView Issue

[forgottenhart]

I am having issues getting all of my data into my listview
I know the query is correct and the connection is correct but it is only populating one column.

I figure I am missing something in my foreach loop but can not figure out what exactly.

private void LoadListView()
        {
        	listView1.Clear();
        	
        	listView1.View = View.Details;
			
        	ColumnHeader columnHeader1 = new ColumnHeader();
        	listView1.Columns.Add("ID Number",75);
			
			ColumnHeader columnHeader2 = new ColumnHeader();
			listView1.Columns.Add("Date Assingned",125);
			
			ColumnHeader columnHeader3 = new ColumnHeader();
			listView1.Columns.Add("Time Assinged",125);
			
			ColumnHeader columnHeader4 = new ColumnHeader();
			listView1.Columns.Add("Email",200);
			
			ColumnHeader columnHeader5 = new ColumnHeader();
			listView1.Columns.Add("Agent Assigned to Email",175);
			
			int x = 0;
			string myString = "Select  *  from inbox ORDER BY i_id DESC";
			myconnection.Open();
			SQLiteCommand myQuery = new SQLiteCommand(myString, myconnection);		
			SQLiteDataAdapter myQueryAdaptor = new SQLiteDataAdapter(myQuery);
			DataSet myDataSet = new DataSet("myList");
			myQueryAdaptor.Fill(myDataSet,"myList");
			
			string[] myListArray = new string[myDataSet.Tables[0].Rows.Count];
			
			foreach(DataRow row in myDataSet.Tables[0].Rows)
			{
				/*
				myListArray[x] = row["i_id"].ToString();
				listView1.Items.Add(myListArray[x].ToString());
				
				j++;
				*/
				myListArray[x] = row["i_id"].ToString();
				ListViewItem listItem =new ListViewItem(row["i_id"].ToString());
				listView1.Items.Add(myListArray[x].ToString());
				listItem.SubItems.Add(row["i_date"].ToString());
				x++;
				
			}
			
			
			myconnection.Close();
        }

[forgottenhart]

figured it out, I was right it was in my foreach loop

Now if someone has a better way, I am always up for learning something different.

foreach(DataRow row in myDataSet.Tables[0].Rows)
			{
				/*
				myListArray[x] = row["i_id"].ToString();
				listView1.Items.Add(myListArray[x].ToString());
				
				j++;
				*/
				myListArray[x] = row["i_id"].ToString();
				
				ListViewItem listItem =new ListViewItem(row["i_id"].ToString());
				//listView1.Items.Add(myListArray[x].ToString());
				listView1.Items.Add(listItem);
				listItem.SubItems.Add(row[1].ToString());
				listItem.SubItems.Add(row[2].ToString());
				listItem.SubItems.Add(row[3].ToString());
				listItem.SubItems.Add(row[4].ToString());
				x++;
				
			}