What is the appropriate way to submit a repeating table with a Web Service?

showet — Tue, 14 Apr 2009 16:14:59 GMT

I must be missing something. All I want to do is to use a web service to submit the data from a repeating table. I will be inserting the entire repeating table (as a recordset?) into the database.

What do I use from InfoPath to get the repeating table data, should I expect a dataset, a table, xml, strings?

I have tried something like the following partial code, but I don't know what I would use for "query" if I use that code.

[WebMethod] // A method to Submit repeating table data

public void SubmitDataSet(DataSet ds)

{

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["OracleConnString"];

OleDbDataAdapter da = new OleDbDataAdapter("query",conn);

da.Fill(ds);

. . . .(con't)

Maybe I should be using something other than a recordset for the repeating table?

Any suggestions how to get the repeating table data into a database through a web service would be GREATLY appreciated. If you need more information on what I have tried or what errors I may be getting just let me know.

Web Services

What is the appropriate way to submit a repeating table with a Web Service?