thnks 4 ur answer but i wsn't askin 2 for finding row index. see i hv an access database "employee". the database contains table "table1" which has columns as stated below:
1. empid - datatype autonumber (primary key) 2. name - datatype text 3. designation - datatype text now i take a variable "a" n input a number in it through inputbox. for eg. i give a=4, now wht i want is d value of variable "a" should b checked with entire "empid" column n whichever row/record contains empid as 4 shud b displayed. I want 2 do dis with ado.net dataset but without sql n i m using textboxes 2 display d data. to b more precise: *"I WANT TO COMPARE A VARIABLE WITH AN ENTIRE COLUMN IN A TABLE OF ACCESS DATABASE IN VB.NET ENVIRONMENT USING ANYTHING BUT NOT SQL"*
