mysql - How can i display multiple result in a series of textboxs? -

i have problem populating multiple data multiple textboxes. i've attached link project guys can picture.

thank in advance! i'm no wiz programmer. :)

edit: heres code

` dim con mysqlconnection = new mysqlconnection("data source=localhost; user id=root; password=dctvmainadmin; database=tmsdctv")     dim query string = "select * recordedattendance empno = '00111' , dateattended = '2014-02-03 mon'"     dim reader mysqldatareader     dim result new system.data.datatable      con.open()     dim cmd_read_name new mysqlcommand(query)     cmd_read_name.connection = con     result.load(cmd_read_name.executereader)      me         each dtrow datarow in result.rows             .lblempno.text = dtrow(0)             .lbldate1.text = dtrow(1)             .txttimein1.text = dtrow(2)             .txttimeout1.text = dtrow(3)         next         con.close()     end with` 

try this:

specifing textbox lable name like:

lblempno1,lblempno2,lblempno3.., lbldate1,lbldate2,lbldate3...., txttimein1,txttimein2,txttimein3..., txttimeout1,txttimeout2,txttimeout3....

 dim con mysqlconnection = new mysqlconnection("data source=localhost;   user id=root; password=dctvmainadmin; database=tmsdctv")     dim query string = "select * recordedattendance empno     = '00111' , dateattended = '2014-02-03 mon'"     dim reader mysqldatareader     dim result new system.data.datatable      con.open()     dim cmd_read_name new mysqlcommand(query)     cmd_read_name.connection = con     result.load(cmd_read_name.executereader)         xi integer=0 result.rows.count-1             controls("lblempno" & xi+1  &).text  .text = result.rows(xi).item(0)             controls("lbldate" & xi+1  &).text = result.rows(xi).item(1)             controls("txttimein" & xi+1  &).text = result.rows(xi).item(2)             controls("txttimeout" & xi+1  &).text = result.rows(xi).item(3)         next         con.close()