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


Top 5 Contributors of the Month
Shivakumaran
Post New Web Links

Values in repeating rows being replaced after opening the form a second time

Posted By:      Posted Date: November 20, 2010    Points: 0   Category :SharePoint
 

I have a couple Infopath forms and recently they started behaving oddly.

In each of them there is a repeating row. In each row you enter a work order as the first value/column, this then filters the second column which is a drop-down with the various items on that work order. The remaining rows are then descriptions of those select items respectively. This information is all retrieved from a single SQL connection.

It all looks great, you click submit (It submits those values to a SharePoint list) and is then saved in the document library. However if you open the form after the values in each of the repeating row has reverted back to the first item for the selected work order.

For example: I enter work order 3344 which consists of items x, y, and z. In the drop down I can select item x, for the second item, I select y, and then z for the third for a total of 3 rows I then click submit.

If I open the form again the correct work order is still displayed but the three rows are all showing details for x, the first item in the work flow.

Does anyone have any idea what could be doing this? Thanks in advance!




View Complete Post


More Related Resource Links

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         &

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.


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

  

 Hi,

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

 

<root>

<Customer>

<CustomerID>GUID1</CustomerID>

<CustomerID>GUID2</CustomerID>

<CustomerID>GUID3</CustomerID>

 ...

 ...

</Customer>

</root> 

Will bulk delete happen in the above case?

Thanks,

PAvan


Programatically adding rows to nested repeating tables in Infopath Form based on a criteria

  

Req Nested Repeating Table:

SubName

Questions/SubName

Category1

Question

SubName

Sco

What is the easiest way to reset all the values of controls on a web form (vb.net) to their defaults

  

What is the easiest way to reset all the controls on a web form.  Can I set "veiw state" to false for all of the controls with one command, do a response-redirect to its own page, and set view state back to true.  What is the easiest way to do it.

 

Thanks 


Error when opening Infopath Form

  

Background: Created an Infopath 2003 form with 2 views (1 as Read-Only View and another 1 for Submitting content) and published to a Sharepoint 2007 Library.

Working: When a user opens a new form it opens in submit view; once the form has been submitted, when the user tries to open again, the form opens in read-only view.

Error: 99% of the users do not face any issues, however when the the rest 1% of the users try to open a new form; they receive the following error and are unable to open the form.

Form template: _http://server/sites/subsite/library/forms/template.xsn
InfoPath cannot open the following view: Edit_View
The following view file is not valid: view1.xsl
The file is not a valid XML document.

An invalid character was found in text content.

Line 673, Position 12
 </xsl:temp
-----------^

I am not sure what is wrong here (or) from where this error is being generated!


Balaji Baskar [Please mark the post as answer if it answers your question]

Switch views when opening a form depending on submit locations?

  

Hello!

I would like to know it was possible to switch views when opening a form depending on where the form has been submitted.

I am submitting my form to library A and library B and want to be able to open it in view 1 in library A and in view 2 in library B.

Is there a way to set some url conditions in the open behavior rules?

Thanks a lot!


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.

 

 

 


Getting User_Name when opening a form

  

Hi Everyone:

Scenario on  MOSS with Infopath Form Services:

  1. Two libraries - Library 1 is a list and Library 2 is Infopath form library (browser base form)
  2. A workflow in Library 1 creates a item in Library 2 and pre-populates the form with some data from the list (this works perfectly)
  3. Also a  user can create a form directly in Library 2 (the form library)using the New button
  4. The form has a hidden field which captures UserName() and if User Name = another field in the form, the User can make a change, if it doens't match User can't change the data)

Problem:

  1. When a user creates a new form in the library, the hidden field is correcty filled in with the logged on User.
  2. If they save, close and open the form, the field still shows logged in user
  3. BUT, if the form is created and saved in the form library by the workflow, and a user then opens the form from Library 2, the Username() blank.
  4. So, one a form is created by the worklflow and a user opens it after the fact, how do I capture the Logged in user who is opening it for the first or subsequent times?

Thanks for your help!

 


Just-In-Time Debugger error when opening SQL Server studio express

  
Hi,   I am new to these forums; hope I am posing in the correct forum   I have problem opening the SQL Server 2005 Management Studio Express. Getting the error below   'An unhandled win32 exception occurred in ssmsee.exe [5336]'   Searched in many forums but none of the suggestions resolved my issue..   I have re-installed .net 2.0, upgraded to 3.5 but still no luck either   Have re-installed SQL server management studio express again no luck   Deleted the shell folder from both documents and settings and in registry still have the same problem   Appreciated your suggestions to resolve this issue   Many thanks

Error opening an Infopath form

  
I am trying to open an Infopath xsn form and I get the following error - "infopath cannot load this form. Either the signature is corrupted, or the certificate used to sign this form is expired or revoked. Contact the author of the form." I am the author of the form. I tried calling my cellphone number but there was not answer. Anyway, I've encountered this error before and I ended up redoing the form from scratch. I don't want to do that obviously. Is there a way to open the form somehow?Thanks,Dave

Refer Rows/values of OLEDB Source inside DFT

  
I have a Data Flow task that implement Insert/Update using logic:  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/131dbe38-95a9-4b64-8434-60ba3cd6de00/. Now I want to also include "Delete" just after the OLEDB Source where I will delete from Target Table if the Rows are present in Target and No in the OLEDB Source. So what control I should use and how do I refer to the OLEDB Source records. May be something like: Delete from dest_table where ID NOT IN (SELECT ID from OLEDBSourceControlRecords)... Thanks, Prabhat

time out stored procedure windows form

  
I have a form that runs kicks bulk copies data to a data base and then runs a stored procedure.  the problem I have is the stored procedure takes a long time and users have no way to know what is going on.  the app window freezes says not responding and then after a while it completes and moves on. is there a way to prevent the application from freezing and being marked as not responding?

InfoPath repeating table Copy values from above row without Code

  
Hi, I have situation, where I want to copy the values from the above row to the newly created row in a Repeating table. Ex. I have a repeating table with 3 columns ID-Name-FileName. When I enter a data like 1-Customer1-File1.zip and hit "Insert new row", the new row should automatically populate the values of the above row. How can I do it without .Net code. Regards,

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.

database schema for online account opening form

  
what should be the database schema for online account opening form with joint account holders and every participants (in a joint account) have seperate contact and personal detials.Please suggest.

opening a web browser without opening form on windows form load event

  
Hello All, I have a main frame which has a display button. after clicking on display button I usually open a windows forms. Now I have a requirement to open a web page after clicking on display button. I should not show windows form to the user. for that I had written following code in the Form_int (override) event of windows form. System.Diagnostics.Process.Start(http://www.google.com); and I commented out ShowDisplay(); code.  Everything looks good till now and when I run the project and clicked on display button web browser has been opened, but if I click again another web browser is being opening. but I don't want another browser to be opened. can anybody please help me in that. Thanks in advance.
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