SQL Server Date Time Format

Most of the developers expect that sql server date time format will behave like VB or .net but the reality is different. The only way to translate a DateTime into a specific format is to convert it to a VARCHAR or other "string" data type. This means that it is no longer a DateTime. It is a VARCHAR. For front end presentation it will be required to format the DateTime whatever circumstances.

Sending Web Email in ASP.NET C#

E-mail is one of the most common popular methods of communication for both personal and business purposes. It also plays an important role in each and every Web site specially for registration page or sales order page of an e-commerce site & also for online invoicing. The .NET framework makes the task of sending email from a Web page unbelievably easy and I'll show you how to do it in a matter of

Cross-browser javascript to disable browser's back button

This is the most common problem for a developer to prevent the user to press the browser back button. One easy solution is you can open a new window which has a disabled back button. Another solution is you can remove the toolbar using javascript.But most of the cases i think you cant apply above techniques. Thats why i want to share my experience that how we can resolve this problem. One thing

How to use ASP.NET AdRotator Control

In recent days rising of of eCommerce, affiliation program, internet marketing, site hosting , pay per click , freelance advertising banners have played a lucrative role of primary or additional income source for many web sites. So in one senetence we can say that the AdRotator control of ASP.Net is used to display a sequence of ad images which is one of the built in ASP.Net server control. If

Best friend

Best friend...Saya masih bingung mendeskripisikan makna ini..Apakah sahabat yang mulai dari kecil hingga kini juga masih tetap menyandang "best"Apakah diantara beribu-ribu teman itu, hanya boleh satu saja yang dianggap sahabat terbaik..Ataukah yang mana ??Bagi saya yang tidak termasuk kategori memiliki ribuan teman ini (bahkan dalam jejaring maya juga), mungkin hanya segelintir orang yang saya

the Conclusion....

Funny how I am perceived like a duck. This season is being crazy busy, no time for the blog. But apparently, I don’t convey it too much when people see me. Curious!So lots of job, a business to be launched, and plenty personal stuff going on.Andai saya bilang waktu terasa cepat, apakah ini artinya saya sangat menikmatinya ??Semoga..I love this situation, i love this ambition, i love this little

How to Encrypt Passwords using MD5 in ASP.NET(C#) application

Encryption for sensitive data like password is essential in everyday development. MD5 hashing algorithm is one of the most commonly used algorithms in asp.net arena and is one of the best. There are two general classes of encryption: one-way encryption and two-way encryption. Using two-way encryption you can encrypt a text as well as you can decrypt it. But for one-way encryption the difference

Passing data/parameters/values from one aspx page to another aspx page

Passing parameters from one page to another page is a very common task in Web development. Specially when you develop a project & redirects or navigates from one ASP.NET Web page to another, you will frequently want to pass information from the source page to the target page . In this post, I will show you some ways of transferring data/parameters/values between one page to another page which is

Cross-browser javascript & asp.net(C#) email address validation

Email address validation is a most common scenario for a developer. It will be the best if we can use javascript validation along with server side validation since user may off javascript from browser settings. The following example shows how you can validate an email address for a form. The script is cross browser compatible (works for all browsers such as IE, Firefox, Opera).Javascript email

How to format GridView Rows/Columns in Design/Run time

Here i will discuss how you can format data in GridView rows. Most of the time we require to render our GridView control by custom formatting since data source format does not contain our exact required formats. Like, you want to display numeric values in two decimal format or want to display short date instead of considering time portion from databse. In this post i will try to resolve below

How to configure SQL Server 2005 to allow remote connections

When you try to connect to an instance of Sql Server 2005 from your application or froma remote computer most of the times you may get an error message. Because by default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. If you try to connect to remote SQL Server without enable remote connection first, you’ll see one of these error messages:Sql server does not