State & City Management

States

IdState NameRemove

Add State


Cities

IdCity NameState NameIs CapitalInfoRemove

Add City


Find City Details


Business requirement — Database Operation 2

Help users quickly find a state by entering part of its name.

  1. Add a State Name search input above the state table.
  2. Filter records without requiring an exact case-sensitive match.
  3. Refresh the list when Search is selected.
  4. Show all states again when the input is cleared.