Row Level Access Data Reading

[Dudestreet]

Hi Friend,

Could you please help me with Row level Access Data reading?
What I mean to say is(PFA Screenshot)
Click Here

Suppose I only need to read the Row with "EmpID" AA/0141/D/12749, how can I do it?
Keep in mind that It is always going to be a random row based on an Employee's login detail.

[Santanu.Das]

You can do it by a SQL Statement with a 'Where' Clause to match EmpID. Like

Dim EmpComd as new OleDb.Data.OledbCommand

EmpComd.CommandText = "Select * From LOgInTable Where EmpID='" & TxtEmpID.Text & "'"

EmpComd.Connection = Conn

Dim EmpDtRd as OleDbDataReader = EmpComd.ExecuteReader

If EmpDtRd.HasRows then
   EmpDtRd.Read()
   ''''''
   'Codes To Show Data 
   ''''''''
EndIf
EmpdtRd.Close()
EmpComd.Dispose()
Conn.close()

Hope it helps you

[Dudestreet]

Yes. It works.
Thank You very much!! :)