I have one table with name Subject and two columns SubId,SubName and Year .In this table I added multiple subject names based on year.
From this, in front end design there is a dropdown list having binding Year rows from Subject Table from Database. When I select particular year the subject names should come in Labels only.
How can I write code for this requirement?