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


Post New Web Links

SharePoint 2010 SPSiteDataQuery - Get data for Lookup Field

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#
 

Hi,

I am trying to get Lookup field using SPDataQuery. But it doesn't retrive data for that column.

query.ViewFields = "<FieldRef Name=Title' /><FieldRef Name=IssueProgress' Type='Lookup' Nullable='true'/>",

I went through the following post

http://social.technet.microsoft.com/Forums/en-GB/sharepoint2010programming/thread/992fcf4d-bf12-4088-b5fc-48955c402f65

Is there any tweek to get the data from lookup field?


Thanks, Rocky Fernandes


View Complete Post


More Related Resource Links

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

SharePoint 2010 SPSiteDataQuery with Lookup additional columns.

  

Hello

I am trying to use SPSiteDataQuery to collect data across different sites. The query seems to fail when I add Lookup additional data columns. I mean when we create a lookup column, sharepoint 2010 allows us to get data from additional columns from the lookup list. When I try to include these columns SPSiteDataQuery is failing. This is the viewfields that I am using.

"<FieldRef Name='ID' Nullable='True'/><FieldRef Name='Lookup' /><FieldRef Name='Lookup_x003a_Title'/><FieldRef Name='LinkTitle' Nullable='True'/><FieldRef Name='Created' Nullable='True'/><FieldRef Name='Modified' Nullable='True'/><FieldRef Name='ID' Nullable='True'/>"

In here the Lookup_x003a_Title (displayname : Lookup:Title) is the column that bring data from the Title column ofthe lookup list.

Any help is greatly appreciated. The query works fine without Lookup:Title column.

Thanks

Vijay


Submitting data to a lookup field in a SharePoint list

  

I'm trying to submit values to a SharePoint list that contains text fields and lookup fields.  I'm doing this with a WebServiceConnection and an XML file.  When I execute the submit without the lookup field, it works perfectly.  When I execute the submit with the lookup field it doesn't error out but my list is not updated.  Can anyone help?


Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010

  

SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010


Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

  
In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Quick Note: Create Silverlight Graphs with SharePoint 2010 Data by Using LINQ

  
In this exercise, you will learn how to create Silverlight applications to retrieve SharePoint 2010 list data using LINQ.

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Developer Training: Data Access in Technologies in SharePoint 2010

  
Learn about the new data access technologies in SharePoint 2010 and how they can help increase your productivity. This training module covers the basics of LINQ handling and how to use the Client OM and REST to access SharePoint 2010 information remotely.

Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ

  
In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.

Quick Note (Scenario): Getting Started with Data Access in SharePoint 2010

  
The goal of these exercises is to give you the steps that you need to access data from various sources by using web development tools and technologies such as SharePoint 2010 and Visual Studio 2010.

Sample: SharePoint Server 2010: Aggregating Data Using BCS and .NET Assemblies

  
Use the BCS Data Aggregation sample with BCS in SharePoint Server 2010 and to aggregate data from two external systems.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

  
Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverlight 3

  
Learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Video: Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverli

  
Watch the video that accompanies the MSDN article and learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Integrating External Data and Microsoft SharePoint 2010 Platform Services in Microsoft Office 2010 S

  
Microsoft Office 2010 integrates with SharePoint more closely than in previous versions. The resources here show you how to take advantage of the powerful collaboration infrastructure.
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