.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Expression box only shows the first row of data in a repeating table...

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :SharePoint
Expression box only shows the first row of data in a repeating table, how can I display all rows of a repeating table in an expression box, preferably without code?

View Complete Post

More Related Resource Links

Reading Infopath Repeating Table data in .Net Workflow


Hello, i have an infopath for that has a repeating table on it that i am using for users to add comments. The table contains a couple of textboxes, one that automatically inserts the users name into it and the other for the user to enter their own comments. I want to be able to read the contents of the repeating table when a manual workflow is started against the form list in sharepoint so that i can email all the users who have left comments on the form.

I am struggling to find any info on reading repeating table data from an infopath form in a .net workflow. I have tried using an XPathNavigator to select the repeating table but it only displays the first comment in the table.

Can anyone provide any info on accomploshing this or point me to any articles that explain how to do this?

thanks a lot



Search data from sharepoint list and populate repeating table (Seach text should be entre in first f


Hi All,

I am newbie to infopath.

I have assignment to search data from sharepoint list and display it to repeating table. Below is the case in detail.

i. User enter search text in first textbox of repeating table.

ii. After text enter you will Enter or click tab button.

iii. As user press Tab /Enter, the other textboxes of repeating table will populate with data automatically.

iv. If searched data rows are more then one, then dynamically add new row's in repeating table and  show searched data.

I am working at offical assignment and it's deadline is very tough. i had made extensive search at google and msdn forum but unable to accomplish. I would appreciate and thanks is some provide me solution in form to a small infopath application and code snippet.




How to submit data from repeating table to an SAP web service


Hi ,

                 I am new to infopath. I have a porblem here while submitting data from a repeating table to an SAP web service to insert data into the fields in the web service. Can any one suggest me how to submit data from a repeating table to SAP using an SAP web service. I need to use a web service which is created by SAP group. My job is to map the fields in table and in the web service. SAP web service contains a table which can get the data from our repeating table. Any help would be greatly appreciated. If you are confused with my question please let me know.



How to filter data in repeating section using field value in repeating table?



My form is web-browseable. I have a repeating table and repeating section in one of my form views. 

I want to filter data in my repeating section by field value in selected row in repeating table. How is it possible? How to fire event on row change in reapeating table? How to get value from field in selected row?

Actualy, it is the same data in these sections, but its a list with some fields in the reapeating table and all fields(details)  in reapiting section. I would like to filter data in repeating section by field DPNumber in repeating table.


Infopath 2007 - Copy Repeating Table Data into a seperate repeating table



I have a repeating table in my InfoPath form where users fill out data. When they click a button I want to populate a different repeating table within the same form (using only some columns but all rows)

Im using C# code (below) to do this and at the moment Im getting no results - when the user clicks the button nothing happens. 

The populated table =


The table I want to populate =


 XPathNavigator rootMain = MainDataSource.CreateNavigator().SelectSingleNode("/my:Sect_Main/my:RequestDetails/my:Products/my:Product"
, NamespaceManager);
   XPathNavigator rootSecondary = MainDataSource.CreateNavigator().SelectSingleNode("/my:Sect_Main/my:RequestDetails/my:Sect_Retailers/my:RetailerProducts"
, NamespaceManager);

   // Select nodes in specified XPathNavigator.

   XPathNodeIterator selectedNodes = rootSecondary.Select("/my:Sect_Main/my:RequestDetails/m

Only first row of a repeating table is being populated from a sharepoint list secondary data source


I have a reapeating table in maind atat source and I am trying to  populate it from values in a secondary data source, but when I am trying to do that it is only populating first row, leaving all other rows blank.


How to get this working..

Checkboxes from data table


I have a data table that contains some values for Certifications.  This table can be updated in a different part of my application.  On the web page I am currently working on, I would like to have check boxes appear for every value in the data table.  I have been struggling with this trying to use a For Each loop and I cannot get it to work for anything.  Any suggestions? 

I am using the following Razor syntax to obtain my data (I know this works because I can display it in a WebGrid):


var db = Database.Open("MyConn");

How to get data from table based on four table



I need to know how to show top 30 records from four table

with fastest speed.. in ms sql server 2005..

hope You do the needfull


Data Points: Deny Table Access to the Entity Framework Without Causing a Mutiny


Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.

Julie Lerman

MSDN Magazine August 2010

Data Points: Windows Azure Table Storage - Not Your Father's Database


Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.

Julie Lerman

MSDN Magazine July 2010

Under the Table: Visualizing Spatial Data


In this article, the author shows you three new arrivals on the SQL Server spatial visualization scene: the map control in SQL Server 2008 R2 Reporting Services (SSRS), the ESRI MapIt product, and the MapPoint Add-In for SQL Server 2008.

Bob Beauchemin

MSDN Magazine November 2009

Under the Table: How Data Access Code Affects Database Performance


In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.

Bob Beauchemin

MSDN Magazine August 2009

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

Data Points: Common Table Expressions


In T-SQL, views and derived tables serve similar purposes and have their advantages. But when working with SQL Server 2005,there's a third option--using Common Table Expressions (CTEs). John Papa explains.

John Papa

MSDN Magazine October 2007

Regular Expression to Match


Here is the kind of text I want to match via a regular Expression

The id="dgSchedule" is always present in the TAG but its location may differ

The table is span over multiple line/contains white spaces/tabs...

I have the regular expression to match the start and end tag respectively over a single line

\<table .*\>


The problem is to match the whole table span over multiple lines

<table cellspacing="0" rules="all" border="1" id="dgSchedule" style="border-style:None;height:100%;width:100%;border-collapse:collapse;">
	<tr class="blackbar" align="center" style="background-color:#7FB4DE;font-family:Verdana;font-weight:bold;height:20px;">
		<td>From Place</td><td>To Place</td><td>Time</td><td>Bus Type</td>

	</tr><tr style="background-color:#DEECF5;">
	</tr><tr style="background-color:#EFF5FA;">
	</tr><tr style="background-color:#DEECF5;">


need your help regarding table and database.. without data lose



I have a table like this in database

ItemNo ItemName Qty  

001       A               50       

002       A               20      

003       B               50  

004       C               60      

005       D               40 

006       E               90      

upto it has some 3000 rows in table..

Now what my problem is i have one more field in mydevelopment PC let us consider another column Category

I need to update this column to my client pc without losing 3000 data from table which already exist...

How to do...?

Entity Data Model and database view returning the same columns as there are in a table


When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined. 

How do I do something similar for a view?

I mean assuming I have a view like this

CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...

(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.

var foos = myDB.FilteredFoos.Include("Bar").ToList();

foreach (Foo foo in foos) { ...

Thanks, Jenda

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend