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

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

Auto populated 'New item form' not saving to sql

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :SharePoint
Hi, I have created a 'New item form' for a sql datasource via Sharepoint Designer. A lot of the fields are pre-populated using parameters pulled from a wedpart on the same aspx page. I have assigned the parameter to the field by setting the 'text' value to equal the parameter e.g. text="{$p3address3}". If I manually type values into the form (with no pre-populated at all) the data saves perfectly into the sql table but if I submit the form when I have pre-populated the fields then no data saves at all. Am I missing something? Is there a different way to set the values for my fields? Thanks Jeni

View Complete Post

More Related Resource Links

Workflow does not auto-trigger on form item change


Hello there,

Background: I am using an Infopath 2007 (Client based forms) form library, I am associated a condition based workflow which updates another list when ever a form changes. 

Problem: The workflow does not auto triggers when a form item changes.

I am aware that the workflow doesn't auto-trigger if the change is initiated via system account. I also have checked the option which says: 'automatically start the workflow whenever an item is changed'. Worklfows auto triggers easily on infopath web based forms and lists. 

Question: Does this mean that we can auto-start an infopath client based form on item  change?


Any help in this regard will be appreciated 

create a secure new item form



i hope i can explain this the right way.

i'm using sharepoint services 3.0 and sharepoint designer

i have to create this senario:

the employee need to fill in a new item form to request for absence or vacation days.

for this i use the Absence and Vacation Schedule template. a good one!

but the thin is i have to modify the "new item form" that when the user open the "new item form" it has to get the id from the employe and join it to the id of his manager. so when the employee fill in the form it can only go to the employe his manager for approval. the purpose for this senario is that the employee dont get a chance to send his request to another manager or to the HR department without an aproval.

is there a workflow for it. or how can i join the employee id with the manager id?

and how can i create a web part that counts the vacation days of an employe and also display how many days he has left so he knows how many days he can request for?

hope some1 can help me with this


On New Item form, select item on choice dropdown based on query result.


I posted this on Experts Exchange awhile back with no answer, so here's hoping someone here has an idea :)

So I've mostly figured this problem out, but I need some help in getting over the hump... note that I'm using JavaScript to do this (SPServices) on SharePoint 07'.

I'm on the New Items page of a list. Based on a user's selection in a "Teacher" dropdown, I'm doing the following:

1.) Get the value of the Teacher field and several other fields (School and Visit Date)
2.) Run a CAML query based on those fields to find the last list item entered for that Teacher

So here's where I'm stuck...

I have 10 choice fields, all with choices 0, 4, 7, and 10. Depending on what they were set to in the last entered item (which I queried), I want to set the selected item on each of those dropdowns to equal that. So "Score 1" was set to "4" on the la

c# form problem with list item


I've got a c# form containing a listbox how ever i cant get

listbox1.items.Selected      to work



neither work. both not giving me the option for .selected nor selectedvalue

how does this work on c# forms as it works the above way on webforms....

new Item form assigned to a specific user

hi, i want to create an absence request form with the new item form. and when the user fill in the form he can't choose for whom he will send it for approval the form is automatically set to be send to a specific approver.   thnx

Auto saving the Winform application

hi,   I am developing a huge win form application, which has lot of win forms, user controls and wizards. For user it will take some time to fill-in all the fields and complete the wizard. I wanted to implement auto saving the application for every 3-4 minutes, this should be done in the background without disturbing the user activity (or thread)..   can anyone help me to implement this? Please share your ideas.   thanks

sharepoint New Item form database table

hi, i want to know if i create a custom list in sharepoint designer and i modify it with my own fields. when the user filled this form where in the database are the filled data stored. thus in witch table in the wss_content db will the data be stored?

Unable to Show Edit item Links in Data Form Web Part

I have a DFWP connected to custom list and the boxes to Show Edit Item Links, Show Delete item links and Show Insert Item links are grayed out so that they can not be checked. This works fine when I use a DFWP connected to a standard list (i.e., Contacts). Is there something special that needs to be done to activate this functionality?ThanksDean

Printing list item as a infopath form

