I've right clicked on my project in Solution Explorer and selected "Add Reference", but in the ".Net" tab there is no entry for "System.Data.dll" for me to select!

My project does not fill the list box, and I've even tried the downloaded example and it doesn't work either.

Any ideas why I don't seem to have System.Data.dll and how I might be able to get it?

Thanks!

Well, duh. Access was still open, and now the project works perfectly!

However, I still don't have an entry for System.Data.dll to add to references. Any ideas?

In the Add Reference dialog, click on the .NET tab and scroll down until you see System.Data. System.Data.dll is the actual name of the file and I may have confused you on this.

Thearon

Thanks!

Later on in the book it's clearer. What's the difference between referencing System.Data and importing it in the code?

The book was written against the pre-release version of Visual Studio 2005 and that version did not automatically reference the System.Data.dll. The release version does however so you really don't need to set a reference to it or import it. Importing the System.Data namespace just prevented you from having to prefix the classes in that namespace with the fully qualified namespace (e.g. DataSet would have to be System.Data.DataSet without the imports statement).

This has all been fixed in the released version of Visual Studio 2005.

Thearon