Andreas Wijaya's Blog

Christmas is coming everyone!! Merry Christmas ^_^

Recently I was tasked to migrate the old Asset data on Access db to SharePoint 2007. It's not difficult using 'Export to Sharepoint List' command and modified certain things such as creating new asset content type, site columns etc. I can view the list and the items. Great. but there is no print button! In Access db, they were using Access form to print the asset item. In SharePoint 2007, turns out that I have to do a bit of development to do just that. I found the nice blog on how to do this. However, I don't want to spend ridiculous amount of time playing with HTML markup to get the design I want. It is error-prone as well in terms of printing etc. Therefore, I decided to try using Reporting Service reportviewer control on the page that will render the layout. The list item details will be passed as parameters :) Cool! If you search google, you would find many articles about passing the parameters in the URL. this is not good since you will get ugly url and i...

Howdy, I came across this old code of converting Word into PDF: This used to work well until recently the avdoc object sometimes doesn't get the instance (i.e. null) , however running it twice usually fixed it. I don't know what caused this. It might be a system update or something. I also researched that the above code shouldn't even work since it's using Acrobat interop to open a 'doc' type - so that code was kind of a hack. To fix the issue, I decided to find alternative way of converting word to PDF pro grammatically. This other way requires office 12 interop instead. So the idea is to open the doc in office and save it as PDF. Simple enough! here is the code: P.S: Don't forget to install Office2007 and Acrobat on the machine :) enjoy!

Here you go: Hope you enjoy it :)

What a sunny day today, and it feels brighter when everything comes into place together. Fortunately, this is also the case for MEF (Managed Extensibility Framework). At first I could not really be bothered with learning this stuff, however I found out that this framework is what I will be needing most for my project! Why? because MEF has the ability to join every piece of functionality together! Managed Extensibility Framework It basically contains three steps that you need to implement: Export : this can be any class, interface, or objects that you want to export. Import : This is the place where you can get the exported pieces and do stuff with them. Composition : Imagine this as a connector between export and import. It basically compose any/all parts that you specify in export and make them available for the import. In MEF, a piece of functionality is described as a catalog. The new deployment catalog (which I'm going to be using) is very flexible in terms of adding...

Hi Everyone, Today I want to show you what I did to get my WCF Service hosted on my development machine IIS (this could be your web server too). I am using VS 2010, .NET 4.0 framework, and IIS 7.5 in Windows 7 environment. In this demonstration I am going to use my AlkitabWebService.svc found in this post: Silverlight 4 Simple Project Part 2 (WCF Service) . Step 1 - Enabling IIS + ASP.NET Registration Click Start -> Control Panel -> Programs -> Programs and Features. On the left tab, click Turn Windows Features on or off. Turn on the features below and click OK. When you go to http://localhost , you will now see the IIS7 homepage. Now go to a command prompt and run aspnet_regiis: Step 2 - Publish the WCF service from VS 2010 Right-click the project and click Publish. Choose 'File System' as Publish method, and type C:\inetpub\wwwroot\AlkitabWebService\ This will create a folder for your WCFService that you can refer to from IIS in the next step. S...

Silverlight 4 Simple Project Part 3 (MVVM Pattern) This is the last part of the blog (finally :P). In the previous post we already created our MVVM. How do we connect our View to the ViewModel? Easy! There are couple of ways to do this. We can do it declaratively in XAML or we can do it in the code-behind. View - View Model & Binding I will choose the first option. Looking at the XAML snippet above, we declare our ViewModel as a User Control Resource and set the DataContext of our main grid to that resource. Having done that, now we can easily do our data binding for our user elements. How cool is that? We don't need any code-behind at all for our XAML! This is the beauty of MVVM Pattern. Now when we select our book title, chapter, or verse, we will get our results back in the grid without any postback since all calls are made asynchronously. Command Another new feature in Silverlight 4 is the built-in Commanding option. In this project, if you look a...

Silverlight 4 Simple Project Part 2 (WCF Service) In Part 2 we already created our WCF Service that can return some results to us when functions are called. In this post I will start building my Silverlight Application :) Silverlight Project Create new project inside the same solution. Choose Silverlight Application and name it AlkitabApplication. Right-click the project and choose Add Service Reference. click Discover and you can see that our AlkitabWebService.svc is shown. Easy! In the above picture you can also see that I created three new folders called Model, ViewModel, and Views. Move the MainPage.xaml to the Views folder. Model View View Model (MVVM) Pattern For those who are new to this term, you can read this. Otherwise you might want to move on. MVVM is just a pattern. There is no strict procedure on how to implement it. This pattern is created for developers to separate the logic of their application, providing a nice way to do unit testing and creating blendability between ...

Silverlight 4 Simple Project Part 1 (Overview & Database) Here I will create a WCF Service as a middleman for our Silverlight Alkitab Database that I mentioned in Part 1. New Project & LINQ to SQL To start, I will create a WCF Service Application from Visual Studio 2010 (I didn't choose WCF Service Library because we will host it as a 'web' application in the future). Then right-click the project, Add New Item -> LINQ to SQL Classes. We want to drag our two tables from the Server Explorer into the dbml file. This will provide us the DataContext we require for performing our queries. WCF Service Next, rename Service.svc and IService.cs to friendlier names like AlkitabWebService.svc and IAlkitabWebService.cs IAlkitabWebService.cs is the interface class for our service. This will hold all the OperationContract (functions) declarations and any DataContract (web class) that you want to create along with its DataMember (class property). Here I have s...

Howdy! This will be my first technical blog. The motivation behind this is that I love learning Silverlight (and it's version 4 now!). So I decided to create my own simple project as I am thinking of building a website for my church community group in the future. Overview: Why not start with a simple module? I want to be able to search for a bible verse in a quick way and no hassle of having to spend much time on it. Therefore I want the users to be able to select the book title, chapter, and verse (or verse range) and have the contents showed in front of them straight away! Here is a video showing the completed application with some explanation: Database: Now.. I found out that there are already some English bible web services out there. However since my community is Indonesian, I want to have an Indonesian bible, and it turns out that there is none! and there is no SQL formatted database dump available either :( However, I could find the text format of the bible....

Hello Everyone, As I am starting my blog, I want to entertain you all with few of my popular songs. Feel free to listen to all of them and give any feedback! ^_^ Here you go: 1. Rising 2. Winter Love 3. The Truth I will probably post my other songs regularly. I will also post my YouTube videos here as well. Feel free to follow my blog :) Thanks and Enjoy! Andreas