How to display the values from db to frontend

Question

Hello one n all

 

How to display multiple values from DB to front end one by one like i have a table called

Question

 

q.id	qname	ans1	ans2	ans3
1	samplequestion1	1	2	3

2

samplequestion2

1

2

3

 

Like this 

how to display using loop qname to lable on front end

i try like this

 

 

DataTable dt=new  DataTable()

 for(int i=0;i<dt.Rows.Count;i++)

{

Lable1.text=dt.rows[i]["qname"].tostring(); 

} 

 

but didnt display all qname

 

Please solve this issue