Hi
about selected index changed event refer MSDN article:
MSDN-ListControl Selected Index Changed Event[
^]
In that event, just update the database table using below sql query by passing the selected value of the dropdown list
Declare @year int
set @year = @dropdownvalue
update table1 set year=@year
GO
hope this helps.