Archive for the ‘SiteMania’ category


Ninja Lite Database for free – coupon code

 

Ninja-Database-Lite

Ninja Database Lite is a light and nimble database for Windows Phone 7, Silverlight 3, Silverlight 4, .NET 3.5, and .NET 4.x

you can download the full feature list here.

You can get Ninja Database Lite Single Developer License for free until midnight October 31st, 2010; a $49.99 value.

Use coupon code :  twitterninja

Steps :

  1. Go to http://www.kellermansoftware.com/c-9-windows-phone-7.aspx
  2. Select Add To Cart for  Ninja-Database-Lite -Single Developer License2010-10-30_1515 
  3. Enter Coupon code twitterninja in coupon code and click Checkout Now2010-10-30_1517
  4. Go register and checkout
  5. Complete the registration form.
  6. Click Create account and checkout.
  7. It will not ask you for making payment or credit card information since your effective amount to be paid is zero.
  8. Done…

Spread the word and enjoy.


Excel do not allow number more than 15 digits

images

Excel is excellent. No doubt about that. But excellence does not mean that, it will not have glitches. So Excel also have few !!!

Recently, We wrote a small data migration utility for our clients which reads data from Word file and store it in excel. The entries included Credit Card numbers which has 16 digits.

In all surprises, Excel was doing magic. When you enter a number greater than 15 digits, Excel rounds it off and you get zeros padding the end of your number.

Example :

Enter the number

234587654567123456 in Excel

and you get this

234587654567123000

 

answer          Solution:

Excel supports 15 digits of precision in its cells. Credit card numbers are usually 16 digits.For identifying numbers, you should enter them as text. To enter a number as text, precede the entry with an dash (-) or format the cell as Text (Format>Cells>Number) before you enter the number.

Note : Tested and replicated in Excel 2007, Excel 2010


Access is denied. (Exception from HRESULT: 0x80070005(E_ACCESSDENIED)) – Parallels PLESK 9.3 – Solved

Godaddy Virtual Dedicated machine, Windows server 2008, PLESK 9.3, New Web application setup and I was greeted with below YSOD.

 

2010-10-27_1403

Problem :

As the error message said, Access is denied. It means that the user account under which asp.net is running is trying to access resource without having sufficient permissions on that resource.

Solution :

1. Login to your Virtual Machine using Remote Desktop ( mstsc )

2. Go to “C:\plesk\etc\DiskSecurity” folder

3. Edit disksecurity.xml file. Add following entry at the end ( before </Entries> )

<Entry AccounType="1" Account="Psacln" Path="C:\Windows\assembly" AceFlags="FilesOnly" AccessMask="Read" EntryFlags="0x0" />

4. Save.

And you are done… Enjoy…


GMail – Run Out of Space

2010-10-26_1606 GMail is arguably the most effective email solution existing today on the planet. They are damn good and rolling interesting features every day. But what makes them unique is the core line

“Among crowded features they always remember, people use Gmail for email services and they always make it priority when designing new features.”

I use Gmail as my document repository, my chat history ( gTalk is awesome, when it comes to chat ), my scheduler and oxygen ( Yes, No doubt, I can not live without it until I will find better oxygen).

I have started using Gmail from 2005 and now its friendship of more than 5 years, and truly, Gmail is a great friend. It gives you ample space to use as mail repository in free edition, but free is not always enough when you are using it like oxygen. Currently they are giving away more than 8 Gigs of space for free usage which includes GMail, Picasa, Google Docs and other Google services  you use which requires storage.

Recently my Gmail started to show me warning that I am almost out of space ( 95% usage )

AlmostOutOfSpace

I deleted few emails permanently from my Life ( it is bad ) but in  just two more days ( in that period my clients used to send me video attachment of 15 MB ), I got this message from gMail

RunoutGMAil

and as they have indicated in the warning, I was not able to send or RECEIVE emails, so I have decided to purchase additional storage rather than deleting few more emails. So I went through the process of purchasing additional email storage.

The Process :

1. Click on purchase additional storage

2. You will be given choice of plans available and their prices.

20 Gigs additional storage for 5 USD per year is not bad deal at all  ( It means now you will have 20 Gigs new purchased storage + the more than 7 Gigs of Basic storage that comes for free with every account = more than 27 Gigs of storage )

2010-10-26_1600

3. Click on Buy 20 Gb for $5.00 per year.

4. Proceed through Google  CheckOut

5. Done… But it will take 24 hours to get that space added to your account.

Now enjoy GMail.


Google Search – How to , I am shocked

 

