need urgent assistance

hi, suppose i have 400 entries in my table right, every record has 3 attributes, i.e.

S.no, Product Name, Product Company

now these 400 entries belongs to different companies about 20 apporximately. now i want that when i enter retrieve any 4 entries in whcih 2 belongs to 1 compnay and 3 belongs to other company, so it shows me data separately, mean to say that

colpol 123 compnay
panadol 123 compnay


piriton 44 compnay
incidal 44 company
broxol 44 compnay

how do i do it?

From reading this my understanding is that you want to select 4 random records from a DataTable. You then proceed to show 5 in your example. You will probably need to explain further.

Quote:

---

Originally Posted by ForumAccount

From reading this my understanding is that you want to select 4 random records from a DataTable. You then proceed to show 5 in your example. You will probably need to explain further.

---

for detail understanding you please check this post, which i have posted earlier but got no answer?

http://www.vbforums.com/showthread.php?t=648387