How To Start / Stop MS SQL Server 2005

I am  not a Php programmer, these days I work with Asp .Net. However I used to work with Php in the past, and that gives me some edge working with simple php stuffs these days for clients, in case I need to.
One of my clients asked to do a visitor counter for them. Looking at the options it could be done in many ways e.g. file based, mySql based etc. To keep it simple I developed a file based version of the visitor counter for the client.
We had to …

Asp .Net pages need a form tag to have the cool Asp .Net controls working. What if you wanna have div with 100% height?

How do you check the version of IIS on the server of a website?

Often times you might need to use a asp .net variable within javascript code. How you do that?

I was working with the Paypal sandbox to test a Paypal application for a client. I was using IPN for the payment notification from PayPal so I could update member record on database. While testing I was getting the payment_status value Pending.

You may have Button, DropDownList etc controls in a Repeater/DataList that generates an Event. From those event handlers how do you find other controls inside the Repeater/DataList, in case you need the values from other controls.

I have a client I was building an e-commerce website for. I was developing the website on MS SQL 2005 Database, but their deployment server have MS SQL 2000. From experience I knew there are some stuffs that would not work in MS SQL 2000, so I avoid them. This one missed my eyes. I get this error message on the search results page:

The text, ntext, and image data types are invalid in this subquery or aggregate expression.

Can we use CASE statement in a where clause? Answer is yes.

I have two css classes like this:
.folderTextON,a.folderTextON:active,a.folderTextON:link,a.folderTextON:visited {color:#fff;font:bold 10px/12px Verdana,Arial;text-decoration: none;}
a.folderTextON:hover         { text-decoration: none; color: #FFFFFF; }
.folderTextOFF,a.folderTextOFF:active,a.folderTextOFF:link,a.folderTextOFF:visited {color:#AD9596;font:bold 10px/12px Verdana,Arial;text-decoration: none;}
a.folderTextOFF:hover         { text-decoration: none; color: #fff; }
I also have LinkButton like this:
<asp:linkbutton id=”linkbtn” CssClass=”folderTextOFF” Runat=”server”>A Link Button</asp:linkbutton>
On code behind I tried to set the css class like this:
linkbtn.CssClass=”folderTextOn“;
This does not not work. On any browser at all. The class code and all others are ok.Whats the problem?
Problem is the CssClass I assigned did not have ON all uppercase as I defined on the style. Modifying that this works:
linkbtn.CssClass=”folderTextON“;
Apparently on code …