How can i read data from excel file and after check need to display in data grid or grid view

My syntax may be off but I used to program with excel so it'll be close enough for you to google the true way.

Use the openfiledialog to allow different file names. You can also put a filter in this dialog to only allow excel documentation.

Make sure to attach Microsoft.Interop.Excel(whichever version you need)

then inside your form do something along the lines:

#import interop.excel

public class myClass

private sub LoadFile

if openfiledialog.ok
dim newExcelFile as file = openfiledialog.path
newexcelfile.open
while newexcelfile.rows(idx).cells(0) is not nothing
if newexcelfile.rows(idx).cells(0) = 3
addtomyDataGrid(newexcelfile.rows(idx)) 
endif
idx += 1
end while
end if
end sub
end class