On Windows XP, after installing Apache HTTP Server 2.2.4, PHP 5.2.2, and MySQL Community Edition 5.0.37, I downloaded Zen Cart – an open-source PHP e-commerce web application as my friend is asking whether I can develop one for her. I encountered a database not supported error when installing it. After searching through Internet, eventually I [...]

[Read more →]

If you received “Cannot remove device driver” or “Cannot remove files” or similar errors when uninstalling Sony Ericsson PC Suite which came together with your cellular phone (my version is 1.30.8), it’s probably due to the fact that you installed PC Suite in location other than C:\Program Files\Sony Ericsson\Mobile2. The error message will keep on [...]

[Read more →]

If you experienced Outlook not responding issue (e.g. showing white screen when startup), and you have Symantec Winfax application installed, try the following steps: Go to Control Panel -> Mail -> Data Files… -> Remove Winfax entry Then, kill Outlook and restart it. It should be working fine by now.

[Read more →]

After letting ASP.Net Web Administration configured my web.config. I received “sys is undefined” error on the page whenever there is AJAX control on the page. There is nothing wrong with the code. All you need to do is to ensure the following statements exist in web.config: <location path=”ScriptResource.axd”> <system.web> <authorization> <allow users=”*”/> </authorization> </system.web> </location> [...]

[Read more →]

Create an asp:button namely “button1″. On codebehind page, add the following: private void Page_Load(object sender, System.EventArgs e) { button1.Attributes.Add(“onclick”, “jsFunc()”); } in which “jsFunc” is the JavaScript function you define in aspx page. With this, whenever button1 is clicked, “jsFunc” is called at client side.

[Read more →]

Reference: http://forums.asp.net/1072828/ShowPost.aspx Because DataList is databound control which repeats its item template as many times as there are rows in the data source to it. Therefore contents of template are wrapped into DataList’s Items (one DataList item per row in data source) which is a naming container to its contents (to keep control ID naming [...]

[Read more →]

Normally we use to Eval method to print out value retrieved from database to HTML. For example: asp:Label id=”lblDate” runat=”server” value=’<%# Eval(myDr["DateAdded"]) >’ Assuming “DateAdded” is a date/time field in database, the above statement returns a date/time value from database. Now, if you would like to show only date portion of it. You should define [...]

[Read more →]

In case you still didn’t aware, there is no FOR loop in Transact-SQL (T-SQL). Anyway, you can replace it with WHILE loop, such as: DECLARE @i int WHILE(@i < 5) BEGIN – do whatever you want here – SET @i = @i + 1 END Remember to increment/decrement the counter. Else, you will ended up [...]

[Read more →]

Cookie with subkeys looks like this: HttpCookie myCookie = new HttpCookie(“MainCookie”); myCookie.Values.Add(“Email”, myDr["Email"].ToString()); myCookie.Values.Add(“User_Id”, myDr["Id"].ToString()); myCookie.Values.Add(“First_Name”, myDr["firstname"].ToString()); myCookie.Values.Add(“Last_Name”, myDr["lastname"].ToString()); myCookie.Expires = DateTime.Now.AddYears(1); Response.Cookies.Add(myCookie);

[Read more →]

I am doing ASP.Net programming (using C#) these few days and I am thinking of a way to display interactive contents without post back the page. For example, there are two DropDownList, cboCategory and cboProduct respectively. If user clicked on cboCategory, all related products under the selected category will be displayed in cboProduct. In normal [...]

[Read more →]