Cascading Drop Down List (With Filter) - Custom Field Control

Cascading Drop Down List (With Filter) - Custom Field Control

: Download Code From Codeplex Here :

: Site For Reference :

The excellent SharePoint - Cascading Drop Down Lists provided by DataCogs is a great way to create relationships between fields/columns in SharePoint lists.

DataCogs Solution Page:
http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

This was further enhanced by Patrick Tisseghem to allow a grandchild dropdown. Visit Patrick's Page at:
http://blog.12thwave.com/?p=7

Expanding on Patrick's modified version to allow a grandchild dropdown list, I've added the functionality to filter the items in the dropdown.

Also, the "Required Field" validation was not validated accurately and this has been taken care of in my modified source.

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

Title : Re-Using SharePoint controls
Site URL : http://community.zevenseas.com/Blogs/Robin/archive/2009/07/03/re-using-sharepoint-controls.aspx
Desc : This post is going to be a summary of some of some the SharePoint controls I regularly use in my solutions. Cool thing about re-using the controls that are already out there is, that saves time in re-inventing the wheel and you don’t have to worry about keeping the look&feel consistent ;)

Cheers
Pritesh Gandhi
NIGHT IS LONGER FOR THOSE WHO DREAM...........
AND DAY IS LONGER FOR THOSE WHO MAKE THEIR DREAMS COME TRUE!!!!!!!!!

How to Get DataBase Name,Database Owner and Database size in a single Query ...

How to Get DataBase Name,Database Owner and Database size in a single Query ...

Nice Solution is Here

SELECT
A.NAME,
STR(CAST(SUM(SIZE) AS NUMERIC)*8192/1048576) AS 'DATA FILE(S) SIZE IN MB',
FLOOR(B.BACKUP_SIZE/1048576) AS 'BACKUP SIZE IN MB',
convert(sysname,DatabasePropertyEx(a.name,'Recovery')) as 'Recovery Mode'
,suser_sname(a.sid) as 'dbowner'
FROM (SELECT
MAX(BACKUP_START_DATE) AS BACKUP_START_DATE,
DATABASE_NAME
FROM MSDB..BACKUPSET
WHERE TYPE = 'D'
GROUP BY DATABASE_NAME) X
INNER JOIN MSDB..BACKUPSET B ON X.DATABASE_NAME = B.DATABASE_NAME
AND B.BACKUP_START_DATE = X.BACKUP_START_DATE
RIGHT OUTER JOIN MASTER..SYSDATABASES A ON A.NAME = B.DATABASE_NAME
INNER JOIN MASTER..SYSALTFILES C ON A.DBID = C.DBID
AND GROUPID != 0
WHERE A.DBID > 4
GROUP BY
A.NAME,
B.BACKUP_SIZE,
a.sid
ORDER BY A.NAME

	When your Dream turn to Dust, It's time to vacunm
From Pritesh Public Profile

Find Name of USER in Moss 2007 UserDatabase Table

How to find Name of user in Moss 2007 Userdatabase Table ?

Solutions is Here :

Select
(Select tp_Title As UserName from UserInfo where UserInfo.tp_ID=UserData. and tp_siteID='Site ID Add Here') As UserName
From UserData
Where tp_ListId like 'List ID of List'

Example

Select
(Select tp_Title from UserInfo where UserInfo.tp_ID=UserData.int10 and tp_siteID='00BAC987-FR94-000A-8760-9H316C1F3974') As UserName
From UserData
Where tp_ListId like '000efcc7-9092-4346-11a5-ae521425ffba'

Cheers
Pritesh Gandhi

	When you are waiting for the bus and someone asks, "Has the bus come yet?". If the bus came would I be standing here?
From Pritesh Public Profile

Reduce Lenghth of Multiple Line Of Text Box and Loadtip of Display Form

Reduce Lenghth of Multiple Line Of Text Box and Loadtip of Display Form

Hi ,

Download Webpart : Download Webpart

First Screenshot is display how to reduce multiple line text box character to display better view to end user.



Download Webpart Page :Reduce Length of Multiple Line TextBox

For More Details Use Below URL :

http://www.endusersharepoint.com/?p=1751

Second Good Article with using jQuery and loadTip :

Here is a great solution that Paul Grenier put together with JQuery. With this solution you get a popup for any issue, task or custom list. This does not work with link lists.

You will get a pop up when you mouse over the title of the list item. It will show all metadata for that item. What a wonderful solution so that you do not have to click on the issue to see all the details.

Orginal Post of Paul Garniar is Here : http://www.endusersharepoint.com/?p=1333

Download ASPX Page of LoadTip



References URL

http://www.endusersharepoint.com/?p=1223

http://www.bitsofsharepoint.com/ExamplePoint/Site/LoadTipBeyond.aspx

Cheers :

	Ugliness is better than beauty. It lasts longer and in the end, gravity will get us all.
From Pritesh Public Profile

Dynamic Sharepoint Chart without any Coding [ jQuery , Google Chart API, Custom List )

Dynamic Sharepoint Chart without any Coding
Techology used : jQuery , Google Chart API, Custom List

Hi All ,

Here is the orginal post thatClaudio Cabaleyro did:
http://www.endusersharepoint.com/?p=1223.

Last week was very good because I have done lot's R & D on Google Chart API & jQuery and Sharepoint List.One of nice expreince of using jQuery , google chart api and sharepoint List.Without using any out of Box functionality chart is ready in your sharepoint List.Just follow some simple steps and Without any coding chart is ready ..... Just served with smile

Preview of Movie :

Steps :

1.On the list you want to base your chart, create a “Group By” view.
2.Create a new web part page and insert the just created list view.
3.Insert a Content Editor Web Part and paste the code below (remember to use the Source Editor).

Screenshot of Dynamic Chart in Sharepoint 2007 , without any coding



Same way you can also generate multiple pie chart of sharepoint list .Minor Modification in your steps

1. On the List of Sharepoint Create 3 different view using " Group By "
2. Create New web part webpage and add this 3 diffrent View in web part page.
3. All of above add one content Editior webpart and copy and paste below Code.
4. For Tips : If you want to display only your chart then Hide All Other Three views of your custom list.
5 Cheers for life

Screenshot of Dynamic Multiple pie chart in Sharepoint 2007 , No Coding at all Smile ...

Image by Gandhi Pritesh via Flickr

Cheers
Pritesh Gandhi.

Money isn't everything but it sure keeps you in
touch with your children.

AJAX SharePoint picture gallery using Highslide

AJAX Sharepoint Picture Gallery Using Highslide

One of the Best jQuery Implementation in Sharepoint Picture Gallery.Just change css and js class library of HighSlide and Your Picture will display in diffrent style and colors.

Try to implement . Nice work by Thomas Contee ...

Screenshot :

Link : http://blogs.msdn.com/tconte/archive/2009/04/01/ajax-sharepoint-picture-gallery-using-highslide.aspx

Note : Only one limitation of HighSlide with Sharepoint Picture Gallery at one time only one thumbnil is display .So when click on thumbnil remaining image is display using jQuery.But My way Awesome work just change CSS class of Higslide and u get whatever effect u want.Thanks Thomas Contee..

Cheers

Pritesh Gandhi

Beautiful Photos are developed by negatives in a dark room so if you see darkness in your life believe that God is making a beautiful future for u.