.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

InfoPath Forms : Adding rows dynamically from a SQL table along with a 'Delete' button per row

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :SharePoint

My requirement is something like this:

In a Task Approval form, I want to have a view which shows all the rows in a particular SQL table (in a infopath repeating table?). Along with each row, there should also be a button, on clicking which the row should disappear from the infopath view table. Do you think InfoPath can handle all this? :) 

To summarize:

1. How do I add rows to a table dynamically?

2. Per row, how do I create a button dynamically?

3. How do I remove the row from the view when the button is clicked?

View Complete Post

More Related Resource Links

Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

Infopath form using Visual Studio - How to bind repeating table on submit button click ?


Hello friends,

   I have created infopath form using Visual Studio 2008

Form have 3 dropdowns and one repeating table which is bound by Datasource ( List from sharepoint ).

whenever i select appropritae values from drop down, Repeating table gets bound as datasource for dropdown and repeating table are same.

I have done conditional formating for repeating table using repeating table properties.


My Question:


Now i included one submit button and i want when i click submit button it will check DropDown Values and if appropriate record matching these values found it will fill repeating table

How i achive this ? as i dont find how to bind repeating table on submit button.

Please help if anyone have answer.


Thanks and Regards,


Kapil Bhosale.




Adding Custom Actions to Ribbon UI in InfoPath forms

Hi experts, - I have a custom List in my site. - I have modified the default SharePoint List forms (DispForm.aspx, EditForm.aspx and NewForm.aspx) using InfoPath 2010, changes being related to the layout of input controls. - Then I wish to add a custom action (a print button - for printing based on modified layout) in the Ribbon Control of these InfoPath modified forms (i.e. displayifs.aspx, editifs.aspx, newifs.aspx). - I am doing the following http://www.endusersharepoint.com/2010/02/19/adding-custom-actions-to-the-ribbon-ui-in-sharepoint-2010-using-sharepoint-designer-2010/ but i guess, it only forms for the SharePoint List forms and not the Infopath modified forms. Any suggestions on how to add a custom action of 'Print' on the Ribbon UI of the list forms. Is there any other better approach? Kindly advise. -Pallz.

Delete objects from table using another table to select rows - help needed

I have one table named 'dbo.ac_Products'Within this table there is a column named 'ProductId'There is also another table named 'dbo.ac_CatalogNodes'Within this table there is a column named 'CatalogNodeId'and a column named 'CatalogNodeType'I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1Any help would be greatly appreciated!

Infopath 2007 Repeating Table - Multiple Value Column Text - Hiding Rows based on Column text values

Infopath 2007 browser based form Full Trust Example: I have a repeating table (FruitChoice) that has multiple columns. Both drop down list point to sharepoint list data sources. Choose your tree ft. drop down list – 6Ft Choose your Department drop down list - 103 This repeating table is conditional on the drop down values. This works great. Trees     Fruit       Cost   Date Ordered    Date Delivery Department 6Ft        Peaches                                                        103 3Ft        Apples                                                          102 3Ft        Peaches         &

How to dynamically add table rows within update panel ?

Hi, In my webform, i have 3-4 textbox, on there textchange event i have to fetch data from database and put it on the form. I have taken another html table (with runat="server")  below textbox and  and in textchange event created a new <tr>, <td> and simply added contents in <td>, then finally added <tr> in the table. This is done in UpdatePanel. When i enter something in textbox1 data is added in that table,that's fine. But when i enter something in 2nd textbox the previous data is overridden. My requirement is that if 2nd textbox's text changes than another row with appropiate data should be added, i.e., now two rows. Silimarly if 3rd ,4th textbox data changes then subsequently 3 or 4 rows should be displayed. What should i do ?

Adding Controls dynamically in the infopath form - A standard Expense Entry scenario



I am having a requirement where I need to create an Expense Report Entry form using Infopath 2010. 

1) The form would have pre-defined columns/Controls like Exp.Type(drop-down) , Details , Location, Amount , Curruncy, Date etc..

2) User can enter/update as many line items as possible by clicking Add/Update/Delete for the each line items. So basically its like adding the same row dynamically.