The infopath turn off the print option and Idont know how to activate it. It is a list item that desiend with the infopath desiener and have some data conections to other listes at the same site thanks Aharon

Custom Contact List: has to be auto-populated with users and manually insert others contact

Hi All, is it possible to create a custom contact list that automatically insert user as contact? I have to use it to send auto-email to the people in the contact list... (ant they can be user or not) Thanks All Vit

Auto-generating Name When Saving an Image

hi guys, I have a toolbar on my chart:  <Toolbar Enabled="True"> <Items> <dcwc:CommandUIItem CommandName="PrintPreview" /> <dcwc:CommandUIItem CommandName="Print" /> <dcwc:CommandUIItem CommandName="Separator"/> <dcwc:CommandUIItem CommandName="SaveImage" /> <dcwc:CommandUIItem CommandName="Separator" /> <dcwc:CommandUIItem CommandName="UserDefined_1" /> </Items> </Toolbar>     For the SaveImage, I want to be able to set my image name with its own name. the name can be found using:   string fileName = Request.PhysicalApplicationPath + @"graphs\"+User.Identity.Name+graphID+".jpg"; Right now, when I click save, it always show chart.png And also, I want to download the chart as jpg.   thanks guys.

Add a New Item to a Custom Sharepoint List and Sharepoint Calendar from one Infopath form.


I am trying to create an infopath form for requesting time off.  Once the request is approved I want the form to add the event to a calendar on sharepoint.  I was able to do this using the article by S.Y.M. Wong-A-Ton at http://www.bizsupportonline.net/infopath2007/programmatically-add-item-sharepoint-calendar-infopath.htm.  But I want the form to also add an item to a custom list that has the employees available time off stored on it.  That way the form can automatically subtract the time entered on the infopath form from what is available on the custom list.  I was able to do this using another article by S.Y.M. Wong-A-Ton at  http://www.bizsupportonline.net/infopath2007/programmatically-add-rich-text-item-sharepoint-list-infopath.htm.  I can make both of these functions happen seperately but I need them to happen on the same Infopath form.  I am using Infopath and MOSS 2007.  I have tried to use 2 CAML receive data files and I treid to co

Infopath browser form - odd behaviour on auto expanding multi line text boxes




I have a browser form with a multi line text box. The height is set to be AUTO. Within the client all is fine. When opened as an administrator approved form the text box automatically adds a new line for every 20 characters you type.


So if you type 40 characters without pressing enter you get 2 blank lines appear under you text that you CANNOT remove.


I have tested this on a new form with various multi line text boxes. The width setting is unimportant, the spell check setting is unimportant.


If i fix the height then the issue goes away but this is not any good.


I cannot use rich text boxes as i have around 40 text boxes on the form and if they are rich text they take around 10 minutes to load in the browser (this is another issue i have)


Thanks in advance



auto-populate infopath form with sql server data connection



is it possible to auto-populate an infopath form with a sql data connection?

i have a form that only populate the username of the logged in user. but i want to use a secondary data source to auto-populate the user his email, id and department all comming from a sql server database.

and after that auto-populate the user's manager name using sql server db

is this possible in infopath 2007 and how can i do this?

auto-scrolling to the selected item in a listbox



I have a listbox which is populated with items at Page_Load and has 5 items visible at a time.  Then there is a textbox where the user types some characters. On keyup event of the textbox  my code searches the listbox for the entered value and selects the item closest to the entered value. However the selected item appears as the 5th item in the listbox. I want it to be the 1st item displayed.

Any ideas ??


Customize form to add new item - can i pass through a variable?


I have a list of issues stored in a SharePoint list.

I now want to store tasks relating to these individual issues.
Ideally, when a user is viewing the issue they can then click on an 'add task' link that will open up a new task, in a standard task list, and pass through the issue id into a custom field.

Any ideas?

creating new item in form library programmatically


Hi all,

I have a form library with infopath form published in it. I am trying to create a new item programmatically in it which will contain a instance of the published infopath form. But its suggesting me to use SPFileCollection.Add() for that.


Can anyone show me some light how I can meet my requirement?



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