Edward Wei and .NET

Why IE only prints the first page?

2008-10-31T13:06:00.000-07:00

A few days ago, an issue was escalated to me that one of the web report can only print one (first) page in IE, even the report has three pages. It appeared in Print Preview that there is only one page. But if you look it in Firefox 3.0, you can see three pages in preview and can print all three pages.The problem is with the css file (Cascade style sheet) with "absolute" keyword. In the CSS file

Smalldatetime error

2008-10-15T14:18:00.000-07:00

If you see this error: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime valueit means you have bad date to convert from string to smalldatetime data type in database. It usually occurs when you have a web form that submitted some data to save into database and one of the data is a date string. For some reason, people will type the date wrong

Can't edit DTS package email notifications

2008-09-08T08:34:00.000-07:00

After installed SQL Server 2005 Management Studio, my SQL2000 Enterprise Manager encountered an error while modifying the email notification component in DTS packages.The error message is like this:Error Source: Microsoft Data Transformation Services (DTS) PackageError Description: Cannot load MAPI interface layer for DTS. Please make sure that semmap90.dll is installed.Execution cannot continue

Step by Step Installing Visual Studio 2008

2008-09-08T07:38:00.000-07:00

Having heard so many good words about Visual Studio 2008 (VS2008), I decided to give it a try on my develop machine. Overall, it is a pleasant experience and everything worked just fine and smooth.In the morning, the first thing after checking emails, I backed up my PC. It took about 25 minutes to create a backup of my current documents and etc. Next, I put the VS2008 (standard version) install

T-SQL: Use “Having” or “Where”

2008-08-29T11:42:00.000-07:00

When writing T-SQL query in SQL Server, one has two options to limit the returned data. You can either use “HAVING” or “WHERE”. The question is when and how to use them?For example:Query1Select tblEmployees.EmployeeID, SUM( tblEmployees.intHourThisWeek) as TotalHoursWorkedFROM tblEmployees WHERE tblEmployees.Active=True AND tblEmployees.DateofWork < '1/1/2008' AND tblEmployees.DateofWork >= '

"semmap90.dll is installed" for SQL2000 DTS Mail Object

2008-08-28T12:42:00.000-07:00

The environment at my work has both SQL server 2000 and 2005. After I upgraded the Enterprise Manager of SQL2000 to Management Studio from SQL2005, I can no longer view or modify the MailObjects in SQL2000 DTS packages.(DTS stands for Data transformation system)The error is "Please make sure the semmap90.dll is installed."I installed Enterprise Manager again and tried to open the DTS package

Validation for Form Submission with Javascript: Textbox

2008-08-27T08:47:00.000-07:00

There are a few common form fields that we need to validate before submit the web form.Here is a collection of javascript code to access form field value and run some common validations.For exmaple, you have a form named "myForm1" and you have a function to validate the form submission:function validateSubmission(){ // code added inside function}1. Text field.This is the easiest one. Usually this

Dynamic Array for unknown number of data

2008-08-26T09:11:00.000-07:00

In one situation, I want to display a drop down selection of different dealers for administrator to assign dealer to various products/users. I don't want to connect to database to retrieve dealers for 100 times so I used a in-memory array to hold the dealers and build drop down selection on the ASP page.Here is the code for dynamic array and assigning values. With this array in memory. It will be

Parallel Computing in .NET

2008-08-26T08:01:00.000-07:00

It was a little surprise but not shocked when I heard that INTEL are talking to Microsoft for parallel computing programming because in a couple of years, there will be CPUs with 16 cores to 256 cores. As we have already seen many new PCs come with quad-core (four core processing units), it is not a surprise to hear 16 cores PC will come out soon. But for 256 cores? I am a little surprised. As

devLink 2008 in Murfreesboro is a great hit

2008-08-25T07:32:00.000-07:00

The two-day confernce DevLink (devlink.net) is a very good experience for me. I had listened to speakers about .NET, Visual Studio, Parallel computing, ADO.NET connection and many other topics.One most interesting thing was the new language in developing process: F# (f sharp).To my understanding, it is going to be a very smart lauguage that you can write like vb script that you don't specify