I don’t know where we are going.

Recently I tried to Google about some PLESK problem.  Google has a nice little feature to suggest you some of the common phrases other people searched, matching your search query know as Google Suggest.

I just typed in How to in search box and as usual Google presented me with list of common search phrases people are searching, and I GOT SHOCKED.

Result of How To – ( 6-Aug-2010 )

image

 

Now lets go in a bit detail :

1) World’s biggest two problems today are, IMHO, population and corruption. AND Google shows me that majority of people wants to know “How to get pregnant”

.2) World is now so health conscious that 3 of the top search results are about reducing and gaining weight.

More analysis later.

 

 

This is today’s results ( 7-Aug-2010 ).

image


Asp.Net Set Medium trust in local

My almost all  web sites are hosted on goDaddy shared medium trust hosting.It is always painful to get things running on medium trust environment after got it running on your development environment.

But now you can set medium trust environment on your local machine and check every functionality there only.

You need to add following configuration in your web.config

<system.web>
    <trust level="Medium" />
</system.web>
Now you can test your application as if it is running under Medium Trust environment.
 

IE Shortcuts

I spend almost half of my time working on browsers. So it is always important for me to make sure I can operate it as fast as possible. The best way to do any activity faster on computer is simply use Keyboard as much as possible.

So here I am listing few of the shortcuts I use most while operating in IE.

IE and Google Toolbar shortcuts :

Some of which I use most are

If you have installed Google toolbar and want to reach its Search box, you can use shortcut below.

For more detailed entry of shortcuts you can visit

http://www.onecomputerguy.com/ie_tips.htm#keyboard_shortcuts

I have checked all above shortcuts with IE8 and IE 7 compatibility mode. All of them work very fine.

 

Thanks,

Mahin Gupta


BugTracker.Net : Add attachment gives you invlaid id

Hi, We are using BugTracker.net to Track Bugs ;)

It has fairly almost all features one need to track issues related to development and above all its free. Highly recommended after using it for almost 1 year.

We were facing a strange bug in it from quite a few time.

Whenever we try to add attachment to issue, it always failed with message “invalid id”.

After a bit of Google, we found following solution here :

In add_attachment.aspx. file remove attribute action=add_attachment.aspx from the form tag.

ie

Change :

<form class=frm runat="server" enctype="multipart/form-data" action=add_attachment.aspx  >

To :

<form class=frm runat="server" enctype="multipart/form-data" >

 

Happy Bug Tracking :)


C# : Difference between Hashtable and Dictionary


 

When we want a collection  data structure to hold data as key/value pairs, we have two obvious choices.

1. Dictionary

2. Hashtable

So basically what is the difference between both this and when to use which. Lets check it out. Point by Point.

1) Generics

Dictionary is a generic type, Hashtable is not. Now what that means. This is the most important aspect one should consider when taking decision. Dictionary is a generic type means

- You get type safety with Dictionary, because you can’t insert any random object into it, and you don’t have to cast the values you take out.

- And also generic collections are a lot faster as there’s no boxing/unboxing

- Hashtable uses Object to hold things internally (Only non-generic way to do it). So you have to take care of type safety and cast it to appropriate data type when you take it out, but it also means that you can add keys and values of any type ( It is good or bad, well it depends :) )

- Again Hashtable also have to box/unbox, which may have memory consumption as well as performance penalties.

2) Thread Safety :

In .Net Hashtable is thread safe for use by multiple reader threads and a single writing thread, while in Dictionary public static members are thread safe, but any instance members are not guaranteed to be thread safe.

One more thing that can make difference is,  we can not use dictionary (generics) with web services. The reason is no web service standard supports generics standard.

Technorati Tags: ,,,,,,,,

Windows Live Tags: C#,Hashtable,Dictionary,collection,Generics,instance,services,supports,collections

WordPress Tags: C#,Hashtable,Dictionary,collection,Generics,instance,services,supports,collections

Follow me on Twitter |


svn : Can not Parse lock / entries hashfile


Recently we moved our svn repositories from one URL to other. I don’t remember exactly what happened, but we started to get error

“svn : Can not Parse lock / entries hashfile “

whenever we try to take lock or release any lock from on any file in that repository. I have tried a hell lot to solve this problem, but I was not able to solve it in a clean manner.

So I have decided to take reset all the locks and asked on StackOverflow to help me. I received answer from Ben Blank and I followed his advise. I have manually release all locks from repository by Deleting <root>/db/locks folder. And all the locks were reset again.

Caution : Make sure you take backup of your repositories before doing such things.

Technorati Tags: