InfoPath Dev

Hello,

I was hoping I could get some help on web service.  I have a web service which returns a table to Infopath. The C# source is below. The table comes back to InfoPath as shown in the picture below.  How would I modify my web service so that the table is returned as repeating row, rather than via the repeating (Choice) indicator?

Thanks,

Dave

    [WebMethod]
    public DataSet GetAllLU_EducationLevelRecords()
    {
        DataSet DS = new DataSet();
        SqlDataAdapter posAdapter = new SqlDataAdapter();
        System.Data.SqlClient.SqlConnection cxn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["HumanResourcesConnectionString"].ConnectionString);
        cxn.Open();

        posAdapter.SelectCommand = new SqlCommand("select * from LU_EducationLevel", cxn);
        posAdapter.Fill(DS);

        cxn.Close();

        return DS;
    }

Are you using SQL 2005? Have you thought about using stored procedures and endpoints for this? Here is a blog post on that approach. Otherwise, I'd suggest you write your dataset into an XML node -- I'm not sure what causes that Choice section, but I'd expect InfoPath to understand XML better than a dataset. Here is an article, with some code samples, on that. It starts with XML --> DataSet, but about half way down the page, talks about DataSet --> XML.

Hi Hilary,

Thanks for the information and links. I'm using SQL 2008, and I thought that the direct endpoints should not be used and will be deprecated in a future version.  At least that's what I read wherever it talks about doing it this way.

I will look into your second recommendation.

Thanks,

Dave

Do you know, I vaguely recall reading about that deprecation -- thank you for bringing it up and posting it!

(hopefully this text doesn't lose formatting as my previous one did.  Can someone delete my previous reply?)

Dave

We've had an email thread going on this, but wanted to respond in the forum to your bold question above. InfoPath web service data connections always have you enter sample values and make a call to the web service -- this is the point when IP creates the schema files for your web service connection.