3) When User Submits, I need to capture this data and post it to SAP where I am using SAP web Services.

Can you please suggest if this is possible in InfoPath form ?

If Yes, how can I achieve this dynamic line items functionality in InfoPath

And how can I read the data using the code so that I can Post it to the WebService? 

Dynamically Adding button in GridView



I am using the following to dynamically add button to the cell of gridview, condition is that if the value of the fourth column is empty, then in place of empty cell add the button. But nothing is happening.  I am making use of the following logic in  RowDataBound event in gridview.

protected void gdvEmployee_RowDataBound(object sender, GridViewRowEventArgs e)

for( int i=0;i<=dataSet.Tables[0].Rows.Count;i++ )
                if (dataSet.Tables[0].Columns[3] == null)
                    Button button = new Button();
                    button.Text = "ADD";
                   DataColumn dataColumn = new dataColumn();

Adding custom help to browser based Infopath forms


We are developing a browser-based application with Infopath 2010 forms.  We would like to provide buttons that pop up a separate browser window containing an HTML help page, which would be stored in a SharePoint Wiki.  I understand it is not possible to call JavaScript from a browser form, which was the initial thought. 

What other approaches are there for providing custom help in Infopath?

Adding rows in table at run time?



    I have a table which has few rows.

    A row contain few textboxes, one file upload field and a dropdown list in its cells.

    I want to make it a dynamic table that is i should be able to add extra rows in table at runtime, but I dont know how to do it.

    Please Help.

Delete selected rows from Table



I need to delete all rows from Table A that :

1. equal in year column(tbl A) with Date column from Table B

2. A.policaNum = C.PolicaNum (from TABLE C)


THOSE tables deals with large data amount, so I'd like the best solution to this.  

I tried only to select before delete, but it takes too long and throws exception of memory

FROM    A left JOIN
           C ON A.kod_lakoha = C.kod_lakoha INNER JOIN
           B ON A.YearItra = year(B.TarichNechonot)



how to add multiple rows in a data table against a button click event


how to add multiple rows in a data table against a button click event, and then show it in a gridview

XML with PrimaryKey values to delete rows in database table at a time



I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in my case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.

My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??

If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..

My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??

WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method??

Can anyone please help me out clarifying my doubts and also XML Delete Query..


My XML will be like this











Will bulk delete happen in the above case?



Adding infopath forms to a web page - is this possible??



I have a  non-SharePoint public web site on which I want to add links that when clicked on, will open up into an InfoPath form, where the user will fill out the form and submit, via email to a SharePoint forms library or list.

In trying to accomplish this (hoping that this is possible), I've extended a SharePoint 2010 web application for anonymous access so that public users can access the web app without having to log on.  The secure part of the web app is not available for public viewing, and the extended anonymous part, will only be available to the public. 

Once the user clicks on the link to the form, I want the following to happen:

1) I want these forms to have a url that can be clicked on from the non-SharePoint public web site.

2) I want these forms to open in a new browser web page, without any SharePoint links or buttons - just the form, itself, with little or no SharePoint, so that the user doesn't know it's being hosted in a SharePoint site.


Can anyone please help me on how to accomplish this??



Adding Dynamic Maps to Contact Forms with REST Web Services in InfoPath 2010

Learn to use the REST Web service data connection feature in InfoPath 2010 to add a dynamic map to a list form for contacts in SharePoint Server 2010.

Sample: Adding Dynamic Maps to Contact Forms with REST Web Services in InfoPath 2010

Explore the code as you learn to Use the REST Web service data connection feature in InfoPath 2010 to add a dynamic map to a list form for contacts in SharePoint Server 2010.

adding colors to table rows programatically...


hello frnds...

recently i created a table programatically using c#.

now i want to format the table.

i want to give colors to the alternative rows of the table.

i am having the color values.(#E9F1F3,#98C1CA)

this is the code i have used to create rows and cells...

TableRow tr=new TableRow();

TableCell tc = new TableCell();

tc.Controls.Add(new LiteralControl("

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