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


Top 5 Contributors of the Month
satyapriyanayak
Subhransu Sekhar Jena
abhays
SP
DotnetUser
Post New Web Links

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

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
 

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


View Complete Post


More Related Resource Links

Best way to display data of a single column from a Sharepoint Custom List

  
I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

  
Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

display sharepoint list Data into content Query Web Part

  

Hi i have content query web part. now i want to show the sharepoint list data into my content query part

using CQWP setting, i am able to get only one column data but not all.

pls let me know how can i get all list data in different style format 


Custom Display in Data View column in SharePoint

  

Hi

I am using SharePoint designer 2007 to create Data View web part where I want custom display text in one column depending upon condition. In designer there is way to implement custom display which allows to change style conditionally. Is there any way to change the text conditionally?

Just to underline the problem I want to change text in Data View column conditionally.

Thanks

Shailesh


How to remove the group ID of a lookup column when exporting SharePoint list to Excel?

  

I am exporting my SharePoint list with a people/group column and another lookup column to Excel spreadsheet. The problem is, in addition to the content of these two column, the group ID (from the lookup lists) of these two columns show after like "Jack Smith #45". I really need remove these numbers. I tried to use Excel formulas, but i found it very difficult since both of these two columns allow multiple choice. Any ways?

thanks.


Default Value for 'Person or Group' column in a Sharepoint 2010 Custom List

  

Hello,

In Sharepoint 2010 I have a Custom List with a column of the type 'Person or Group'.
I would like to have a default name for this 'Person or group' column.
So when a user creates a new list entry and leves the 'Person or Group' column value blank the list entry should be created with the default value für the 'Person or Group' column.

Is there a way to schieve this?

Many thanks in advance.

Roberto Rocco.

 

 


Sharepoint List Column Custom Colors With Group By column Option

  

I have tried to implement the custom coloring or manipulating data on columns in multiple ways like

http://blog.pathtosharepoint.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/

http://blogs.msdn.com/b/sharepointdesigner/archive/2007/06/13/using-javascript-to-manipulate-a-list-form-field.aspx

http://www.sharepointboris.net/articles/the-power-of-content-editor-webpart/4-highlight-weekends-in-list-view/

http://blog.pathtosharepoint.com/category/calculated-columns/page/2/

However, all the above does nto work if you enable the "Group By" column option in the "Modify View" settings. It does work if the "Expanded" option is checked, however, it does not when "Collapsed" option is selected in "Group By" options.

Any help will be appreciated.


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?

Display tooltip for Sharepoint list items

  

Hi All,

I am using MOSS 2007 and my requirement is to show tooltip when I hover the mouse over the title column for each item. I am planning on storing the tooltip string for each listitem in a seperate column. Is there a way to do it. I am sure there is. Any help is greatly appreciated.

Thanks in advance!

 

 

 


how to hide/display controls in NewForm.aspx based on dropdown value in SharePoint list

  

Hi,

I have 1 dropdown in my sharepoint list with other columns. If dropdown value equal to 'xyz' i need to display some other controls, otherwise these controls should be hidden.

I know we can achieve this with javascript. If any one can provide code or sample then it will be appreciated. or is there any other alternative methods to do this ........


Thanks & Regards, Neerubee

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)

Video: SharePoint 2010 Lists, List Data, and CAML

  
This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

Importing SharePoint List Data into Project Server 2007 Custom Fields

  
Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.
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