SharePoint By Gaurav Goyal

This is an example how we can update a web part programmatically in multiple sites. LiteralControl lit = new LiteralControl(); lit.Text = ""; try { using (SPSite site = new SPSite(SPContext.Current.Web.Site.RootWeb.Url)) { for (int i = 1; i < site.AllWebs.Count; i++) { lit.Text += "<BR/>" + site.AllWebs[i].Title; SPFile file=site.AllWebs[i].GetFile(site.AllWebs[i].ServerRelativeUrl + "/default.aspx"); if ( file.Exists) { using (Microsoft.SharePoint.WebPartPages.SPLimitedWebPartManager wpm = site.AllWebs[i].GetLimitedWebPartManager(file.Url, PersonalizationScope.Shared)) { foreach (WebPart wp in wpm.WebParts) { if (wp.Title == "Notes") { wp.Height = new Unit("200px"); wpm.SaveChanges(wp); break; } } } } } } } catch (Exception ex) { lit.Text += "<BR/>" + ex.ToString(); } this.Controls.Add(lit);

Here I found some good examples which shows how to use html & javascripts in calculated columns like if you want to show progress bar in task list based on percent completed or change color of font based on certain condition or put any symbol or highlight row based on any condition. Please check below given links for the same : http://sharepointwijzer.nl/sharepoint-blog/tech/icc-html-calculated-column-sharepoint-view/ http://www.pentalogic.net/sharepoint-products/free-stuff/html-calculated-column/hcc-example-uses

SharePoint Validation Controls You must check this blog for validation related controls. http://karinebosch.wordpress.com/sharepoint-controls/sharepoint-validation-controls/ http://fychan.blogspot.in/2009/12/sharepoint-validation-controls.html

PowerPivot Installation & Configuration links : http://technet.microsoft.com/en-us/library/ee210627(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210616(v=sql.105).aspx http://www.bybugday.com/Lists/Posts/Post.aspx?ID=63 http://blogs.office.com/b/microsoft-excel/archive/2009/11/11/excel-services-in-sharepoint-2010-dashboard-improvements.aspx http://technet.microsoft.com/en-us/library/ee210685(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210608(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210611(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210660(v=sql.105).aspx http://www.brainlitter.com/2010/09/05/the-given-key-was-not-present-in-the-dictionarysharepoint-2010-error/ http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4e6287f7-451b-4eec-9bef-52112587ff20/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated-the?forum=sqlkjpowerpointforsharepoint http://dennyglee.com...

Here is good solution for the same error :  http://support.microsoft.com/kb/2361559