View Single Post
  #2 (permalink)  
Old September 10th, 2008, 08:35 AM
bvdijk bvdijk is offline
Registered User
Join Date: Sep 2008
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Hi Scott,

Since you don't get any error, your connection string must be fine, otherwise the program
would have stopped with an error at the line objConnection.Open

(Although you could leave out objConnection.Open and objConnection.Close, since the DataAdapter
will take care off opening and closing the connection).

The only thing I can think off is that the SQL statement just doesn't return any data, because
- The SQL statement has a typo
- There is no data in (one of) your tables

If checked and doublechecked the code, but I don't see any typo. Can you confirm that all the
three tables have data? (authors, titleauthor, titles)
Reply With Quote