0

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.
2
Contributors
2
Replies
11
Views
3 Years
Discussion Span
Last Post by Dudestreet
1

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.