View Single Post
 
Old October 14th, 2003, 11:46 PM
winnie1778 winnie1778 is offline
Authorized User
 
Join Date: Oct 2003
Location: , , Singapore.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal Report Database Connection

Hi!
I got many reports to be viewed in the crystal report.
I'm not sure which database connection to be used for the link.
I will be using a lot of view sql.

1) Which of the database connection best fit to many reports.
ADO.Net, OLE DB, ODBD RDO etc..

2) For Ado.NET, will it allow more than 1 table or 1 view in a dataset?
How to update the dataset if I update or add fields in the sqlServer?
I've been noticed that the dataset will not auto-refresh or update if
I add field in the sqlServer.

Please Help.
thanks.