MS Access table Lookup in VB.NET
1 view
Skip to first unread message
Cameron
Nov 19, 2009, 7:35:35 AM11/19/09
to DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting, cam....@us.schneider-electric.com
Using Visual Basic 2008, could anyone show me the code to pull the
First and Last Name from the MS Access table below if I know the Login
Name?
Assumptions: tblEmployee is in a database named C:\DB1.MDB.
tblEmployee
Login nameFirst nameLast
mpb001 Cam Eller
mpb002 Gary Brooks
mpb003 Dodd Brown
mpb004 Michael Burgess
mpb005 Carol Casper
mpb006 Bruce Davis
mpb007 Stephen Davis
mpb008 Robbie Fulton
mpb009 Eddie Hall
mpb010 Tim Kizziah
mpb011 Jackie Leonard
mpb012 Michael Long
mpb013 Robert Long
mpb014 Bart Mercer
mpb015 Ron Miller
mpb016 Brenda Mills
mpb017 Kelly Morrison
mpb018 Kim Nance
Thanks in advance!
Cam
First and Last Name from the MS Access table below if I know the Login
Name?
Assumptions: tblEmployee is in a database named C:\DB1.MDB.
tblEmployee
Login nameFirst nameLast
mpb001 Cam Eller
mpb002 Gary Brooks
mpb003 Dodd Brown
mpb004 Michael Burgess
mpb005 Carol Casper
mpb006 Bruce Davis
mpb007 Stephen Davis
mpb008 Robbie Fulton
mpb009 Eddie Hall
mpb010 Tim Kizziah
mpb011 Jackie Leonard
mpb012 Michael Long
mpb013 Robert Long
mpb014 Bart Mercer
mpb015 Ron Miller
mpb016 Brenda Mills
mpb017 Kelly Morrison
mpb018 Kim Nance
Thanks in advance!
Cam
Reply all
Reply to author
Forward
0 new messages