a helpful tutorial for Creating a Data Access Layer in VS2005 Express

http://www.asp.net/learn/data-access/tutorial-01-cs.aspx

How to retrieve visitor's IP in C# ASP.NET 2.0

string strHostName = System.Net.Dns.GetHostName();
string clientIPAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
return clientIPAddress;

MSSQL LIKE operator work with parameter values

without parameter: LIKE '%abc%'
with parameter: LIKE '%'+@searchString+'%'

useful stuff to solve visual studio 2008 slowness

found these links quite useful:
http://blogs.msdn.com/webdevtools/archive/2008/02/09/downloadable-hotfix-performance-and-editor-fixes-for-microsoft-visual-studio-2008-and-visual-web-developer-express-2008.aspx

https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=10826

Tomorrow's CIO: Are You Ready Today?

found this tool on InformationWeek very interesting:
http://www.informationweek.com/news/management/interviews/showArticle.jhtml?articleID=208403497#sg_wrapper

Cannot open .zip file in WSS 3.0

found solution for this problem on Microsoft
http://support.microsoft.com/kb/841120

WSS 3.0 Search Service on SBS

You need to install and start Windows Indexing service, start SharePoint Search Service, and Change the Identity of the SP website in IIS-->Application Pools-->Properties from Network User to Local System User

project management - agile

project management - agile
In order to be agile everyone in the team must be proficient.

ASP.NET DataBinding Eval V.S. Bind

Eval is used for one way data presentation whereas Bind is used to push data back to the database. Some detailed explanation:

http://www.15seconds.com/issue/040630.htm

Agile Project Management with Scrum

found this about Scrum, very helpful

http://agilescrum.tar.hu/agile_scrum_0035.html

"check-in pending" problem opening enterprise project within MS Project 2007

work around:
1. delete cache OR
2. when close the project, don't just click on "x", instead go File - Close

Available fields in Microsoft Office Project 2007

Available fields in Microsoft Office Project 2007
http://office.microsoft.com/en-us/project/HA102369301033.aspx?pid=CH100788901033

what is Queue in MSPS 2007

Microsoft Office Project Server 2007 Queuing System

http://technet.microsoft.com/en-us/library/cc197395.aspx

what is resource units in Microsoft Office Project 2007

Sometimes it takes one resource to complete a task, but other times you need more. Sometimes a resource can only work part time. To account for these differences, Microsoft Office Project 2007 uses units (units: The quantity of a resource assigned to a task. The maximum units is the maximum number of units available for the resource. For example, if you have three plumbers, the maximum units is 300 percent or three plumbers working full-time.) to calculate the exact amount of time resources can work on a task............
Details: http://office.microsoft.com/en-us/project/HA102548291033.aspx

Configuring Linked Servers SQL Server 7 and 2000

found this post very helpful
http://www.informit.com/articles/article.aspx?p=21644

Endnote x1 with WORD 2007 slows down Windows Vista x64

found a workaround for this issue
http://www.endnote.com/envista.asp

Walkthrough: Validating User Input in a Web Forms Page

found this article on MSDN very helpful
http://msdn2.microsoft.com/en-us/library/a0z2h4sw(VS.80).aspx
Visual Studio 2005, c#, web form, validator control

translate 'In' operator in SQL to LINQ

Just found out there is no 'In' in LINQ, instead there is an ANY in LINQ:
e.g.
var abc=
from d in mydb.department
where mydb.employee.Any(e => e.ProductID == d.ManagerId)
select d;

OUTKAST - PROTOTYPE

[Intro]
I hope that you're the one
If not, you are the prototype
We'll tiptoe to the sun
And do thangs I know you like

[Hook]
I think I'm in love again [repeat]

[Verse 1]
Today must be my lucky day
Baby, you are the prototype
Do sumn' outta the ordinary
Like catch a manitee
Baby you are the prototype
I think I'm..

[Hook]

[Verse 2]
If we happen to part
Lord knows I don't want that
But hey, we can't be mad at God
We met today for a reason
I think I'm on the right track now

[Hook]

The Scene
Come here

[Hook]

[Outro (ad libs)]
Girl, right now I wanna say, I wanna say
I wanna say stank you very much
For picking me up
And bringing me back to this world
I can't, I'm not
I can't afford to not record
I thank I wanna say
I thank I wanna say stank you, stank you
Smelly much!
For picking me up and bringing me back to this world
Hey, hey John! Are we recording our ad libs?
Really?? Were we recording just then?
Let me hear that, that first one
When I first started

不归路

歌曲：不归路

歌手：迪克牛仔

专辑：忘记我还是忘记他

词∶许常德　曲∶林进璋


我没有退路

尽管你也千辛万苦

不愿认输

是良心让爱坚固

剩下由老天做主

爱你是一条不归路

一度我非常孤独

但是我更怕漂浮

不知道身在何处

有时候绝路也是人生一条路

爱让人全意付出忘记有结束

一心只想你幸福

疏忽了自己痛苦

我没有退路

尽管你也千辛万苦

不愿认输

是良心让爱坚固

剩下由老天做主

有時候错误也是人生一条路

谁不是跌到谷底才有点觉悟

只要你不想退出

我不怕命运残酷

我没有退路

尽管你也千辛万苦

不愿认输

是良心让爱坚固

剩下由老天做主

我没有退路

尽管我也千辛万苦也不愿认输

是良心让爱坚固

老天做主