InfoPath Dev

Hi i have a sharepoint list with columns as ID and NAME. The list contains around 1lakh items and they may grow in future too..

when i am opening the form it loads very slowly and fires an alert box saying -- A script in this page causing IE to run slowly. Do you want to abort script?

when i tried to fetch the NAME from the list by entering ID,then also it is fires the alert message.

How to overcome this...pls reply as early as possible

Hi,

It sounds like the size of the SharePoint list could be causing the issue.  This is a known issue with InfoPath and SharePoint - InfoPath is actually unable to do any server side filtering of the SharePoint list which means that InfoPath will return the entire list from SharePoint as a secondary data source and then any filtering etc you need to do will be done in the form itself.  SharePoint 2010 made some imrovements to this but we also have a product called "Web Services Solution Pack" (WSSP) that allows you to query SharePoint and or SQL DB's much more efficiently than out of the box InfoPath/SharePoint

http://www.qdabra.com/en/products/WSSP.aspx

We do offer a free trial version

Ted

Hi,

I got it..BUT...

Below is my code:

using Microsoft.Office.InfoPath;

using System;

using System.Xml;

using System.Xml.XPath;

public partial class FormCode

// Member variables are not supported in browser-enabled forms.

// Instead, write and read these values from the FormState

// dictionary using code such as the following:

//

// private object _memberVariable

// {

// get

// {

// return FormState["_memberVariable"];

// }

// set

// {

// FormState["_memberVariable"] = value;

// }

// }

// NOTE: The following procedure is required by Microsoft Office InfoPath.

// It can be modified using Microsoft Office InfoPath.

// Retrieve the value of the itemID field

string itemid = root.SelectSingleNode("//my:field1", NamespaceManager).Value;

// Retrieve a reference to the SharePoint list

// Search for the item ID in the SharePoint list

// Check whether the search returned a result and

// if it did, retrieve the name of the item

// Select the contact in the textbox

 But it fetching the items in the firstview only..that is if the item id is in first 100 then only it loads the item name.

Totally i have seventy thousand items....any idea????

 hi,

i would suggest since you have over 70k data items, dont use secondary data connection, just use share point object model to fetch data from a list on the change event and fetch only the item whose ID is given.

that would give a huge performance boost to your form, and  you form will load much faster.

Hi anis.

I have tried like below......

but it throws an error..

can u pls check once..

try

//SPSite RmsSite = SPContext.Current.Site;

SPWeb MyWeb = null;

SPWeb RmsWeb = RmsSite.OpenWeb();

StringBuilder sb = new StringBuilder();

sb.Append("<Eq><FieldRef Name='RMSID' /><Value Type='Value'>" + itemid + "</Value></Eq>");

string rmsname = string.Empty;

sorry i forgot to say abt the error.it is "object reference not set to an instance of object" at Runwith elivated privileges delegate.

Thanks.

Hi Anis,

I am new to programming...so please help me..i am struggling with this from the last two days..

I have made some changes in my code..But the problem is i can't debug my code to check whether it is right or not??

I am getting Null Reference Exception:Object is not referenced to an instance of object like that.

So pls pls check my code...give me u r suggestionss..

try

SPWeb RmsWeb = RmsSite.OpenWeb();

SPList RmsList = RmsWeb.Lists["RMSDATA"];

StringBuilder sb = new StringBuilder();

sb.Append("<Eq><FieldRef Name='Title' /><Value Type='Value'>" + itemid + "</Value></Eq>");

string rmsname = string.Empty;

 hi Bala,

why dont you just debug your code, i know you told you cant debug your code.. but i think you should be able to. 

to debug your code, just put debug points in your code and press F5. 

Also to create the scenario's easily you can specify preview form. to specify that go to file -> preview -> preview settings and specify the xml file to be used to open by default.

do tell me if you are not able to do so. 

Hi Anis,

in the priview settings i have mentioned the domain name ..but in sample data..i have done like below..

To specify a sample data file to use while debugging or previewing in VSTA

Hi Anis,

i can debug now..

 you need to execute this code from a machine having moss/sharepoint installed. you cant debug this code from your local machine