Urgent ! Displaying Data From Db to Label

Posted by .Netlearner under ASP.NET on 4/18/2013 | Points: 10 | Views : 1553 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hello All,

i have 6 label say labelname1,labelname2,labelname3,labelage1,labelage2,labelage3.and my db looks like

ID Name Age
-- -------- ------
1 aaa 20
2 bbb 25
3 ccc 22

i have read data through datareader and got data in array such as String[] name,String[] age.

int i=0;
while(dr.read)
{
name[i]=dr["name"].toString();
age[i]=dr["age"].toString();
i++;
}
labelname1=name[0].toString();
labelname2=name[1].toString();

its working fine but my question is , Is this the right code ? Can it can be done without creating an array. If yes how? Please help.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Ankitsrist on: 4/19/2013 [Member] Starter | Points: 25

0	yeah there is no need to display by taking in array, you can simply write labelname1.Text=dr["name"].toString(); labelname2.Text=dr["age"].toString(); .Netlearner, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: .Netlearner on: 4/19/2013 [Member] Starter | Points: 25

0	if i want to display one column value in one label i can give labelname2.Text=dr["age"].toString(); but i want to display values in one column in different labels, labelname1.Text=dr["age"].tostring(); labelname2.Text=dr["age"].toString(); but i want different age values .Netlearner, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts