Hi,

I have a strange problem with returning a dataset from a webservice.  Here's
some code...  The error I get at compile time is.
  "Cannot convert type 'void' to 'System.Data.DataSet'"

Can anyone help me please.  I have heard something about typed datasets,
would that make a difference?
Thanks in advance...

John Young

-------------------

Main form code...
private void button1_Click(object sender, System.EventArgs e)

{

CITWebservices.CITWS myWS = new Win_CIT.CITWebservices.CITWS();

DataSet ds = myWS.GetJobServicesList();  // ***** I GET A COMPILE ERROR HERE
*****

myWS.Dispose();

}

WebService code....

[WebMethod]

public DataSet GetJobServicesList()

{

// get a list of the job services available

DataSet ds = new DataSet();

CIT.BackendDB.DatabaseAccess dba = new CIT.BackendDB.DatabaseAccess();

ds = dba.GetJobServicesListFromDB();

return ds;

}

Data access code...

public DataSet GetJobServicesListFromDB()

{

// get the list of job services from the database and return to the
webservice

string sConnectionString = "user id=sa; Initial Catalog=CIT; Data
Source=localhost; Integrated Security=SSPI";

SqlConnection objConn = new SqlConnection(sConnectionString);

objConn.Open();

SqlDataAdapter jobServicesList = new SqlDataAdapter("SELECT Service FROM
tableLookupService", objConn);

DataSet ds = new DataSet();

jobServicesList.Fill(ds,"tableLookupService");

objConn.Close();

return ds;

}