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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Repeating section appears above when insert command clicked

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint
 

I have a form containing a repeating section.  The section contains a number of control within a layout table.  The repeating section properties are set to allow users to insert a new section.  By default new rows/tables in repeating controls are inserted below the existing when the command line is clicked.

Is there a way to change this default, ie. when the command line is clicked the repeating section is added ABOVE the existing section? 

The form will be operationg as browser enabled within SharePoint (2005)




View Complete Post


More Related Resource Links

infopath repeating section only for insert new item not editable

  

hi,

i'm trying to use a repeating table in my form. where the user can only insert new item and not edit the existing items that are loaded in the form.

i have set the fields read only when they are not blank. but when the user wants to insert a new item and he makes a mistake he can not fix the field because it will be read only.

can some one help me with this.

i've been asking some question without getting help, hope someone can help me with this one

thnx in advance


How to identify new row in repeating table and repeating section of browser enable infopath form

  
Hello All,   I have Exp form that contain repeating table as well as repeating section. When i click insert new item it inset new row but i didn't got identification of that row. Is there is way to get identification of each row in repeating table as well as section.  Please help on this.  Thank you.

how to duplicate values to a new repeating section from a previous one?

  
It's nice to have repeating section. Is there any easy way to duplicate values from a previous section to a new one, even with manual process (eg, click a button)? THanks,

List contain two parts: Repeating section and fixed section (without repeating option) in the same l

  

Dear All,

For MS Infopath 2010 and Sharepoint 2010

when I opened MS Infopath and from file-->New--> sharepoint list-->Design Form

I did not find the containers like (Repeating section , table ...etc. ) in the tools bar

Where I need a list to be contain  fixed section (without repeating option) and another Repeating section in the same list how I can complete this task ?

Thanks for your help

 


List contain two parts: Repeating section and fixed section (without repeating option) in the same l

  

Dear All,

For MS Infopath 2010 and Sharepoint 2010

when I opened MS Infopath and from file-->New--> sharepoint list-->Design Form

I did not find the containers like (Repeating section , table ...etc. ) in the tools bar

Where I need a list to be contain  fixed section (without repeating option) and another Repeating section in the same list how I can complete this task ?

Thanks for your help

 


Launch a Repeating Section based on changes in form values

  

Hello,

What I am trying to do is launch a repeating table based on what the user selects from a drop down box. This is a form I am using for Users to test new applications. If this is the first log in attempt there is no need for a 2nd section but if the user chooses 2 or more I would like the form to automatically launch the next section just like if the user clicked the button to add another repeating section.

 

Any help is greatly appreciated, thanks in advance.


Infopath Repeating section does not show repeat records

  

hi, i have a infopath form. with a repeating section.

firts i used to click the run query button and it display all the records in the repeating section.

then i modify the form that the user could add a new record in the repeating section.

that works. but now when i click the run query button again it does not show the new record with all the other records in the repeating section it shows onlt the first record of all

is someone familiar with this?


The data source control failed to execute the insert command

  

Hi All,

I have create table in SQL 2005 and retrive its data in to sharepoint  with the help of Database connection option through Sharepoint Designer. When configuring the connection i have selected a custom quer with stored procedure option and from the dropdown option selected the insert stored procedure everything is ok.

Stored Procedure
----------------------
CREATE PROCEDURE ChangeTable_insert

(
 @ROLE VARCHAR(50) ,
 @PROJECT varchar(50) ,
 @CENTER NUMERIC(18)
)
AS
BEGIN

INSERT INTO [dbo].[ChangeTable]

(
 [Role],
 [Project],
 [Center]

)

VALUES

(
 @ROLE,
 @PROJECT ,
 @CENTER 
)
END

i have created new aspx page in Sharepoint Designer from the datasource details-->Insert selected fields as-->selected new item form and saved this page.
When i opened this page in to browser and try to save data it gives an below error
ERROR:
--------------------
Go back to site 
Error: "The data source control failed to execute the insert command.
 Troubleshoot issues with Windows SharePoint Services."

please help me. i have to save data to sql database through sharepoint

thanks in advance


