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 { Lable1.text=dt.rows[i][qname].tostring(); } but didnt display all qname Please solve this issue

Praveen · Answer

It will display all question name: DataTable dt=new DataTable(); //Fetch data from database and assign into dt Lable1.Text=; for(int i=0; i { Lable1.Text+=dt.Rows[i][qname].ToString()+ ; } Now you could get the output like following Output: samplequestion1 samplequestion2 But if you want to display entire columns of Question table then you can do it for(int i=0; i { for(int col=0; col { Lable1.Text+=dt.Rows[i][col].ToString()+ ; } }

Praveen · Answer

Hi Vikram Your code was fine but It was displaying only last record because your were not concatenating the record on label.

Inathi Gqola · Answer

Hi Vikram and Praveen Yes Praveen is absolutely correct. All we needed to do was Label1.Text = ... Happy coding guys!

vikram reddy · Answer

Hi Praveen Kumar Great Thank for ur replay now i understand my problem

Saroj Kumar Sahu · Answer

Hi Please try the below code: for (int i = 0; i { for (int col = 0; col { Lable1.Text += dt.Rows[i][col].ToString() + Environment.NewLine; } }

vikram reddy · Answer

Hello Inathi Gqola Thank you for replay I the code u posted i tryed that already i show the last record only i want to display all qnames.

Inathi Gqola · Answer

Hi Vikram foreach(DataRow row in dt.Rows) { //edited to concanate the values. Lable1.Text += row[qname].ToString(); }