Hi,
As samanath suggest you to use datagrid, I will also suggest for same. here you can perform multiple other operation also. I am providing you the code to bind the datagrid
string query=null;
query = "select * from Studies";
SqlCeDataAdapter adp = new SqlCeDataAdapter(query, "Data Source=dbname;Persist Security Info=False;");
DataTable dt = new DataTable();
adp.Fill(dt);
if(dt.rows.count >0)
{
dataGridViewStudies.DataSource = dt;
}
check how many rows dt is generating by debug the code
hope this will help you