Have created boxes but I now want to do a count down?

[MASHUUD]

Creating an Archive, and with the archive I have Shelves,Compartments and Boxes.
Assuming with the shelves I created a shelfName, and I gave the compartment Quantity (5).
I now want to be able to determine if the user has exhausted all the (5) by creating compartments.

This what I am doing and it is not working




rs = con.ReturnQuery("select * from Shelves where Deleted=0 and ShelfNames= '" + cbxSHELF.Text + "'");

int qty;
int count = 0;
while (rs.Read())

{
qty = Convert.ToInt32(rs["CompartmentQty"].ToString());

count = count + 1;


if (count != qty)
{
MessageBox.Show("Shelf is Full");
}
}

[Rabbit]

You haven't shown us any sample data and you haven't said what's not working.