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


Top 5 Contributors of the Month
satyapriyanayak
abhays
SP
Ashutosh Jha
Mahesh
Post New Web Links

Fetch data from one list and populate another list

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

How to fetch the details from one list & show it in an another list in Sharepoint 2010.

Example:

List #1 : Total Project/Resource List

   Resources       Projects
         Resource1 Project1,project2
  REsource2 Project1,project3


List #2 : Resources Per project

  Resources
  Resource1
  REsource2  


How to fetch details from List1 based on projects (Projects (Multiline text) are comma seperted data)

Thanks.




View Complete Post


More Related Resource Links

problem...i want a list item to populate all data in gridview!!!

  

i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?


Data Binding a DataGrid to a list fetch the same data multiple times

  
Hi, I'm using DataGrid to show data through data binding. My data are provided in a list. The setup I have is the following: DataGrid "binded" to the default view of my list that implement IList<T> and IList interfaces (MyList<T> : IList<T>, IList, INotifyCollectionChanged)             CollectionViewSource.GetDefaultView(_myList);             // Set the data context             DataContext = view; T: is here my 'business object' that hold the data, called 'MyRow'. Then the columns of the DataGrid are bound to public properties of 'MyRow' object. MyRow class has a public property of type 'object' (public object data[int index]) and first column of datagrid is bound to myRow.data[0], second column is bound to myRow.data[1] and so on.   When the datagrid is displayed, databinding kick in and my data are showed in the control. The issue I'm having is that data fetching is very repetitive even for the same rows. For example for a datagrid with 20 visible rows, the first row is fetched multiple times even if the datagrid is not resized or moved. I put break point inside my list (MyList<T> into This[T] property (public T this[int index]) and i got multiple hits into the property for the same index. Fetc

Infopath 2007: Cant we fetch data from a list or form library without using a Query to the data conn

  
I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

Search data from sharepoint list and populate repeating table (Seach text should be entre in first f

  

Hi All,

I am newbie to infopath.

I have assignment to search data from sharepoint list and display it to repeating table. Below is the case in detail.

i. User enter search text in first textbox of repeating table.

ii. After text enter you will Enter or click tab button.

iii. As user press Tab /Enter, the other textboxes of repeating table will populate with data automatically.

iv. If searched data rows are more then one, then dynamically add new row's in repeating table and  show searched data.

I am working at offical assignment and it's deadline is very tough. i had made extensive search at google and msdn forum but unable to accomplish. I would appreciate and thanks is some provide me solution in form to a small infopath application and code snippet.

 

Regards,

Mehar


On excel sheet upload read the workbook and populate data to sharepoint list

  

Requirement in my current project:
In a document library when I upload an excel sheet, a specific workbook has to be read and the contents have to be uploaded to a sharepoint custom list.
The approach followed was create an event receiver and register as a feature. Following is the code for event receiver.

public override void ItemAdded(SPItemEventProperties properties)
        {
            base.ItemAdded(properties);
          
            var list = getSPList("{150301BF-D0BD-452C-90D7-2D6CD082A247}");          
           
          
            SPListItem doc = properties.ListItem;
            doc["Msg"] = "items deleted from req list";
            doc.Update();
            string excelname=doc.File.Name;
&n

Populate Drop-Down list box from Active Directory Data Connection?

  
Hi,

I recently created a data connection to my active directory, so that certain fields can be automatically populated given the user who is filling in the form.

However, I would like to have a drop-down box that is populated from Active Directory (i.e. the user of the form can select another AD member), the result of which will then populate other fields (with information such as Manager, Email Address, etc).

So, 2 questions:

  1. How do I get a drop-down list to populate with the members of AD?
  2. How do I get the result of this selection to populate other fields?
Cheers again - you guys are great!

Auto populate the list data into infopath-- sharepoint 2007

  

I have a list with Job code,Apply online,Name.. as columns with two workflows.

When a new item is created in the list,workflows will run(mentioned the workflows below).

1.Job code ---Setting a unique number to JobCode field(i.e 1 and the next Jobcode wil be 2....)

2.Apply Online(it is a hyperlink)---Storing the infopath url into this ApplyOnline field.

Now on clciking on the list item,we will get dispform.aspx page then on clciking on Aply Online field then infopath form wil open.

Infopath has Job code field as Text box.

Now,I want to auto populate the infopath form with the corresponding list job code field.

help me on this.

 


Jyoshna

Caml Query to fetch the data from Sharepoint List for a specific date.

  

Hello,

I have a sharepoint list with one of hte columns being Created Date of Type DateTime and value allowed is OnlyDate.

The submitted date in my column is 05/18/2011. When I perform a search using the below CAML query, it does not give any results though I have two items with this date.

<Where><Eq><FieldRef Name='Date_x0020_Created' /><Value Type='DateTime'>5/18/2011</Value></Eq></Where>

I dont understand what is wrong with this query. Someone please help


Janaki Thakur

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



Pulling data from MyProfile page to People & group's list

  
Hi, Is it possible to pull the data from Profile page, like the email, contact number etc to be displayed in the People & Groups page. Please refer the screenshot for better understanding..

Link to the image: http://img694.imageshack.us/i/pplgrps.png/


Use BDC data in list as multi-select column

  
I have a document library that uses values from another system for its metadata.  Right now, we copy the values from the primary system into SharePoint so users can choose them.  I want to find a way to use the BDC connection that I have set up to automatically pull those values.  The problem is that the current metadata is set to multi-select.  So, I have a file that is in the library and it can be used for multiple clients - clients is a column in my library and users can select many entries.  When I set up a column to pull BDC data, it only allows single entry.  Does anyone have any ideas?

Sharepoint list group by column data ,display in webcontrol like panel or label

  

I  have a sharepoint list[Managers] with groupby sector column. like below

1)Sector1
a)Dep1
b)Dep2

2)Sector2
a)Dep3

3)Sector3
a)Dep4
b)Dep4
c)Dep4

Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?

REgards
mansoor

 


Regards, Mansoor

Video: Accessing SharePoint 2010 List Data

  
In this video you will learn how to create strongly typed classes using a tool called SPMetal to do LINQ programming against a SharePoint 2010 list. (Length: 15:22)
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