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 findAAPAssessment(string assessmentID)
{
//Establish a connection with the database
//Assign the type and destination of the database being queried
string source = "Provider = Microsoft.JET.OLEDB.4.0;data source
= C:\\leedsuni\\mscproject\\seconddemo\\snomedepr.md b;";

//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 abdominalpainassessmentrecords
WHERE assessment_id = " + assessmentID + "";

//Create a dataset and load assessment data into dataset

//For creating a dataset with the results of the query
OleDbDataAdapter assessmentTableAdapter = new
OleDbDataAdapter(query, source);
DataSet assessmentDataSet = new DataSet();
assessmentTableAdapter.Fill(assessmentDataSet,
"abdominalpainassessmentrecords");

//Close connection
o.Close();

return assessmentDataSet;

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

protected void getAssessmentData_Click(object sender, EventArgs e)
{

string assessmentID = assessmentIDTextBox.Text;
DataSet assessmentDataSet =
aapassessmentdata.findAAPAssessment(assessmentID);
}

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 findAAPAssessment(string assessmentID)
{
//Establish a connection with the database
//Assign the type and destination of the database being queried
string source = "Provider = Microsoft.JET.OLEDB.4.0;data source
= C:\\leedsuni\\mscproject\\seconddemo\\snomedepr.md b;";

//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 abdominalpainassessmentrecords
WHERE assessment_id = " + assessmentID + "";

//Create a dataset and load assessment data into dataset

//For creating a dataset with the results of the query
OleDbDataAdapter assessmentTableAdapter = new
OleDbDataAdapter(query, source);
DataSet assessmentDataSet = new DataSet();
assessmentTableAdapter.Fill(assessmentDataSet,
"abdominalpainassessmentrecords");

//Close connection
o.Close();

return assessmentDataSet;

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

protected void getAssessmentData_Click(object sender, EventArgs e)
{

string assessmentID = assessmentIDTextBox.Text;
DataSet assessmentDataSet =
aapassessmentdata.findAAPAssessment(assessmentID);
}

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

Thank you

Khurram