tag:blogger.com,1999:blog-16144420953832427432024-09-11T03:46:32.099+01:00This is where I get to Curse the Compiler. it seems to be a bit of an occupational hazard, but lots of fun regardless.Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-1614442095383242743.post-60913200065584974042015-03-04T11:29:00.000+00:002015-03-04T14:25:35.507+00:00

In my ASP.NET MVC application, I have recently had the requirement to generate a few Excel Spreadsheets from Data.  I soon realised I had a lot of boiler plate code that I was starting to copy and paste all over the show.   So I took the opportunity to sit back and see if there was a better solution. I use Data Annotations a lot (for example see my Tool tip Data Annotation 

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-40618764104240425932014-07-04T10:15:00.001+01:002015-03-02T11:58:17.865+00:00

I am a fan of Data Annotations, I like the fact I can define stuff in one place and it works everywhere. One thing I felt that was missing is a tooltip annotation, which then using the technique discussed in “Standardising through HTML helpers” Coding the Data Annotation The Data Annotation is going to look like this    [StringLength(255)]    [DisplayName("Colour")]

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-66871028681338004132014-06-27T12:48:00.004+01:002014-07-04T10:57:06.241+01:00

HTML TextBoxFor in Razor are really useful. I know that is a bit of an understatement,but they can be even better.  I use bootstrap (www.getbootstrap.com) and a number of other js components such as the bootstrap date picker( http://www.eyecon.ro/bootstrap-datepicker/ ) .  And by creating my own versions of the helpers we can add a lot of conformity and standardisation.  Also if

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-14047211205005698522013-06-27T16:09:00.001+01:002013-06-28T09:58:30.252+01:00

So I needed to export a view as a pdf, and although the Chrome trick of printing to PDF is okay the page was too wide and needed tweaking. After the usual google search I came up with a couple of things I thought might be useful and with a bit of patience came up with the following solution. Create a view of the item I want to print (along with the controller) Convert the html to string

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-14165908538687748442010-05-25T18:18:00.001+01:002010-05-25T18:18:32.570+01:00

Recently I wanted to return a SharePoint list as an List<> of a business object. I did some scouring on the internet, as there is no point re-inventing the wheel.  But was generally disappointed with the results, as they required a lot of iterations and loops. Eric White’s blog here got me thinking, that we could do it with Linq So here is what I did Projects my business object

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-75241807000569767682010-05-25T18:05:00.001+01:002010-05-25T18:05:00.645+01:00

I have the problem where a user has created a view and I need to get access to it and make it public.  I appreciate this is quite a slog, especially in an ideal world the user would make the List public but if he/she has left … The first problem was identifying the information for the view. After quite a bit of digging I find it in the WebParts table in the appropriate Content Database

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-82887979360283869162010-04-20T08:31:00.001+01:002010-04-20T08:31:08.920+01:00

I had the situation where I want to show Countries along the x (horizontal) axis, but for the drill down on the click event I wanted to use the Id for the item. The solution is surprisingly simple although did cause some head scratching for an hour or so. We are going to store the additional information in an additional Y axis. To do so we need to tell the chart we are going to have an

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-29865206955445195802010-04-13T09:14:00.001+01:002010-04-13T09:16:08.780+01:00

I have just tripped over this (again), the reason; <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> had not been added to the httpModules section of the web.config file.

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-7913746723896623652010-03-31T14:16:00.001+01:002010-03-31T14:20:36.618+01:00

  Those who have read my previous posts will know I was planning on using the SSIS SharePoint Connectors for extracting data from SharePoint to SQL Server.  All was going swimmingly well until I deployed them onto the server, then for some reason (and I spent a day scratching my head) they did not work.  Unfortunately on this server I have limited debugging resources, and had to

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com2tag:blogger.com,1999:blog-1614442095383242743.post-2914137731498796672010-03-04T14:23:00.001+00:002010-03-04T14:49:40.696+00:00

As usual a little background, as I do not want you to take it out of context. I am using SSIS with the SharePoint connectors to extract data out of a SharePoint list, to do so I wanted to create a custom view, this allows me to get all of the columns and to select the rows I need.  Also I like to do these things programmatically as I personally will not be doing the release. To create a

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-49360610544062072132010-02-22T13:22:00.001+00:002010-02-22T13:22:50.238+00:00

I have been using WSPBuilder for a while and suddenly noticed that the documentation on the Codeplex site is a bit poor.  For those who do not know WSPBuilder is a tool and a set of extensions which facilitates the making, deploying and debugging of SharePoint features. Creating a WSPBuilder Project Select WSPBuilder from the project types, then select either “WSPBuilder Project” or “

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-30251441287566340892010-02-19T09:12:00.002+00:002010-02-19T09:37:25.644+00:00

I need to deploy / uninstall some features which I have created and not having access to the servers and not wanting to create complicated release notes, I came up with the following batch file it is called with 2 or 3 parameters; the first is the wsp name, the second the server and the third “U” or “u” if you want to uninstall it. I am sure everyone will have their own bit they want to do,

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-12368815287040729602010-02-17T14:24:00.002+00:002010-02-22T09:35:58.280+00:00

This is another one of those, i need to make a note of these tools and this is a “good place as any” posts. WSPBuilder – this is the tool for creating VS.Net projects much better than VSE WSS. SharePoint Manager (also has link to 2007 version)- This shows the SharePoint Hierarchy and allows you to do stuff CAML Builder – because CAML is a bugger. Although do not forget to remove the <query&

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-88845856616900789272010-02-09T15:21:00.002+00:002010-02-19T09:21:04.821+00:00

For no other reason than I have had to do this a couple of times this week and I have to keep looking it up! Restoring a database from a backup file to another database name RESTORE DATABASE WSS_Content_ArtworksTest FROM DISK = N'C:\test\WSS_content_artworks.bak' WITH FILE = 1, MOVE N'WSS_Content_Artworks' TO N'C:\Program Files\Microsoft Office Servers\12.0\Data\MSSQL.5\MSSQL\Data\

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-73556298064943028172010-02-05T09:29:00.001+00:002010-02-05T09:29:58.885+00:00

  We have all had the problem, which IIS Worker process shall I attach to when debugging. This morning I have stumbled across perhaps the easiest way of doing this! Fire up IIS, make sure the server is selected Then select “Worker Processes” et Voila!, just find the Application Pool for the correct Item.

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-33139320506315631172009-11-27T10:57:00.002+00:002009-11-30T16:45:56.726+00:00

Introduction In my last blog Unity Application Block, I introduced some of the concepts for using the Unity Application Block this blog introduces the added flexibility of using config files. This example will work either Web.Config or App.Config files, however it is possible to use other types of files. Recap We have a solution with 4 projects; InterfaceLibrary, this contains all of my

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-49688400308474911902009-11-12T16:19:00.001+00:002009-11-12T16:19:47.778+00:00

Introduction The Unity Application Block is a lightweight framework which allows/simplifies the implementation of; · Inversion of control (IoC) · Service Location · Dependency injection See the terminology section for a brief discussion of these concepts. When to use Unity these have been compiled from http://msdn.microsoft.com/en-us/library/dd203206.aspx  Your objects

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-53479651671541250932009-06-25T15:54:00.002+01:002009-06-25T17:10:45.524+01:00

Introduction The entity framework is Microsoft’s offering into the ORM market. Subsequently it maps databases to entities or objects with zero coding. Wikipedia has the following to say here. Version 1.0 has been released as part of VS.NET 2008 Service Pack 1 and the MSDN pages start here Although there has been some controversy about the tool, however Microsoft are determined that the Entity

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-74956654321682540562009-02-18T10:18:00.001+00:002009-02-18T10:18:38.070+00:00

  The comment at the following site suggests that it is not possible to put multiple lists in a feature. http://msdn.microsoft.com/en-us/library/ms434306.aspx Which although is correct, as always Microsoft have another method of doing this. The procedure is relatively straight forward. Create list Save the list as a template. Save the stp file(s) create a feature in

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-23552866228513801762009-02-14T11:09:00.006+00:002009-02-14T11:58:25.177+00:00

So we had created a new Web Part and using SharePoint Designer we put it on to a pagelayout, then deployed as a Feature.FantasticThen when creating a page based on the layout we got this error "No Parameterless Constructor defined for the Object"So a bit of digging on the internet (and reading the error message) we discover that the problem can be caused by the Web Part not having a Constructor

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0tag:blogger.com,1999:blog-1614442095383242743.post-39464284162594129132009-02-13T16:57:00.000+00:002009-02-13T17:05:23.208+00:00

So it has been one hell of a week, but it is almost over now.I have started looking at passing the ASP.NET 3.5 exam.Also had a look at Ruby for the first time.I am sure you can imagine the amount of cursing that was going on.

Richard Malyhttp://www.blogger.com/profile/04866130628362786693noreply@blogger.com0