ChoirulAmri.org

Finally I made it. After struggling with many different things during past 2 months, scattered from developing custom courseware for SharePoint 2007 developer, custom adapter for Biztalk Server 2006, or even custom ribbon for Office 2007 .

All of those things are quite interesting and blow up my adrenaline. But to be frankly, it made my ASP.NET skills a little obsolete. I need to catch up again with alot of new things on the future web area: Silverlight, Orcas, Popfly. They are waiting to be explored.

Back to my writing, this is the 4th tutorial I made for ASP.NET 2.0. I wrote those labs manual based on several existing materials as the referrence. I went to MSDN website, digging my Teched 2006 DVD, and sometimes build my own sample code. This installment is about playing with web site navigation and do security trimming on it. It is a continuation of my previous writings about security control in ASP.NET.

Normally a developer spend alot of time to develop consistent navigation, giving same look and feel across many pages. Thanks to ASP.NET master page, XML, and XML data source. It makes navigation configuration exteremely easy and fast. If you want to add new menu, just add new XML element in sitemap file. Do the same thing for disable or enable the menu for content targeting. We also able to make automated profile using profile database. But I save the ASP.NET profile and personalization for my next writing.

All writings are written in Bahasa, grab it from here:

ASP.NET 2.0: Pemrograman Navigasi Web Site

I wrote the 3rd tutorial in ASP.NET 2.0, this is the continuation of the first tutorial in data access, and the second in master pages, themes, and multiview. This new hands on lab is about managing user data with membership provider. ASP.NET 2.0 provides a good and extensible membership framework for managing any membersip tasks. Most of the membership tasks are:

• Handling user login and authentication
• Securing particular page or area in the website.
• Handing user registration and notification.
• Password management (retrieving, reset, and validation).
• Assign user to particular roles, moving user from role to another.
• Creating new user and roles
• And another so much functions…

The good thing is Membership and Roles class are very extensible. We can extend the the functonality using the Membership Provider.

This tutorial covers the basic tasks in securing web page, and store the user data in SQL Server 2005 Express database. It uses forms authentication, which is the common practice in web application. I leave the advanced tips and tricks for my upcoming commercial book, hopefully soon .

Download the tutorial and source code from here:

ASP.NET 2.0: Pengaturan Keamanan dengan Login Control

I wrote a new tutorial again, for whom who want to learn the concept of master page and themes in ASP.NET 2.0. The master page idea is really cool, you can place any contents that you want to display in several pages repeatly, just in one place. In the old ASP.NET 1.1 we have user control, but we still need to setup and do drag-drop on every pages to make a consistent layout. Or, if you proficient with CSS, you can use CSS approach for displaying consistent page layout across many pages.

This tutorial, as usual, was released for free. I mean free of charge, not free speach . I received many questions from the readers, asked me if they can use the tutorial in their own class. Of course you can, but please do not remove the license agreement. The things that you need is just give me a credit, and use it for free. That’s all.

I wrote it in Bahasa, my mother Indonesian language. I don’t need to overwhelmed the crowd with yet another english tutorial . A complete source code also included.

Download the tutorial here:

ASP.NET 2.0 Master Pages and Themes

If you’re an ASP.NET developer that work with SQL Server 2005, you may read my second installment of developer series in SQL2005. I write a brief intro of ROW_NUMBER function and how to apply it in practical use. This function replaces a tricky approach when dealing with numbering column in SQL Server. It also makes the data manipulation for a range of rows an easy task.
This writing also illustrates a custom paging of ASP.NET page with ROW_NUMBER and objecdatasource, the simple tip that will leverage ASP.NET performance. Read the article here.

Finally SQLServerCentral published my article. I discussed about PIVOT and UNPIVOT operation in SQL Server 2005, a nice enhanchment in 05 version comparing with SQL2K. I’m thrilled with many responses from the readers. They look forward for more articles about SQL2005 from developer point of view. You can read my writing here. Don’t forget to register (It’s free) if you’re not member yet.

I have submitted the second installment of SQL2005 developer series to SQLServerCentral editor. I wrote about the magic of ROW_NUMBER function, and some practical application for updating record and custom ASP.NET paging. Happy coding

Finally I make it,
I received an email from Steve Jones and Andy Warren last month, said that my article has been approved and edited for SQLServerCentral. Then I received a notification last morning, they said that my writing will be published in their site on March 29, 2006. What’s the title? Sorry I can not mention it now . But It is about SQL Server 2005. I wrote some simple tips of the new feature of this server. I’m writing the second installment now. Hopefully can be published next month.
It has been along time I just thought about writing for SQLServerCentral. Thanks to Steve, Andy, and Brian, and I’m so sorry about some grammar errors in my writing .

After play around with ASP.NET 2.0 during last eight months, I feel confidence with this new framework now. It has many enhanchment both on UI and framework, make my life easier and more productive. Then I start write a book on this topic. Still write in Bahasa Indonesia, and wil be published during next 2 months by major book publisher in Indonesia.

I choose VWD Express instead of full package of heavy duty Visual Studio 2005. Because VWD Express is free, it’s very interesting publish its capability. The most feature I miss from Express are Source Safe and any project collaboration stuffs.
Here is the table of contents of the book:

