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.
Jump to PostYou 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() '''''' …
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
Yes. It works.
Thank You very much!! :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.