Random Technical Thoughts

This is an update to a previous post. It has been updated to use table variables instead of temp tables. This helps when you are in an environment (like production) where you don’t have permissions to create/drop temp tables. DECLARE @Results TABLE (ColumnName nvarchar(370), ColumnValue nvarchar(363

Here is some code to add a content editor web part to a page. So if you are creating a page in code (like during feature activation), then you put a content editor web part on the page. Setting the InnerText (contentXMLElement.InnerText = "";) will set the text in the content editor, incase you want

Special characters can cause all kind of trouble.  So here is a method that you pass in a string and all the special characters will be removed.   public static string StripSpecialCharacters(string stringToConvert) { stringToConvert = stringToConvert.Replace("~", string.Empty); stringToConvert = str

Here is some code to create a subsite in SharePoint. The important part to remember is to set AllUnsafeUpdates (and unset), otherwise it won’t work. try { SPWeb webSite = SPContext.Current.Web; webSite.AllowUnsafeUpdates = true; //Add subsite site webSite.Webs.Add(<WEBURL>, <TITLE>, <DESCRIPTION>, L

It’s easy to detect who the current authenticated in ASP.HET (HttpContext.Current.User), but that doesn’t work in a web part. So in a web part, you need to open a web and then you access the current user. Below is an example (you just have to specify the “SiteToOpen”).   using (SPWeb webSite = SPCon

Here is some sample code to cache a list of strings in a web part. List<String> documentNames = new List<String>();   object cacheddocumentNames = PartCacheRead(Storage.Shared, "DocumentNamesList"); if (cacheddocumentNames != null) { // cache exists, use it documentNames = (List<String>)cacheddocume

I had to find a way to programmatically add items to list that has a url field. Here is an example of how to do it. When you set the field that is an URL you have specify a url a coma (and a space) and the value to display.   using (SPWeb webSite = [...]

Here is a method that will create a list of States in the US. It will create the list in the current site.   private void CreateUSStateList() { SPContext.Current.Web.AllowUnsafeUpdates = true;   SPWeb mySite = SPContext.Current.Web;   SPListCollection lists = mySite.Lists; lists.Add(USStateList, "Li

Here is a method to create a list and populate the list with the countries of the world.     private void CreateCountryList() { SPContext.Current.Web.AllowUnsafeUpdates = true;   SPWeb mySite = SPContext.Current.Web;   SPListCollection lists = mySite.Lists; lists.Add(CountryList, "List of Countries"

You just have to set the ID property of the control, then set the control to validate to the ID of the control. Below is an example //Declare Controls private TextBox _txtFirstName = new TextBox(); RequiredFieldValidator _rfvFirstName = new RequiredFieldValidator(); //Add text box this._txtFirstName