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.
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”.
Before I started, let’s get to know what RSS is.
Quoted from Wikipedia.org Read the rest of this entry »
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.
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.
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.
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.
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.
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 2.5 License.