Passing DataTable to Web Service Function

100 pts.
Tags:
Database
Web services
Hi! I have fetched out data into datatable from source database and want to pass this datatable into my webservice function. so that webservice function could insert data into destination database. any help will be highly appreciated. m4atiq.
ASKED: February 1, 2008  5:27 AM
UPDATED: February 1, 2008  2:12 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Grappling with similar problems for Web Services under ASP.NET 2.0x

The issue is which objects can be “serialzed” so they go thru Web Services.

The dataset is a sure bet. Web Services can pass datasets between themselves and/or client applications (Windows Forms clients or Web Site clients).
The dataset can have zero or more data tables. Your SP can populate the dataset table when you execute the SP as part of the data adapter FILL method. Simply pass the dataset back with or without processing the table data.

For the time being, I am unable to pass a SQLCommand object thru Web Services.
This worked in the previous .Net Framework … but for some reason it “fails” to serialize under 2.0x
Will ask this question in a separate thread.

Good Luck

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following