TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Patrick Grindstaff
NA
6
0
Displaying data from Access DB in C# Program
Dec 7 2005 5:11 PM
Over the past few days I have been working on what is essentially an access database viewer but have run into many problems. I have accomplished listing Names in a combo box but have an interesting situation. The particular database I have to work off of (there are many many others structured the same way) has multiple entries of the same name but is linked to a differant image file, for ex: Name SSN Image File Joe Somebody 123-12-123 someimage1.tiff Joe Somebody 123-12-123 someimage2.tiff Billy Bob 456-45-456 someimage3.tiff Billy Bob 456-45-456 someimage4.tiff You get the idea... Anyway, i have the Name and SSN displayed in a combo box but am getting duplicate entries for each person because the same name spans across multiple rows. I have searched through MSDN and google to no avail while trying to get unique records to show in the combo box. Another problem I am facing is that this certain database stores the path to the image in a seperate table and I am unable to find any information on using one query to felect data from multiple tables (is this possible?). I have also tried to make a 2nd query but was unsuccessful. If anyone has answers to any of the questions/problems above I would greatly appreciate your help.
Reply
Answers (
0
)
DLA
memory