Post New Web Links

Projected Fields

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

I love the improvements in SP 2010, especially list relationships. However, I am struggling with some of the limitations. It seems that after you create a lookup field into another list (parent list), only some columns from the parent list are available as Projected Fields. The following column types are not available to be "projected":

Calculated fields
Choice fields
Lookup fields into yet another list

I must say, I do not understand why these limitations exist. Let's take "Choice Fields" as an example. Basically a text field with a limited set of options at the time of data entry. There should be no technical reason why you cannot project such a field.

Now, that I have to find a different way of getting these types of fields projected into my "joined" view, I tried using SPD. Theoretically, there is a "Linked Data Source" that should allow for a JOIN of 2 or more lists. Unfortunately, it does not seem to work with SP Lists:

The Data Source Wizard does not allow you to match columns - one from each list (a.k.a. foreign key). That does not worry me, because the lookup field itself provides this information implicitly, but it's noteworthy.
Once the Linked Data Source was created, projected fields were filled but th

View Complete Post

More Related Resource Links

Projected Fields not available in InfoPath data connections

Projected fields are a nice way to join lists and show fields from related lists in the same view without physically duplicating fields. Unfortunately, these projected fields are not available in InfoPath data connections. I am now tempted to duplicate data and to maintain physical copies of fields in multiple lists to overcome this limitation, but it makes me uneasy ;-)

I must add, the InfoPath form is a list based form without code behind.

If you guys have a better idea, please let me know. thanks.

Iko

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?

Thanks!

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

Tables

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

I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary

I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary to store Fees information ...

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

Web Q&A: Targeting Frames, Hidden Fields, Dropdown Menu Positioning, and Distilling Other Web Sites

Robert Hess

MSDN Magazine September 2000

Using Ajax AutoCompleteExtender on dynamic fields

Hi.

I have quite a problem with a form that contains an autocomplete function. The page is an aspx page with c# codebehind.

On the form there is an address field that the user can type in any string address. This field is using an Ajax autocomplete extender, which suggests roadnames to the user. This works fine.
Furthermore the user has the option to add multiple address fields when clicking a button. This works fine now with Jquery. Jquery copies the table which contains, besides other fields, the address field, and "paste" it underneath the existing adress field.

Problem is, how do I attach the Ajax autocomplete extender to the address fields that gets added? Or is there another workaround to make all these fields have this autocomplete function?

Here is my simplfied code:

aspx page:

<td width="200">
  <asp:TextBox ID="TextBoxStopRoadName" runat="server" Width="200"></asp:TextBox>
    </td>
      <asp:AutoCompleteExtender runat="server"
        TargetControlID="TextBoxStopRoadName"
        ServicePath="SimaWebWebService.asmx"
        ServiceMethod="GetAddressList"
        MinimumPrefixLength="2"
        EnableCaching="false"
        Comp

Enable Go Button after entering data in all fields using javascript funtion

Hi friends,

My page is having one gridview with check boxes,two textboxes and one button just like this see this link now i want to enable go button whenever user has select checkbox in gridview and he needs to enter text in two textboxes. i have written onkeyup event for two textboxes to test whether user enter text in textboxes or not but i am unable to write javascript function to check whether user has selected checkbox in gridview or not to enable go button .My requiremnet is user need to enter three inputs select atleast one checkbox in gridview and he needs to enter text in two textboxes.please friends pls tell me how to write javascript function to find whether user has selected the checkbox in gridview or not

Delete spaces created by combining 2 fields

Howdy, this is kind of a continuation of an answer I got from this thread: http://forums.asp.net/t/1592766.aspx

My users will enter a city/station where an incident occured, and the date. The trigger below does work, but it will occasionally put spaces between the citystation and the date. I think this happens when the citystaion name is not very long, but not sure.

(ex: city____08242010)

How can I make sure that if the incidentid is going to have spaces, that sql deletes those spaces? I need the id to be space free.

Thanks!

===============================

ALTER

TRIGGER [dbo].[tr_AddID1] ON [dbo].[tblIncidents] INSTEAD

Linq join fields for return data

Hello,
how would I join fields together?

