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
hope this helps.