Searching multiple records

[qudra]

Hi guys. I need ur help.
In VB.NET we usually use this code to search the database through windows application:
CODE::::::
private sub btnSearch_click(--)
dim empno as byte
empno=inputbox("Enter emp no")
dim r as datarow
r=ds.tables("emp").rows.find(a)
if r is nothing then
Msgbox("Emp not found")
else
t1.twxt=r.items(0)
t2.text=r.items(1)
end if
end sub

By this we can get one emp info. but If i wnt to search another emp's info by providing empno second time, then the first fetched record will be cleared and will get new searched record in the textboxes.

Qns is: I wnt the multiple records should display, so plz tell me how to do that with detail descriptions.
And also if possible plz tell me the same concept in C#.NET with detailed coding.

Waiting for the reply. Thanks in Advance.
Mash.

[kenobewan]

Welcome to the site. Data readers are forward and read only. If you want to display multiple records, then you will need to loop through them. Otherwise you may choose to use another object like a dataset. HTH.