.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-fill Title and other fields from a data View edit menu

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :SharePoint
How do I Auto-fill Title and other fields in a list from a data View edit menu. The Title and other current data should transfer from the data view row being edit. Can anyone point me into the right direction how to accomplish this? Thanks. Mike  

View Complete Post

More Related Resource Links

Auto fill fields with BCS data

I have setup a sharepoint foundation 2010 site for testing a customized list.  I am using BCS and external content types to connect to SQL database.  This works well. 

In my custom list, I have created an External lookup column (looking at the external list) for the customer's account number. In the external item picker, I have the account number, customer name, and customer's shipping address.

Also in the list, I have a text column called 'Customer Name'.  Here is what I want to happen:  When a customer number is picked from the external lookup column, I want the Customer Name field to be automatically filled while still filling out the new item.  I know that I can add the column from the external list to the dispform.aspx and any list view, but I want the info to populate while the user is still creating the item.  Any way of doing this?

How to put Data in multi Taxonomy type fields using Datasheet view

Hi, We have a requirement where data has to be uploaded to a list having a Multi Taxonomy column.Is it possible to do so using datasheet view. Or please suggest if there is any other way. Thanks, Ash

Auto-fill fields are racking up the version history whether they are on one workflow or many....SPD


I have a whole batch of fields which trigger an automatic date entry when they are changed: if more than one field is changed then a version is created for each field that is changed. I did some more fiddling to see how many of these workflows I could cram into one (originally built to have one workflow per date trigger) and tested again but although the changes are grouped together now the system automatic updates still trigger another version for each automatically entered date. Anyone know how to get around that? Its not unbearable but it just offends me somehow and it might cause a problem later on.

Need help on Select button column in Data Grid to populate fields in Form View


 When I have a select a row in a Data Grid that when I click on it I want it to show the info for the person I selected in a form view on the same page as the Data Grid. Here are the columns for the Data Grid that I have set up, the column is highlighted:

<asp:DataGrid ID="MHGrid" AutoGenerateColumns="False"  
        DataSourceID="MHFoundation" DataKeyField="POPULATION_LIST_ID" 
        AllowPaging="True" AllowSorting="True" BorderStyle="Solid" 
        BorderColor="#999999" BorderWidth="3px" CellPadding="4" PageSize="4" 
        CellSpacing="2" runat="server" BackColor="Gray" Font-Bold="False" 
        Font-Italic="False" Font-Overline="False" Font-Strikeout="False" 
        <SelectedItemStyle BackColor="#FF9900" Font-Bold="False" Font-Italic="False" 
            Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
            <asp:ButtonColumn CommandName="Select"  Text="Select"></asp:ButtonColumn>
            <asp:BoundColumn D

Enabling Edit , delete and insert in Data view with linked sources


Hello ....


I create a data view in sharepoint designer 2007 that has linked sources (Join between two lists) ....


How can I enable edit, delete and insert links in this data view  ????.... taking in consideration that options available in data view properties appear in gray ...



Data view web part and item menu


Good morning, I'm using the SharePoint Designer 2007 and I would like to show the item menu using the data view web part. Below is an example of what I want to do:

How can I do that?

Sharepoint Foundation 2010 - How to control which fields are shown on new/edit/view forms for Extern


I have an external list which contains a DateTime field.  For the display I have added an additional string field to the BDC Entity , so i can display the date in whatever format is required.  But i still need the actual date field so a Date picker is rendered on the edit form.  How can I display the string field on the generated Display Form and the date field on the Edit Form.

I have tried adding the following to the field declaration (in the List schema) for the string field so that it's only shown on view forms, but that didn't work.   

  • ShowInDisplayForm="TRUE" ShowInEditForm="FALSE" ShowInNewForm="FALSE" ShowInViewForms="TRUE"

Am i missing something, or is this yet another 'feature' of external lists which looks like it should work but doesn't? 

I know i could create custom iew and Edit Forms manually t

Using Drop down menu in a grid view control for entering new data


I wish to use drop down menu(based on a table of my database) to update/insert data in a web form. The data is then fetch in to SQL table (Express).

How to do it ? 

Combining view-only data and Dynamic Data on insert/edit pages


Hello all, here's a problem I've been trying to figure out an elegant solution for, but so far I'm coming up blank. I have a situation where I'd like to display view-only data and Dynamic Data together on the same page (without creating custom insert.aspx and edit.aspx pages). I've been playing around with using a SQL view, so that it returns me both my view-only fields and my updateable fields as well. I'm having issues with the insert side of things, the edit page works quite well, and I know I'm going to have to create custom delete logic. The major drawback to using a SQL view though is that to get it to behave you have to 'hack' the .edmx file, and I'm not sure I want to do that. So I guess what I'm asking is that has anyone had any success with this, or should I just bite the bullet and create custom pages for the situation of having view-only data and Dynamic Data on the same page? For the record I'm using the Release Candidate version of VS, and my website is an "ASP.NET Dynamic Entities Web Site". Thanks!

