Adding SDF Data Into A Listview - C#

Hello everyone, I finally got the SDF file on my pocket pc, and now am having trouble loading the data into the listview. I am not sure where I am going wrong, but the code is listed below. Any ideas? Thanks so much, everyone.





private void LoadList(string szSQL)

{

// Clear out anything that might already be in the list

CollectionList.Items.Clear();

// save off the SQL Statement

m_szCurrFilter = szSQL;

// Throw Data into the list

SqlCeCommand sqlLoadEvents = m_cConn.CreateCommand();

sqlLoadEvents.CommandText = szSQL;

SqlCeDataReader rReader = sqlLoadEvents.ExecuteReader();



// roll through the reader and put items into the list

while ( rReader.Read() )

{

ListViewItem lvItem = new ListViewItem(rReader.GetValue(rReader.GetOrdinal("ca_id")).ToString()); //Nmbr

// Note: Since a "tag" is not supported by the compact framework, we'll use the "ImageIndex"

// property to hold the movie ID, this way we can find it later when the user clicks

// on an item

lvItem.ImageIndex = (int)rReader.GetValue(rReader.GetOrdinal("ca_id"));

lvItem.SubItems.Add(rReader.IsDBNull(rReader.GetOrdinal("ca_titel")) ? "" : rReader.GetValue(rReader.GetOrdinal("ca_titel")).ToString()); // Title

lvItem.SubItems.Add(rReader.IsDBNull(rReader.GetOrdinal("ca_alter")) ? "" : rReader.GetValue(rReader.GetOrdinal("ca_alter")).ToString()); // Rating

lvItem.SubItems.Add(rReader.IsDBNull(rReader.GetOrdinal("ca_sex")) ? "" : rReader.GetValue(rReader.GetOrdinal("ca_sex")).ToString());// Gender

CollectionList.Items.Add( lvItem );

}

}