Passing a String variable to a Web Service

[Deecrypt]

Hi,
Passing a string parameter to a webservice to get the dataset generated
as the result, seems to give me an error suggesting that no parameter
is being passed. However it works if I explicitly state the value as
the parameter. Code in Csharp being developed in VS2005 for ASP.NET.
Below is my webservice code.
public DataSet findAAPAssessme nt(string assessmentID)
{
//Establish a connection with the database
//Assign the type and destination of the database being queried
string source = "Provider = Microsoft.JET.O LEDB.4.0;data source
= C:\\leedsuni\\m scproject\\seco nddemo\\snomede pr.mdb;";

//Create a new connection and use the string "source" to assign
//a value to the connection
OleDbConnection o = new OleDbConnection (source);

//Open Connection
o.Open();

//Initialise string representing the query to search the
database
string query = "SELECT * FROM abdominalpainas sessmentrecords
WHERE assessment_id = " + assessmentID + "";

//Create a dataset and load assessment data into dataset

//For creating a dataset with the results of the query
OleDbDataAdapte r assessmentTable Adapter = new
OleDbDataAdapte r(query, source);
DataSet assessmentDataS et = new DataSet();
assessmentTable Adapter.Fill(as sessmentDataSet ,
"abdominalpaina ssessmentrecord s");

//Close connection
o.Close();

return assessmentDataS et;

}
My client website simply wants returned dataset. This code is below

protected void getAssessmentDa ta_Click(object sender, EventArgs e)
{

string assessmentID = assessmentIDTex tBox.Text;
DataSet assessmentDataS et =
aapassessmentda ta.findAAPAsses sment(assessmen tID);
}

I think my problem is with using a string datatype but I'm not sure.
Please help.

Thank you

Khurram

[Deecrypt]

I should also point out that the error i get is a SOAPexception error
that suggets that no parameter is being sent.

Cheers

Khurram
Deecrypt wrote:

Hi,
Passing a string parameter to a webservice to get the dataset generated
as the result, seems to give me an error suggesting that no parameter
is being passed. However it works if I explicitly state the value as
the parameter. Code in Csharp being developed in VS2005 for ASP.NET.
Below is my webservice code.
public DataSet findAAPAssessme nt(string assessmentID)
{
//Establish a connection with the database
//Assign the type and destination of the database being queried
string source = "Provider = Microsoft.JET.O LEDB.4.0;data source
= C:\\leedsuni\\m scproject\\seco nddemo\\snomede pr.mdb;";

//Create a new connection and use the string "source" to assign
//a value to the connection
OleDbConnection o = new OleDbConnection (source);

//Open Connection
o.Open();

//Initialise string representing the query to search the
database
string query = "SELECT * FROM abdominalpainas sessmentrecords
WHERE assessment_id = " + assessmentID + "";

//Create a dataset and load assessment data into dataset

//For creating a dataset with the results of the query
OleDbDataAdapte r assessmentTable Adapter = new
OleDbDataAdapte r(query, source);
DataSet assessmentDataS et = new DataSet();
assessmentTable Adapter.Fill(as sessmentDataSet ,
"abdominalpaina ssessmentrecord s");

//Close connection
o.Close();

return assessmentDataS et;

}
My client website simply wants returned dataset. This code is below

protected void getAssessmentDa ta_Click(object sender, EventArgs e)
{

string assessmentID = assessmentIDTex tBox.Text;
DataSet assessmentDataS et =
aapassessmentda ta.findAAPAsses sment(assessmen tID);
}

I think my problem is with using a string datatype but I'm not sure.
Please help.

Thank you

Khurram