How to display the values from db to frontend

vikram reddy

11y1.2k.NET

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

samplequestion2

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Praveen Kumar11y ago
Accepted 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()+" ";
}
}
0
Inathi Gqola11y ago
Hi Vikram and Praveen,

Yes, Praveen is absolutely correct. All we needed to do was Label1.Text = ...

Happy coding, guys!
0
vikram reddy11y ago
Hi Praveen Kumar

Great Thank for ur replay
now i understand my problem
0
Saroj Kumar Sahu11y ago
Hi,
Please try the below code:

for (int i = 0; i < dt.Rows.Count; i++)
{
for (int col = 0; col < dt.Columns.Count; col++)
{
Lable1.Text += dt.Rows[i][col].ToString() + Environment.NewLine;
}
}

0
Praveen Kumar11y ago
Hi Vikram Your code was fine but It was displaying only last record because your were not concatenating the record on label.
+1
vikram reddy11y ago
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".
0

Hi Vikram,

foreach(DataRow row in dt.Rows)
 { 
   //edited to concanate the values.

   Lable1.Text += row["qname"].ToString(); 

 }