Question

Passing DataTable to Web Service Function

WebServices, Database

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.

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