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.

Recommended Answers

All 2 Replies

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
   'Codes To Show Data 

Hope it helps you

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.