Best way to pass a Dataset to a WebService

[Deecrypt]

Hi,
I'm a newbie to the Web Services topic. I have an ASP.NET website and
am trying to send a Dataset from it to a WebService which should insert
all the data from this DataSet to an Access database. Also I'm working
with untyped datasets. I have read some topics in this newsgroup. One
suggested to convert the DataSet to a string using ReadXML, send the
string to the WebService, create a new Dataset and read the string back
into the DataSet.

Can anyone provide me with some sample code for such an approach or a
better one if possible. Below is how I have started my WebMethod that
receives a dataset as a string.

public string updateSpineAssessmentData(string datasetXml)
{

string successfullUpdate = "Update Successful";
return successfullUpdate;
}

Quite desperate to finish a project so deligience would be greatly
appreciated.

Thank you and I look forward to your replies

Khurram

[linhardt]

Just pass the Dataset as a parameter to the web service as you normally
would in any method call.. You don't have to worry about converting it
to a string. The web proxy marshals and demarshals the parameters for
you. The same is true for strongly typed datasets.

Deecrypt wrote:

Hi,
I'm a newbie to the Web Services topic. I have an ASP.NET website and
am trying to send a Dataset from it to a WebService which should insert
all the data from this DataSet to an Access database. Also I'm working
with untyped datasets. I have read some topics in this newsgroup. One
suggested to convert the DataSet to a string using ReadXML, send the
string to the WebService, create a new Dataset and read the string back
into the DataSet.

Can anyone provide me with some sample code for such an approach or a
better one if possible. Below is how I have started my WebMethod that
receives a dataset as a string.

public string updateSpineAssessmentData(string datasetXml)
{

string successfullUpdate = "Update Successful";
return successfullUpdate;
}

Quite desperate to finish a project so deligience would be greatly
appreciated.

Thank you and I look forward to your replies

Khurram

[Deecrypt]

Thank you,
I've used that method and it worked perfectly. I have another problem
with .net. Would you happen to know if there are any bugs related to
the DataAdapter.Fill method in .Net 2 using VS2005.

My issue is that I am communicating information between a website and a
webservice using datasets. The datasets created by filling the
datasets with results of queries using the DataAdapter. My problem is
that for some reason, the fill method seems to miss out on exactly one
row from the database even though that row still conforms to the query
criteria. Below is my code. May be there is something I am
overlooking.
//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;";

//Initialise string representing the query to search the
database
string query = "SELECT * FROM abdominalpainassessmentrecords
WHERE assessment_id = " + assessmentIDTextBox.Text + "";

//This dataset represents what has just been edited and saved
in the aap database
OleDbDataAdapter aapDataAdapter = new OleDbDataAdapter(query,
source);
DataSet aapDataSet = new DataSet();
aapDataAdapter.Fill(aapDataSet,
"abdominalpainassessmentrecords");

I'm just wondering what would make the adapter miss one row that still
conforms to the query criteria. It just seems like a bug to me.

Thank you kindly

Khurram