StanleyGu's Blog

1.       Using Microsoft Word 2007 as an example, you can open test1.docx and test2.docx at same time. The two documents are opened within single instance of the word application. World application supports command line argument of passing multiple documents.

You have ASP.NET 3.5 web application deployed to windows server 2008 R2 and IIS7.5. The physical location of the application is C:\MyWeb. You receive errors when you use IIS Manager to browse the application. The following is the check list that can help you prevent the errors from occurring.

1. It is quite straightforward using SmtpClient class to send out an email

1. My first choice is always to try System.Diagnostics to kill a process

Scenario 1 : You have a Purchase table with field named DiscountRate. The DiscountRate values can be true percentage such as "2.5%", "5.0%", or can be other values such as "N/A", "Fixed Rate", etc. You want all the records with true percentage.

You have a Purchase table with fields of ID, PurchaseAmount and PurchaseDate. The PurchaseDate field is DateTime type that includes Date and Time information. You want daily total purchase amount.

You have a Customer table with three fields: ID, LastName and FirstName. You are building a data access layer to retrieve all the records from the Customer table and return the result as a collection of Customer objects.  You want implement it using Microsoft Enterprise Library.

You have a stored procedure GetCustomers with two parameters: LastName, FirstName. The stored procedure returns all the records matching the values of the parameters. You want the parameters be optional, which means skipping the parameter if you do not pass a value.