How to bind database table rows to the label in asp.net

Question

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? 

Answer 1

get data from database to dataset ds

 

and on dropdown selected index

 

lblname.Text= ds.Tables[0].Rows[0]["subject"].Tostring();