Customize Repeating Section Commands

  

I have an Infopath 2010 form which will run as a web browser form. 

There is code to add or remove Repeating Sections automatically - I don't want the user to be able to  add or remove sections using the icon that appears at the top left of the repeating section.  However, in order for the code that adds or removes sections to work, it is necessary to enable "Allow users to insert and delete the sections" i.e. if I uncheck this option, then the code fails - if I check it, the code works.

Firstly - is this meant to be the case ? (Some of the forum comments on Infopathdev imply that you can replace the menu commands with a button.)

So as a result, I thought I could customise the menu commands - despite unchecking all the options - the insert Repeating Section command is still there - all other commands (e.g. Remove, Remove All, Insert Above / Below)  have disappeared as expected.

Any thoughts,  thanks.


Insert command not using selected value from DDL in a DetailsView

  

My web form contains a detailsview control that I have added a templated field to with a DropDownList in the InsertItemTemplate. The DetailsView default mode is 'insert. My detailsview is attached to a sqldatasource that has a stored procedure in the db to handle the insert. When I enter data in the fields and select insert all values from the detailsview are written to the table except for the selection that was made in the dropdownlist. I am using the ddl.selecteditem.value to populate my variable however when the insert method is envoked it doesn't send my value. The DDL value that I am capturing does not need to be written to the table it is just a flag for some variables that need to be set at the stored proc level. How do I get the DDL selected value to be sent with the insert statement? Any help would be greatly appreciated.

Here is my code behind:

 

 

 

 

Protected Sub

DropDownList1_SelectedIndexChanged(ByVal sender

Infopath: problem with structured layouts within a repeating section or table

  

Hello,

I've run into a bit of a problem when trying to structure information in a repeating section or table.

What I need to be able to do is use a repeating section or repeating table to receive data from a secondary data source and then structure this data and have the ability to have the field names at the top of each row in the table.

Both options seem floored:

repeating table: this method seems ok at first but it doesn’t seem possible to have the field names at the top of each row, which is a requirement. 

repeating section: this does include the field names for each row but for some reason will not allow me to structure the fields in a nested table, so its messy.

The data source control failed to execute the insert command

  

In SharePoint Designer 2007 I'm trying to customize the edit form that you get when you create a list item in a SharePoint 2007 list (EditForm.aspx). I took the following steps:

1.       Open the site in SharePoint Designer 2007.

2.       Browse to the list and open the 'NewForm.aspx' web form.

3.      

Repeating Section does capture addtional entries

  

Hi! I am new to InfoPath 2007. I have a repeating section in my form capturing a single field - NAME.

When clicked on the button, the system created additional fields for me to capture the additional names. However when I submit it to SharePoint, only the first name was captured.

Any advice on how I could fix this?

Thanks in advance.

Regards,

NewKidsOnTheBlock

 

 


Code for insert command using C#, SQL, and ASP.NET

  

I'm having problems getting my code to work.  I have a couple text boxes.  When I hit the button I want it to insert the data from the two text boxes into the SQL database.  Could some show me some C# code that does this from something that actually works?   


"The data source control failed to execute the insert command." when inserting to sql table with tri

  

Hi,

I have a data view web part that inserts a new record into a sql table. This works fine.

I have now needed to add a trigger to the sql table that sends an email when a new record is inserted (the code for which works fine) but now my insert fails with 'The data source control failed to execute the insert command.'.

If I disable the trigger the form works fine again.

Any ideas what could be causing this?

Jeni


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

  

Hi!

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.

 


how to not let users edit a repeating section in infopath

  

Hi everyone. I'm new with infopath. i hope you guys can help me with this.

maybe it is a logic thing, but i dont seem to get this.

i have a infopath form. where the user can klick on load. all his data appaers on a repeating section with some fields in it.

now what i want is that the user can add new data to those fields in the repeating section.

but they can not edit the old data. it is for a security issue. they can only add data to their existing data but can not edit the old one.

how can i do this an eseay way?

maybe i have to ask this way. how can i add new records to an already existing user?

i'm using infopath 2007 with sql server 2005

 


Categories: 
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