Cepat dan Mudah
Membuat Web Dinamis
dengan Visual Web Developer 2005 Express

1. Mengenal Visual Web Developer 2005 Express
1.1. Fitur dan Kemampuan VWD Express
1.2. Integrated Development Environment
1.3. Web Site Anda yang Pertama

2. Merencanakan Web Site
2.1. Diagram Pengembangan Web Site
2.2. Membuat Halaman Web
2.3. Membuat Master Pages

3. Bekerja dengan ASP.NET Controls
3.1. Apa itu ASP.NET
3.2. Menggunakan Kontrol ASP.NET
3.3. TextBox
3.4. Label
3.5 GridView
3.6 Calendar
3.7. Image
3.8. Validator

4. Konfigurasi Membership untuk Web Site
4.1. Mengapa menggunakan Membership
4.2. Menyiapkan Database
4.3. Pengaturan File
4.4. Pengunaan web Administration Tool
4.5. Membuat User
4.6. Membuat Role

5. Mengelola Membership dengan ASP.NET
5.1. Mengenal Login Control
5.2. Membuat Formulir Registrasi
5.3. Penggunaan Status Login
5.4. Reset Password
5.5. Pengujian Membership

6. Memudahkan Desain dengan Style
6.1. Mengapa menggunakan CSS
6.2. Membuat CSS
6.3. Menerapkan CSS di Web Site

7. Sistem Navigasiasi
7.1. Penggunaan Navigation Control
7.2. Navigasi dengan SiteMap

8. Membuat Web Site Lebih Personal
8.1. Mengenal Personalization
8.2 Keamanan dan Personalization

9. Meningkatkan Desain dengan Themes
9.1. Konsep dan Penggunaan Themes
9.2. Membebaskan Pengguna Memilih Themes

10. Kursus Singkat SQL Server
10.1. Mengenal Database dan SQL Server
10.2. Mendesain Database
10.3. Relationship antar Tabel
10.4. Perintah SQL
10.5. Mengenal View dan Stored Procedure

11. Mengakses Database dengan GridView
11.1. Menampilkan Data
11.2. Mengedit dan Menghapus Data
11.3. Menampilkan Gambar
11.4. Membuat Formulir Master Detail

12. Lebih Lanjut dengan ASP.NET Controls
12.1. Kontrol FileUpload
12.2. Memutar Banner dengan AddRotator
12.3. Tampilkan Laporan dengan ReportViewer

13. Memisahkan Kode dengan Web Page
13.1. Mengapa Perlu Dipisah?
13.2. Praktek1: Sistem Login dan Membership
13.3. Praktek2: Mengelola Database dengan Gridview

14. Membuat Komponen untuk Website
14.1. Mengapa Membuat Komponen
14.2. Membuat Data Access Layer
14.3. Mengakses DAL dengan GridView

15. Studi Kasus: Membuat Personal Blog

My article on Business Intelligence (BI) is published by SDA Magazine-Indonesia edition. It contains SQL Server 2005 capability as BI platform. MS has do many great enhanchments in BI area with this new product. It’s really kick some other compitors, specially for entry level BI market. Imagine this: with the cheap price of database server (comparing with Oracle and another BI player such as Business Object), your company will have BI solution in the box.

The coolest things I like is integration service or SSIS. It replaced its father DTS, but it is not DTS. MS has rewrite it, make it DTS more powerfull than DTS. It can collect data from various data source such as Oracle, DB2, flat file, XML, or any OLEDB and ODBC compliant data source. Not only importing, I also can put some function, calculation, or validation in the SSIS package. Than the loaded data on the data warehouse is have been summarized, agregated, or validated. If the developer want to do more, they can invoke it with some .Net coding. It really cool and challenge for every developer to do it.

The data warehouse than can be minned with 7 statistics algorithm, make it easier to analize and read the pattern of the data. The presentation layer is reporting service. Built and present on the browser, it is very easy to deploy across the intranet. The good things is user can do the report by themself by adhoc report designer. Also, the pivot tables capability of MS Excell still compatible with this BI platform.

When I was jumping around between spam mail in my Inbox last morning, there
was something interesting. I’ve got a mail form Microsoft guys, clearly stated
that I received MVP award this year.

=========================================
Dear Muhammad Amri,

Congratulations and Welcome to the Microsoft MVP Program!
As a recipient of this year’s Most Valuable Professional award, you join an elite group of individuals in online and offline technical communities around the world who share their passion for Microsoft products and technologies with others.
Microsoft salutes all MVPs for promoting the spirit of community by helping other people realize their potential through technology.  To learn more about the MVP Program, visit: www.microsoft.com/mvp.

Your extraordinary efforts guiding your peers in Visual Developer – ASP/ASP.NET technical communities during the past year are greatly appreciated. The benefits you will enjoy as part of the MVP Program are outlined below.
=======================================

I’m very happy with it, but it’s also raise a big responsibility to myself and the community. Thanks to all folks at IlmuKomputer.Com and INDC, for a nice cooperation during the struggle of building a learning based community.