Data Form Web Part - Sharepoint Dropdown List as a field in Edit View - Possible?


Hi guys,

I'm building a Sharepoint page with a data form web part that uses custom SELECT and UPDATE statements with an SQL Server connection in order to retrieve and store records of information.

I'm getting along fine, records seem to update how they should etc, but I've ran into a problem with one thing: Sharepoint dropdownlists in 'Edit Template'

So the issue is this: if I replace a textbox field with a dropdown list that is populated with a separate SQL datasource, the dropdown list seems to be unable to show the current value of the field.

E.g. I have a dataview which has a field "FruitID", which I can update just fine by setting the ID value to different numbers. The SQL datasource uses the FruitID to display a list of all available Fruits, (e.g. 1 = Banana, 2 = Apple, 3 = Cherry, etc).

If i open the dataview in editmode, the default value in the dropdown is null, despite the real value of the field being "2", which should show "Apple" in the dropdown.

I can select a fruit and click save, and it will update just fine. But the initial display needs to show the correct value to start with.

Is there a custom binding I should be coding to make this work? I can't configure dropdown <items> on an individual level as they are populated from the SQL server. I can't set "SelectedI

Display data from two lists in a single Data View - how to edit/delete/view items?


I have an aggregate dataview from two lists. (something like this http://office.microsoft.com/en-us/sharepoint-designer-help/display-data-from-multiple-sources-in-a-single-data-view-HA010099144.aspx#BM3)

The problem is, that when I click on "Data view properties", the options in Editing tab (edit link, delete link and view link) are greyed out.

 I'd like to create custom delete/edit/view link for rows in that dataview with linked source. Any idea?

Create ID (uniqueid?) from two fields when data is entered


I need to create an ID from two fields when they are entered into the db for the first time.  I thought Uniqueidentifer would do this, but it looks like uniqueidentifier is random and i have no control of the process. 

My user will enter 4 letters into a column called INIT and 4 numbers into a column called NUMB.  What I would like to do is create an id by combining those fields.

How can I do this?



LINQ with GridView and edit fields


My project includes a grid view which displays information of inventory items (Assets), data is quried from AssetTable. The GridView has a command field to allow editing, below is a description of the tables and how data is displayed


BuildingTable: (BuildingID, BuildingName)

AssetTable: (BuildingID,..,....,....)


ItemTemplate: Using a LINQ query I join the two table and displays in a label control a string which includes BuildingID and BuildingName (5 North Building)

 EditItemTemplate: Using a LINQ query I populate a DropDownList with strings of BuildingID and BuildingName same as above.
Here  issue which I need to resolve:
1.  ItemTemplate display the correct information (BuildingID BuildingName) but when I switch to EditItemTemplate the pair that is 
displayed is the first one on the list, how do I make is scroll to the item which was displayed in the label ?
<asp:CommandField ShowEditButton="True" >
                    <ControlStyle Wi

Vista and Office: View Data Your Way With Our Managed Preview Handler Framework


Stephen Toub shows you how to write your own Preview handlers for Windows Vista and Outlook 2007.

Stephen Toub

MSDN Magazine January 2007

Cutting Edge: Custom Data Control Fields


In ASP. NET 2. 0, the GridView and DetailsView controls are designed to work together. They don't merely provide complementary services, they also share a number of helper classes and components. The output of the GridView control consists of a sequence of rows, each with a fixed number of columns.

Dino Esposito

MSDN Magazine January 2006

Disable filtering on a Dynamic Data list view.


I have an entity set of NotificationTemplates, and each one of these has a collection of zero-many SmsTemplate entities. When editing or viewing a NotificationTemplate, I have a link to View SMS Templates. That link takes me to a List view for the SmsTemplates entity set, filtered for the NotificationTemplate I was viewing.

How can I prevent the user changing this filter to show SmsTemplates for another NotificationTemplate? That is, I want the filter, but it must be read only. The drop-down just mustn't drop down, it must just display the name of the NotificationTemplate that these SmsTemplates belong to. To view SmsTemplates for another NotificationTemplate, the user must click View SMS Templates from that other template.

This was originally asked by myself on SatckOverflow at: http://stackoverflow.com/questions/3514373/disable-filtering-on-a-dynamic-data-list-view

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