the type or namespace name ‘webmethod’ could not be found
[ September 18th, 2009 | 479 views ]
Leave comment
Posted in: Programming / Coding
If you are adding Page Method on your ASP .Net page and you see this compile error: the type or namespace name 'webmethod' could not be found....
Truncate MS SQL 2008 Database Log File
[ September 16th, 2009 | 630 views ]
Posted in: Programming / Coding
So you need to truncate the log files often to keep the log file smaller in size. The process I am demonstrating here is for MS SQL 2008.
How To Start / Stop MS SQL Server 2005
[ September 15th, 2009 | 424 views ]
Posted in: Programming / Coding
How To Start / Stop MS SQL Server 2005
100% Height Div On Asp .Net Page
[ August 7th, 2009 | 1,394 views ]
Posted in: Programming / Coding
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 to Check IIS Version on Website?
[ July 23rd, 2009 | 756 views ]
Posted in: Programming / Coding
How do you check the version of IIS on the server of a website?
ASP .Net Code Within JavaScript
[ July 17th, 2009 | 603 views ]
Posted in: Programming / Coding
Simple thing really, often times you might need to use a asp .net variable within javascript code. How you do that?
Declare the variable as protected(public will do as well)
Set the code on JavaScript to use the Asp .net Variable within JavaScript
Example:
Declare the variable as protected like this.
protected string myVar;
On your
payment_status value in Paypal Sandbox always pending
[ July 5th, 2009 | 750 views ]
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.
Finding Controls in Repeater/DataList From The Event Handler
[ June 20th, 2009 | 728 views ]
Posted in: General
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.
The text, ntext, and image data types are invalid in this subquery or aggregate expression
[ June 19th, 2009 | 912 views ]
Posted in: General
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.




My name is Manik. I am a web developer & entrepreneur. Working with Microsoft ASP .Net, MS SQL, C# mainly. I have a full-time job managing a large e-commerce site. I also work freelance developing websites mainly the backend coding and database stuffs. My entrepreneur life started with webcosmo.com, a free classified ads site, followed by webcosmoForums.com and few other sites...