Server Error:Operator '<>' is not defined for type 'DBNull' and type 'Integer'.

Some time I see the Server Error message in our SilverNet web based inventory system
I've investigated this problem and found that in the row:

<asp:Label ID="Label3" runat="server" Text='<%# Eval("Paid", "{0:N}") %>' Visible='<%# Eval("Paid")<>0 %>' ></asp:Label>
The field "Paid" can be DbNull.
First, I tried to check the value Paid before using it in the Eval function. But then,I've found very simple solution. I've edited SQL query in the data source. I've changed the "Select Paid ..." on "Select IsNull(Paid,0) As Paid...."
DbNull is an insidious thing!

How to create clothing set ?

We will use Victoria's Clothes Organizer for creation clothing sets. First, we should to take pictures of all our warderobe and then we are ready to create our sets.
Select the empty row in the Clothing sets table. Double click on the field "Clothing sets description" and type a name of your new set. For example "Set for restaurant". Then select a destination from the drop down list. You can enter a new destination if don't find it in the destination list. Select or enter the weather and temperature for this set. You should define all clothes for this set in the table "Clothes for set". You can select items from the drop down list or enter a new dress using the right small button "Edit and Add clothes". Select the option at the pop up for Add or Edit. Enter a description and load a photo from an image file. You can enter any category and any location for this item. If you want remove an item from the set you can use the left small button "Remove item". Click on the button "All clothes" and you'll see the list of all your clothes. You can edit,add and delete clothes and use filters by category and by location. You see when and how many times you dressed each item. Click on the button "Select" and add an item to the current clothing set. You can save when you dressed this set. Use the special table "When dressed" . Select an empty row and select a date from the calendar.

Claimed on Technorati

QVBDM9WHW6ZU
It's a post for verify my blog by Technorati

Create your own outfit

You can use our Victoria's Clothes Organizer and easy create your own outfit using the clothing sets It has the list of clothing sets, the filter panel, the tables "When dressed" and "Clothes for set", the image of a clothing set, the buttons New Set and Delete Set. Double click on any row for editing. Select the option "---All----" if you want to see all records. Select an appropriate destination, weather and temperature if you want to see limited amount of clothing sets. This function will help you to select an appropriate set of clothes and accessories and create a today's own outfit.

Localization of Victoria's Clothes Organizer

I've noticed that girls from France often use our softwareVictoria's Clothes Organizer. But I do not know French at all. I've add the special new function "Settings" to the menu File.Now, women can change English captions on captions in their native languages.They can change any program's name for example, Destination on Style or another. I've used google translate and got What should I wear?= Que dois-je porter?. Is it true?