return (from c in storedb.Product_Categories

                         where c.Category_Name.Contains(searchText)
                         orderby c.Category_Name
                         select new {
                                    c.Cat_GUID,
                                    c.Category_Key && " ;" && c.Category_Name // HOW CAN I DO THIS.....

Linq to SQL returns null for DateTime fields.

I have a linq to sql entity class in which I declared some DateTime fileds like this:

[Column(DbType = "smalldatetime")]
public DateTime? StartDate { get; set; }

And this is how I fetch data form repository:

return repository.Logs.OrderByDescending(l => l.LogID).FirstOrDefault();

All non DateTime fields are filled properly but all datetimes are null.

[Column(DbType = "smalldatetime")]

public DateTime? StartDate { get; set; }

Crystal Reports can grow fields with large amounts of text layout problem

A can grow field in the details section of a crystal report may have so much text that the section will be larger than the remaining space available on the page (the space below the previous record). The section has vertical lines on it with Extend to bottom of section when printing set to true. The section starts on a new page (and may continue on the following one). I want it to start on the page where the last record was laid out, and continue to the new page without leaving a gap with vertical lines on it. I'm using Crystal Reports 9 and I can't work out how to do it. Has anyone got a solution?

Send an Email with User fields data entered in the form

Hi All,

I have a form which have some user input fields(like textboxes,dropdownlists,textarea etc) fields and a submit button.

on click i need to send email with body contents as all the details entered by user in the form

Can anyone suggest how i should approach to this in sharepoint..

any code examples would be appreciated.

calculate fields in a list

hi..

how do I go about generating formulas for something like this.

I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High = 1 day, exclude weekends.

Dataview CrossList problems if Person fields are Accounts instead of Name with Presence

I tried to create a CrossList DataView of all my tasks lists in a site collection. The problem is that the tasks don't show up in the data view if the "AssignedTo" column of a list is set to display the Account instead of the Name (with presence). The DataView simply seems to filter those items out.

Just to give you a background on this: for some of my lists I changed the AssignedTo column settings to display the "Account Name" of the person the task has been assigned to, instead of the default "Name with Presence". The reason why I changed it is because I use a third party software that automatically sets access permissions to my tasks based on the account name a task is assigned to.

However, as soon as I change the column to Account Name, the tasks disappear off my CrossList DataView. If I switch it back to "Name with Presence" they appear.

Any ideas why this is and how I could fix it?

How to access the refrenced table fields in Ilist object of table MVC asp.net

Hello,

I have 2 tables, master, detail. 1.master table have fields (id, username, plan)-->id is primary key (PK) 2. detail table have fields (srNo,id, worksummary, ... )--> srNo is PK.

I have created foreign key relationship from detail to .master table for "id" field.

the code is:

IList<detail> objDetail=new List<detail> (); 
IList<master> objMaster = new List<master> ();
string[] sarray = queryFields.Split('|');// 

for (int i = 0; i < sarray.Length; i++)
{
         string[] sfields = sarray[i].Split(',');

         if (sfields[0] != "")
            {

         objDetail.Add(new _detail { Id = count , modify = sfields[1].ToString(), verified = sfields[2], I});


              }
  }

I have problem to add fields in "objDetail" using Add method. But I am unable to access the reference field "Id" , rest of the field of detail table can be accessed using objDetail.

How can I access the "Id" field from objDetail object to add in IList.

I want to solve this problem

Need to pass parameters from URL to fields in Custom List

I have a complex customized list and I need to pass parameters of two fields so that when the 'Questionnaire' is completed and subsequentially opened after initial submission, it will retrieve the Number and GUID automatically in respective fields. I send an email out with a link to the 'Form' that carries the parameters. I am trying to use the following javaScript but am unsure as to where to place this on the SharePoint page for it to work.

ANY HELP is APPRECIATED!!

function loadFormVars()
{
getQuerystring('CustodianGUID', 'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_ff46_1'); ///replace
customerGUID and form field name
getQuerystring('MatterNo",
'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_FormField11_ctl00_ctl00_TextField'); ///replace customerGUID
and form field name

alert("it works");
}

function getQuerystring(key, field)
{
key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
var qs = regex.exec(window.location.href);
document.getElementById(field).value = qs[1];
}

_spBodyOnLoadFunctionNames.push("loadFormVars&


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All