Try this:
connectinString = "Data Source = " + fileName + ";max database size=256";
using (conn = new SqlCeConnection(connectinString))
{
using (md = new SqlCeCommand("SELECT COUNT(*) FROM Pigeons", conn))
{
conn.Open();
label1.Text = cmd.ExecuteScalar().ToString();
}
}