Im following the walkthroughs in the VS.NET 2003 walkthrough booklet.  Im
getting an error when wokring on the webservices one.  Chapter 2 page 29, my
application compiles but when clicking the LoadData button i get the
following message.  Ne suggestions? (using vs.net 2003 pro, sql server 2000
developer, winxp pro)

luke

An unhandled exception of type 'System.Web.Services.Protocols.SoapException'
occurred in system.web.services.dll

Additional information: System.Web.Services.Protocols.SoapException: Server
was unable to process request. ---> System.InvalidOperationException: Fill:
SelectCommand.Connection property has not been initialized.
  at System.Data.Common.DbDataAdapter.GetConnection(IDbCommand command,
String method)
  at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  at AuthorsWebService.AuthorsService.GetAuthors() in
D:\W3Sites\AuthorsWebService\AuthorsService.asmx.cs:line 153
  --- End of inner exception stack trace ---