Optional parameters in Stored Procedure

MS SQL Server, Programming, Windows No Comments »

Introduction

When you create a store procedure on Microsoft SQL Server with some input parameters, sometimes you don’t want to assign all of parameters (optional parameters) so you need to specify default value for the parameters. Otherwise, it shows error when execute the store procedure.

Read the rest of this entry »

Create Dynamic RSS Feed from MS SQL Server using ASP.NET, Part II: C#

Programming, Windows 2 Comments »

This post, I’ll cover only in the second section “Create ASP.NET Web Application on MS Visual Studio 2005 (C#)”. I’m not going to repeat other sections again since they’re same as in the previous post. The other sections can be found in “Create Dynamic RSS Feed from MS SQL Server using ASP.NET, Part I: VB.NET”.

Read the rest of this entry »

Create Dynamic RSS Feed from MS SQL Server using ASP.NET, Part I: VB.NET

Programming, Windows 2 Comments »

Introduction

Before I started, let’s get to know what RSS is.

Quoted from Wikipedia.org Read the rest of this entry »

Biztalk Macros on FILE Send Adapter

BizTalk, Programming, Windows No Comments »

Microsoft BizTalk server provides a predefined set of macros to help in create output filenames on File send handler. If you working with sending output as a file, you’ll find these macros are really useful that you don’t have to coding any statement to get these value. These macros can be found on MSDN library but I sometimes find it’s time consuming to search on MSDN every time I forget the macro. Therefore, I decide to quote the table from MSDN to this post instead.

Read the rest of this entry »

Developing a Windows Service, Part IV: Debug the service

Programming, Windows No Comments »

Introduction

From previous part, you’ve learned to develop a simple windows service on Microsoft Visual Studio 2005 and how to create a setup wizard for install the service. But it wouldn’t be complete, if you don’t know how to debug a windows service while you’re developing a windows service. This part is about how to debug a windows service.

Read the rest of this entry »

Developing a Windows Service, Part III: Create a setup wizard

Programming, Windows No Comments »

Introduction

In this part, I’m going to create an installer project for install my windows service ‘MyService’. The installer wizard helps you to install service easily simply click next, next,.. and finish then you are done. With wizard installation, you can also uninstall the service from Add/Remove Program. If you prefer not to create setup wizard, you can install the service manually, too. You can find the detail about manually install the service at the bottom of this post.

Read the rest of this entry »

Developing a Windows Service, Part II: Create a simple Windows Service

Programming, Windows 2 Comments »

Introduction

In this part, I’ll show how to create a simple Windows Service project using VB.NET on Microsoft Visual Studio 2005. The example service will generate a message to application event log every 10 seconds.

Read the rest of this entry »

Developing a Windows Service, Part I: Introduction

Programming, Windows No Comments »

Introduction

What is Windows service? Windows Service is an application or a program that can run without needing any user interaction. It is useful in server environment that no need user to logged in on the system but the services are running. The status message of the service always write to event log.

Read the rest of this entry »

Powered by WordPress | WP Theme & Icons by N.Design Studio

Entries RSS Comments RSS Log in