Newbie Questions

Re: How do I bind a list box to an existing dataset?

rbemiller — Fri, 04 Jun 2010 01:59:50 GMT

disregard this post

Re: How do I bind a list box to an existing dataset?

mgarant — Thu, 03 Jun 2010 21:10:48 GMT

I don't know why it doesn't create a data source automatically when you create a control... I'm using Infopath 2007 too and it does it. when you are in the "controls" pane... at the bottom of the pane... is there a check box "automatically create data source"? is it checked? if it is it should create the data source for you when you add a control to your form

Re: How do I bind a list box to an existing dataset?

rbemiller — Thu, 03 Jun 2010 21:04:16 GMT

I'm using InfoPath 2007. I have given in and am now trying to use a repeating table instead of a list box. I read that you can format it to scroll like a list box so it might work for me. I was able to create the data connection to the xml file and bind the repeating table to it successfully. Now I just need to get it to populate. Nothing happens when I test it.

Re: How do I bind a list box to an existing dataset?

mgarant — Thu, 03 Jun 2010 20:54:57 GMT

Ok... what version of infopath do you use? Any way, just create a data source that is not repeating and you should be ok... i guess...

Re: How do I bind a list box to an existing dataset?

rbemiller — Thu, 03 Jun 2010 20:33:04 GMT

It was bound to a repeating group...the datasource I created. I deleted both the datasource and the list box. It doesn't create a data source for me automatically...when I ad a list box it pops up the window to select the binding...there's no option to have it create a data source for me.

Re: How do I bind a list box to an existing dataset?

mgarant — Thu, 03 Jun 2010 20:00:38 GMT

Look to what kind of Data Source you list box is bind to. Look in the right panel on infopath -> Data Source then select your list box and see to wich of the data source it is bind. If it is a repeating group try to delete both the list box and data source and recreate the list box and let infopath create the data source for you.

Re: How do I bind a list box to an existing dataset?

rbemiller — Thu, 03 Jun 2010 19:49:46 GMT

Tried that, unfortunatel it didn't resolve my issue. I get the same errors.

Re: How do I bind a list box to an existing dataset?

mgarant — Thu, 03 Jun 2010 19:42:48 GMT

Ok, when you create the data connection, check "Include the data as a resource file in the form template or template part" instead of "Access the data from the specified location".

It should solve the problem

Re: How do I bind a list box to an existing dataset?

rbemiller — Thu, 03 Jun 2010 19:36:39 GMT

I went to Manage Data Connections, then added a data connection > new connection to receive data > XML Document > selected my PatientData.xml file > selected Access data from the specified location

Then when I add the list box, I get the automatic List Box Binding pop-up > then select the PatientData (secondary) data source > then no matter which node or field I select I get the error.

Here's the PatientData.xml file:

<?xml version="1.0" encoding="utf-8"?>
<options>
<option>
    <value />
    <displayname />
</option>
<option>
    <value />
    <displayname />
</option>
</options>

Re: How do I bind a list box to an existing dataset?

mgarant — Thu, 03 Jun 2010 19:00:53 GMT

How did you bind your data to the list box? because i've just tried to bind a list box to an xml dataconnection and it is working perfectly...

Re: How do I bind a list box to an existing dataset?

rbemiller — Thu, 03 Jun 2010 18:54:26 GMT

Okay I may have it now using dataRow.Field. See below...

Next thing I noticed is that when trying to bind my list box to the PatientData datasource, I get the error that "a list box cannot be bound to a group or repeating field..." What should I bind it to?

foreach (DataRow dataRow in patientTable.Rows)
{
string PatientID = dataRow.Field<string>("patientId");

string PatientLName = dataRow.Field<string>("patientLastName");

AddItem(PatientID, PatientLName, "PatientData");
}

Re: How do I bind a list box to an existing dataset?

mgarant — Thu, 03 Jun 2010 18:29:42 GMT

For your second error,

AddItem(PatientID, PatientLName, "PatientData"); // and here I get the error: the name PatientData does not exist in the current context

You forgot your "".

For your first error,

Do you use Visual Studio?? If so try to write the code and see what visual studio suggest you went you type dataRow. and try to find the list of items inside the row. It should be named something like Items or anything refering to data.

Re: How do I bind a list box to an existing dataset?

rbemiller — Thu, 03 Jun 2010 18:17:29 GMT

Okay, thanks. I'm on the right track now...but still getting some errors. See my comments to the right of the code.

The xml file is called PatientData.xml and I created a datasource called PatientData that references the xml file.

RemoveItems("PatientData");

                        foreach (DataRow dataRow in patientTable.Rows)
                        {
                             string PatientID = dataRow.Item[patientId].toString(); // here and on the next line I'm getting an error at the .Item part of dataRow.Item[... the error: System.data.datarow doesn't contain a definion for Item

string PatientLName = dataRow.Item[patientLastName].toString();

AddItem(PatientID, PatientLName, PatientData); // and here I get the error: the name PatientData does not exist in the current context
}

... then...

private void RemoveItems(string dataConnection)
        {
            XPathNavigator DOM = DataSources[dataConnection].CreateNavigator();
            XPathNavigator group1 = DOM.SelectSingleNode("//options", NamespaceManager); while (group1.MoveToFirstChild())
            {
                group1.DeleteSelf();
            }
        }

private void AddItem(string itemId, string itemName, string dataConnection)
{

XPathNavigator DOM = DataSources[dataConnection].CreateNavigator();
XPathNavigator DOM2 = DataSources["PatientData"].CreateNavigator();

XPathNavigator group1 = DOM.SelectSingleNode("//options", NamespaceManager);
XPathNavigator field1 = DOM2.SelectSingleNode("//options/option", NamespaceManager);

XPathNavigator newNode = field1.Clone();
newNode.SelectSingleNode("value").SetValue(itemId);

newNode.SelectSingleNode("displayname").SetValue(itemName);
group1.AppendChild(newNode);

}

Re: How do I bind a list box to an existing dataset?

mgarant — Thu, 03 Jun 2010 17:35:56 GMT

You just need to go through all the data inside your dataset with a foreach loop and then populate your list with the AddItems function.

foreach (DataRow dataRow in patientTable.Rows)
{
string approver = dataRow.Item[<the ID of the data you want to recover>].toString();

string username = dataRow.Item[<the ID of the data you want to recover>].toString();

AddItems(approver, username, <dataconnection>);

}

Re: How do I bind a list box to an existing dataset?

rbemiller — Thu, 03 Jun 2010 16:06:14 GMT

Okay, I've finally been able to get back to this and I'm having trouble. I have created the empty xml file (PatientData.xml), now I need to populate it with my dataset. It looks like in this example this is getting its data from a sharepoint list, but my datasource is a SQL Stored Procedure. I'm not sure how to make it work for my needs. Any help is appreciated. Thanks!

Here's the code block where I need to do this:

...
//Make call to SP
adpt = new SqlDataAdapter(cmd);
DataTable patientTable = new DataTable();
adpt.Fill(patientTable);

//Make sure not more than one patient
if (patientTable.Rows.Count > 1)
{
// here's where I need to populate the xml for the secondary datasource, and then
}