Developer's Cookbook

How to remove Telerik RadGrid selected Row Style

2012-01-23T10:22:00.001+01:00

If you need to remove the selected row style applied to the rbSelectedRow element, here is the Css code:

/* override selected row*/

.RadGrid_Office2010Silver .rgRow td
{
border-color:#FFFFFF #FFFFFF #FFFFFF #FFFFFF !important;
}
 
.RadGrid_Office2010Silver .rgAltRow
{
background:none repeat scroll 0 0 #eee !important;
}
 
.RadGrid_Office2010Silver .rgAltRow td
{
border-color:#F1E9DC #F1E9DC #F1E9DC red !important;
}
 
.RadGrid_Office2010Silver .rgRow
{
background: inherit !important;
}
 
.RadGrid_Office2010Silver .rgRow td, .RadGrid_Office2010Silver .rgAltRow td
{
border-left: solid 1px #ddd!important;
padding-left: 7px !important;
}
 
/* finally, need to put this one back in */
 
.RadGrid_Office2010Silver .rgHeader:first-child, .RadGrid_Office2010Silver th.rgResizeCol:first-child, .RadGrid_Office2010Silver .rgFilterRow > td:first-child, .RadGrid_Office2010Silver .rgRow > td:first-child, .RadGrid_Office2010Silver .rgAltRow > td:first-child
{
border-left: 0 none !important;
padding-left: 8px !important;
}

.RadGrid_Office2010Silver .rgSelectedRow > td 
{
    background:inherit!important;
}

Hope it helps!

Multiple CSS class selection

2011-12-13T14:13:00.001+01:00

If you have two or more classes inside your HTML element you can select it using :

CSS:

.classA.classB
{
border:1px;
}

JQuery;

$(‘.classA.classB’).css(‘border’,’1px’);

Lego universe is dead

2011-11-08T07:00:00.000+01:00

Here is the mai sent by Lego to all the customers and beta testers:

Hello Adventurer, today we are very sad to announce that LEGO® Universe will be closing on January 31, 2012. This was a very difficult decision to make, but unfortunately LEGO Universe has not been able to attract the number of members needed to keep the game open.

It's a bad news, the game failed to create the critical mass necessary to survive in a scene where other big players are dominating, see WOW for example.

I hope that the Lego team will step back on its decision...

How to disable on your site the Skype "click to call"

2011-11-02T01:00:00.000+01:00

Skype changes the layout of your web site modifying the phone numbers and adding his style on them, here is an example from the skype web site:

If you need to disable this feature for ALL your web visitors add this code in the META section to your web pages:

.. And the web site will start to render as usual...

iMac : howto edit the hosts file

2011-10-07T01:12:00.001+02:00

Here is a simple way to edit the hosts file:

open the application\utility\terminal
write the command:

sudo nano /etc/hosts
Insert your password

That's all!

How to make as READ all GMAIL unread messages

2011-09-21T12:20:00.001+02:00

You have THOUSOUND of unread emails…. and all of them are ads or mail that you will never read.

Here is in 4 steps how you can make ALL AS READ

Open Gmail and

- in the search box write “is:unread”, click “Search Mail”

- Click on the “Select All” checkbox

- Click on the “Select all conversations that match this search” link

- Click the “Mark as Read” button :

or click on “More” - “Mark as Read”

Hope it helps!!

Automatic login on DNN using URL parametrs… the dirty way

2011-09-19T22:42:00.000+02:00

Imagine this scenario…. your user needs to access a secured web page on a DNN site using a single click on a link….

Ok , it’s unsecure but your customer needs it… here is the quick and dirty solution:

1) Call the page sending the user/password information using the query string
2) Read the parameters and execute the login using jQuery
3) Redirect to the correct page after the login using the UrlReferrer information

You need to follow 3 steps:

1) Add this script in your login page.. better approach is to add it to a common javascript library:


function getQueryString(name)
{
name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regexS = "[\\?&]"+name+"=([^&#]*)";
var regex = new RegExp( regexS );
var results = regex.exec( window.location.href );
if( results == null )
return "";
else
return results[1];
}

function autologin()
{
$('input[id*=DNN_cmdLogin]').click();
}


//on the ready event we load the parameters from query string and send the info back to dnn
$(document).ready(function(){
if (getQueryString("AUTOLOGIN") != "") {
$('input[id*=DNN_txtUsername]').val(getQueryString("USER"));
$('input[id*=DNN_txtPassword]').val(getQueryString("PWD"));
var timerid = setTimeout(autologin, 1000);
}
});

I’ve added a timer to the login process because in some case the asp.net page is not ready yet.

2) Add this code to the page called after authentication:

If Request.UrlReferrer <> Nothing Then
Dim arParams As String() = Request.UrlReferrer.Query.split("&")


If (Request.UrlReferrer.Query.indexOf("AUTOLOGIN") <> -1) Then
For Each Item As String In arParams
If (Item.indexOf("returnurl") <> -1) Then
Dim sFinalRedir As String = Item.split("=")(1)
Response.Redirect(sFinalRedir)
Return
End If
Next
End If
End If

3) Modify the default.aspx.vb file, and add this code to manage the already logged case:

If Request.IsAuthenticated = True Then
If Request.Querystring("AUTOLOGIN") <> "" Then
Response.Redirect(Request.Querystring("returnurl"))
Return
End If
End if

That’s all… hope this helps..

Google +1 button concerns about misleading use and security

2011-09-16T12:15:00.008+02:00

The Google+ +1 button allows to link an external web site, different from the web page you are browsing.

Developers can configure the "href" parameter inside the "<g:plusone>" element and when user click on the +1 button the preference will be assigned to the external web site.

The +1 button does not show any alert or warning that the preference has been assigned to an external web site, so you can see a +1 button like this:

I like Apples :-) ..or Microsoft?

<g:plusone href="www.microsoft.com"></g:plusone>

You like it, you click it but.... the vote goes to Microsoft, not to Apple.
Bad guys can use this trick to show +1 button near normal images and to give the vote to XXX web sites or similar.
Here is an example

Warning! If you click +1 your vote will be assigned to youporn web site!
I like Bycles ... or youporn?

Does it seems correct?

One solution should be to show in the popup information a warning that the +1 will be assigned to an external web site, not to the page you are viewing.

Lesson learned : people prefers youporn instead of microsoft ... 1400 likes VS 381.
Note: if you see lower numbers please open this post alone clicking on the title

Don't forget to vote this article, this +1 is genuine and links to this blog!!!
I like this article!!

19/09/2011 Additional notes:

Here is how browser sows details about the +1 button:
Chrome 15.0.874.15 dev-m:

Firefox 5.0:

And here is the actual code generated by the button, note the href parameter:

<iframe allowtransparency="true" frameborder="0" hspace="0" id="I1_1316419994232" marginheight="0" marginwidth="0" name="I1_1316419994232" scrolling="no" src="https://plusone.google.com/u/0/_/+1/fastbutton?url=http%3A%2F%2Fwww.microsoft.com%2F&amp;size=standard&amp;count=true&amp;annotation=&amp;hl=en-US&amp;jsh=r%3Bgc%2F23803279-4555db52#id=I1_1316419994232&amp;parent=http%3A%2F%2Fdevcoma.blogspot.com&amp;rpctoken=485083169&amp;_methods=onPlusOne%2C_ready%2C_close%2C_open%2C_resizeMe"></iframe>

Google+ +1Button examples

2011-09-16T10:00:00.001+02:00

You can add the 1+ button to your pages in various ways, here are 4 live examples, the latest with javascript integration:
Adding the 1+ button like this

is really simple, just add this line of code :

<script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>
<g:plusone></g:plusone>

Another useful option is to include the button using asynchronous rendering:

<script type="text/javascript">
  (function() {
    var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
    po.src = 'https://apis.google.com/js/plusone.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
  })();
</script>

Another option to add a +1 button that reference another web site, here is an example, referencing google+ api’s page:
Google APIs!

And the code used:

<g:plusone size="tall" annotation="Google+ api page rocks!" expandto="top" href="http://developers.google.com/+/api/"></g:plusone>

You cal also call a function after the user's click, you can alert a message to the user or access a special page when the user appreciates your page:

<g:plusone annotation="Code recipes rocks!" size="tall"  callback="doSomethingAfterClick"></g:plusone>

And the javascript code:

<g:plusone annotation="Code recipes rocks!" callback="doSomethingAfterClick" size="tall">;/g:plusone>

<script>

function doSomethingAfterClick(jsonParam)
{
    if (jsonParam.state=='on')
        alert("Thank you dear!");
    else 
        alert("Oh no!!! I'm really sad!");
}

</script>

Hope it helps!

How to configure short url having a DNN page with the same name

2011-08-24T15:04:00.001+02:00

Here is a DNN problem: you have created a page inside DNN with the name Download.

The page appears in the menu, and you can’t change it’s name and people reaches it using the url:

www.yoursite.com/download/tabid/198/Default.aspx

After some days your boss asks you: “it should be beautiful to reach the page using the url: www.yoursite.com/download”

One solution is to create a virtual dir on IIS named “Download”, and to configure on this page a redirect to the DNN page, like this:

Note that you can’t use “the exact url entered above” because it creates an unconditional redirect to the url entered, and if you try to edit the page all the redirects to the DNN editing mode will be transformed in the “the exact url entered above” page with no editing capabilities.

That’s all… it works!

Processing.js is emerging….

2011-06-29T20:00:00.000+02:00

Processing.js is the porting of processing language on the HTML5 world.

You can use it in two ways: using the original processing code, a dialect of the java language translated on the fly by the processing JavaScript code or using the processing.api.js file, writing only JavaScript.

The Processing language was born based on a great idea: enable programmers with only one line of code to see something on the video.

Processing language is like a Lego game, you have bricks and you can create great works using only a few of them.

Here is a great site using processing: http://numberpicture.com/picture/search

And here is the official processing site: http://processingjs.org/

Note that the header in the web site is “interactive” !

JavaScript Trim on Internet Explorer…

2011-06-28T17:26:00.001+02:00

If you are writing scripts for firefox, chrome, safari and ie and you are using the trim function… don’t forget that IE does’n support it!

In order to enable it you need to add the script:

if (typeof String.prototype.trim !== 'function') {
     String.prototype.trim = function() {
         return this.replace(/^\s+|\s+$/g, '');
     }
 }

That’s all!

How to geolocalize “on the fly” multiple text addresses

2011-06-22T19:00:00.000+02:00

If you have a list of addresses and you need to geolocalize them you can use this service:

http://www.gpsvisualizer.com/geocoder/

Simply copy in the first text input your list, one address per line, and then click on geocoding:

Every address will be associated to his latitude and longidute using yahoo geo api.

Hope it helps!

Nations of the world in javascript array

2011-06-22T13:38:00.001+02:00

If you need a list on continents and nations in javascript format here is the code:

var continents =
[
["Africa","Algeria,Angola,Benin,Botswana,Burkina,Burundi,Cameroon,Cape Verde,Central African Republic,Chad,Comoros,Congo,Congo, Democratic Republic of,Djibouti,Egypt,Equatorial Guinea,Eritrea,Ethiopia,Gabon,Gambia,Ghana,Guinea,Guinea-Bissau,Ivory Coast,Kenya,Lesotho,Liberia,Libya,Madagascar,Malawi,Mali,Mauritania,Mauritius,Morocco,Mozambique,Namibia,Niger,Nigeria,Rwanda,Sao Tome and Principe,Senegal,Seychelles,Sierra Leone,Somalia,South Africa,Sudan,Swaziland,Tanzania,Togo,Tunisia,Uganda,Zambia,Zimbabwe"],
["Asia","Bangladesh,Bhutan,Brunei,Burma (Myanmar),Cambodia,China,East Timor,India,Indonesia,Japan,Kazakstan,Korea,North,Korea, South,Laos,Malaysia,Maldives,Mongolia,Nepal,Philippines,Russian Federation,Singapore,Sri Lanka,Thailand,Vietnam"],
["Europe","Albania,Andorra,Armenia,Austria,Azerbaijan,Belarus,Belgium,Bosnia and Herzegovina,Bulgaria,Croatia,Cyprus,Czech Republic,Denmark,Estonia,Finland,France,Georgia,Germany,Greece,Hungary,Iceland,Ireland,Italy,Latvia,Liechtenstein,Lithuania,Luxembourg,Macedonia,Malta,Moldova,Monaco,Montenegro,Netherlands,Norway,Poland,Portugal,Romania,San Marino,Serbia,Slovakia,Slovenia,Spain,Sweden,Switzerland,Ukraine,United Kingdom,Vatican City"],
["North America","Antigua and Barbuda,Bahamas,Barbados,Belize,Canada,Costa Rica,Cuba,Dominica,Dominican Republic,El Salvador,Grenada,Guatemala,Haiti,Honduras,Jamaica,Mexico,Nicaragua,Panama,Saint Kitts and Nevis,Saint Lucia,Saint Vincent and the Grenadines,Trinidad and Tobago,United States"],
["Oceania","Australia,Fiji,Kiribati,Marshall Islands,Micronesia,Nauru,New Zealand,Palau,Papua New Guinea,Samoa,Solomon Islands,Tonga,Tuvalu,Vanuatu"],
["South America","Argentina,Bolivia,Brazil,Chile,Colombia,Ecuador,Guyana,Paraguay,Peru,Suriname,Uruguay,Venezuela"],
["Middle East","Afghanistan,Bahrain,Iran,Iraq,Israel,Jordan,Kuwait,Kyrgyzstan,Lebanon,Oman,Pakistan,Qatar,Saudi Arabia,Syria,Tajikistan,Turkey,Turkmenistan,United Arab Emirates,Uzbekistan,Yemen"]
];

This is useful if you need to find using google geolocation the continent of a nation.

Here is the firebug console:

hope it helps!

How to generate KML file from excel data (or csv!)

2011-06-22T12:41:00.001+02:00

The marketing department gives you an excel file and says : “it would be nice to have this data available on gGogle Earth (and also on Google Maps! ”…. can you do this today?

Instead of running out of the room with your hands in your hair simply download the excel file located at http://processtrends.com/Files/MapExcelData.zip

Follow the instructions and in 10 minutes you will have the data geolocated and a beautiful kml file.

This is the excel file:

The generated KML file:

And the kml file in viewed in Google Earth:

Many thanks to http://processtrends.com and to simon_a !

SQL server BCP in a nutshell

2011-05-20T14:37:00.001+02:00

BCP is a sql server utility used for importing and exporting huge quantity of data from a sql server table

You can use BCP without installing sql server, just install Microsoft SQL Server 2008 Command Line Utilities at:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4

You can Export data from command line:

bcp mydbname.dbo.largetable out c:\yourtable.csv /U sa /P mypassw /S servername /c

And Import data:

bcp mydbname.dbo.largetable in c:\yourtable.csv /U sa /P mypassw /S servername /c

For a table with 60 fields the rate import is 10000 records/sec… but this is only a test value depending on the hardware.

You can also export queries using bcp (from msdn):

bcp "SELECT FirstName, LastName FROM AdventureWorks2008R2.Person.Person ORDER BY LastName, Firstname" queryout Contacts.txt -c –T

Javascript HTML encoding/decoding utility

2011-05-18T08:41:00.001+02:00

Today I found a great script for encoding and decoding HTML on the browser:

http://www.strictly-software.com/htmlencode

The library is located under http://www.strictly-software.com/scripts/downloads/encoder.js

The usage is really easy:

Encoder.EncodeType = "entity";

var encoded = Encoder.htmlEncode(document.getElementById('input'))

var decoded = Encoder.htmlDecode(encoded);

That’s all!

Sql server: cannot resolve collation conflict for equal to operation.

2011-05-10T09:37:00.001+02:00

Sometimes you may encounter a “collation problem” when you compare two colums from different table or database.

As MSDN says “Collations let users sort and compare strings according to their own conventions”, but they can be a really pain for developers.

The simplest way for comparing two columns with different collation without hard writing specific collation codes is to convert the two columns to the database default collation.

If this sql script gives you the error “cannot resolve collation conflict for equal to operation”

select * from people,city 
where people.citycode = city.citycode

You can transform the select adding collation instructions:

select * from people,city 
where people.citycode COLLATE DATABASE_DEFAULT  = city.citycode COLLATE DATABASE_DEFAULT

Hope it helps!

Sharp Snippet Compiler: there’s a new interactive .net compiler in town

2011-05-09T09:26:00.001+02:00

If you need to test one C# instruction and you don’t want to wait 3 minutes for the Visual Studio 2010 startup, here is the solution, use Sharp Snippet Compiler, write the code, add breakpoints , hit F5 and see the results:

Here are the functions available:

variables watch window
stepping through the code
assembly references
light and fast
syntax highlighting
IntelliSense code-completion
supports .NET 3.5 features

This tool replaces the old “Snipper Compiler”, last updated in 2007 :

Resolve double escape sequence error on IIS 7

2011-03-10T10:13:00.001+01:00

Some images on your site fails to load with the error:

HTTP 404.11 - Not Found. The request filtering module is configured to deny a request that contains a double escape sequence

Here is the fix:

Edit applicationHost.config (notepad %windir%\System32\inetsrv\config\applicationHost.config)

Find:

and change to:

And the images will be loaded again!

Solved: “The username you entered could not be found” when connecting to network share on windows O.S.

2010-11-15T09:54:00.001+01:00

If you try to connect to a network share you may receive the error:

“\\name of computer is not accessible. You might not have permission
to use the network resource. Contact the administrator of the server
to find out if you have access permissions”

And the message: “The username you entered could not be found.”

You also have the rights to access the share, no firewall problems, and your user is not locked out or expired.

The solution is to open the command prompt and type:

Control keymgr.dll

windows vista:

windows 7:

Find the address of the server and delete it from the cached credentials, try to reconnect and .. it should works.

JQuery: HOWTO Add Validator To Your Forms

2010-11-11T15:31:00.001+01:00

Here is a simple way to add Input validation to your ASP.NET code using the JQuery Validator plugin.

1) Add a reference to the validator javascript library

<script src="scripts/jquery.validate.min.js" type="text/javascript"></script>

2) Add Css class to your input, example:

<asp:TextBox ID="txtFirstname" runat="server" Text='<%# Bind( "Firstname" ) %>' CssClass="required"></asp:TextBox>

or for a required email:

<asp:TextBox ID="txtEmail" runat="server" Text='<%# Bind( "Email" ) %>' CssClass="required email"></asp:TextBox>

3) Call the “validate” method:

$(document).ready(function() {
$("#aspnetForm").validate();
}

4) If you have custom regular expressions loaded from server you need to:

Add on the server side an attribute to the the text elements with the regular expression:

txtEmail.Attributes.Add("regexp", "your regular expression rule" );

Add a custom validator via Javascript:

$.validator.addMethod(
        "regex",
        function(value, element, regexp) {
            var check = false;
            var re = new RegExp(regexp);
            return this.optional(element) || re.test(value);
        },
    '<%= GetRes("Your message from sderver") %>'
    );

apply the validation rule to all elements with a “regexp” attribute existing:

if ($('INPUT[regexp]').length > 0) {
    $('INPUT[regexp]').rules("add", { regex: $(this).attr('regexp') });
}

5) If you need to change the default validation messages you can use this code:

jQuery.extend(jQuery.validator.messages, {
required: '<%= GetRes("Your_String_Id") %>'
});

GetRes is an internal helper function, it loads a string from the resources.

Hope it helps!

HOWTO use DNN properties inside a ascx SKIN

2010-11-10T17:17:00.001+01:00

If you need to use inside a DotNetNuke skin ascx file the user email or the username or other information you can write this code:

<%= UserController.GetCurrentUserInfo().email %>

If you need it inside Javascript you can define this code:

And use it in you js code, using the command:

if (typeof GlobalUserEmail!="undefined")
//your code here

Here are the complete properties list:

http://www.dotnetnukeru.com/dnndocs/api/html/T_DotNetNuke_Entities_Users_UserInfo.htm

How to call Outside.in location service using c#

2010-11-08T02:25:00.001+01:00

If you are evaluating the Outside.in localized news service you may find useful this little command line program, it generates the right MD5 security code and it calls the "Location by name" service:

Here a basic test program written in c#, I think is a good start, it queries for locations:

///////////////////

using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
using System.Security.Cryptography;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("enter location,for example new york:");
            string action = Console.ReadLine();
            while (action != "")
            {
                string search;
                search = action;

                string mykey = "xxx";
                string shared_secret = "xxx";
                int unixTime = (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds;
                string sUrl = "http://hyperlocal-api.outside.in/v1.1/locations/named/" + search + "?dev_key=" + mykey + "&amp;sig=" + MD5_ComputeHexaHash(mykey + shared_secret + unixTime.ToString());

                WebRequest wrGETURL;
                wrGETURL = WebRequest.Create(sUrl);

                Stream objStream;
                objStream = wrGETURL.GetResponse().GetResponseStream();

                StreamReader objReader = new StreamReader(objStream);

                string sLine = "";
                int i = 0;

                while (sLine != null)
                {
                    i++;
                    sLine = objReader.ReadLine();
                    if (sLine != null)
                    Console.WriteLine("{0}:{1}", i, sLine);
                }
                action = Console.ReadLine();
            }
        }

        public static string MD5_ComputeHexaHash(string text)
        {
            // Gets the MD5 hash for text
            MD5 md5 = new MD5CryptoServiceProvider();
            byte[] data = Encoding.Default.GetBytes(text);
            byte[] hash = md5.ComputeHash(data);
            // Transforms as hexa
            string hexaHash = "";
            foreach (byte b in hash)
            {
                hexaHash += String.Format("{0:x2}", b);
            }
            // Returns MD5 hexa hash
            return hexaHash;
        }
    }
}

Howto enable performance profiling on IIS and VS2008

2010-11-07T17:54:00.000+01:00

If you are using VS2008/2010 and you need to profile your code you can have the warning:

The profiling environment for ConsoleApplication2 is not set up correctly. Use vsperfclrenv.cmd to setup environment variables. Continue anyway?

The solution is to execute the vsperfclrenv.cmd located under:

C:\Program Files\Microsoft Visual Studio 9.0\Team Tools\Performance Tools>vsperfclrenv.cmd /globalsampleon

using the globalsampleon option.

Howto Create Email Templates on Gmail

2010-09-29T16:20:00.001+02:00

Today I discovered how to create mail templates using Gmail.

Following this procedure you will be able to send emails using a set of saved templates.

Go to GMAIL, click on the google labs image on the top right corner
Find the “Canned Response” function, here is how it looks like:
Click on “Enable” and save the settings
Create a New Email message
Write your email template, next click “Canned Response” –> “New Canned Response”
Click Ok
Click “Compose New Message”, click yes if gmail ask you to discard the previous message
Click on “Canned Response” –> Insert
Voilà! Here is your beautiful mail created from a template:

One question: why google doesn’t offer a TEMPLATE labs function? Canned response is not too attractive and is a little obscure, in my humble opinion.

Hope it helps.. and I really appreciate your feedbacks!

POET vulnerability on ASP.net.... be fixed!

2010-09-23T15:53:00.000+02:00

Some days ago two security researchers Juliano Rizzo and Thai Duong had discovered a new way to gain administrative permission on ASP.NET web servers including DNN using a a bug in the default encryption mechanism used to protect the cookies.

They created a tool (the Padding Oracle Exploit Tool or POET), that can repeatedly modify an ASP.NET Forms Authentication cookie encrypted using AES and, by examining the errors returned, determine the Machine Key used to encrypt the cookie.

The process is claimed to be 100 percent reliable and takes between 30 and 50 minutes for any site.

Here is the link to the youtube demostration :

http://www.youtube.com/watch?v=yghiC_U2RaM

And here is the info to mitigate this vulnerability:

http://www.microsoft.com/technet/security/advisory/2416728.mspx

Update your sites!!!

Hot to recover unused space from SQL server free edition (MSDE,Express)

2010-09-06T12:30:00.002+02:00

If you have a SQL server free edition and it isn’t working with the message:

CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.

Unfortunately the ”dbcc cleantable “ does not help, it cleans the table unused space BUT the shrink operation does not decrease the database size

You have another option: reorganize the indexes and shrink the db: it works giving you some hours of new life, just the time to install SQL2008 express R2 with 8GB limit

Follow this steps:

Open Sql Server Management Studio
Run sp_helpdb ‘YourDb’ and save the results
Analyze the tables with the bigger size, use this script:
http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx
Change in the script the final query :

from:
SELECT *
FROM #TempTable
To :
SELECT *
FROM #TempTable
order by cast(replace(IndexSize,' KB','') as int) desc

Run the query and identify the worst tables
Open the Tables, Index and click on “Reorganize all”
Shrink the DB
Run sp_helpdb ‘YourDb’ and compare the results with the old one
Install the new SQL server and try to migrate the databases, but this is another story…..

Hope it helps!

How to use JQuery UI Theme with other themes using CSS Scope

2010-09-02T17:11:00.001+02:00

If you need to use the slider element inside you web site you’ll find very useful the JQuery UI Slider:

You can download from the JQuery UI web site the theme you like and you can use it inside your web site.

Theme preview	+	Theme download	=	Theme folder with CSS and Images
	+		=

One problem may arise if your site is using another theme, the second theme will override the first, causing undesired layout effects.

Here comes the “Advanced Theme Settings” option, it permits to define a “CSS namespace” used only by the new control:

Next you need to insert your control code inside an HTML element like div or span with the same CSS Scope, for example:

And this is the effect, two JQuery themes used in the same page:

How to Add JQuery Intellisense to JS libraries in VS2010

2010-08-26T17:31:00.000+02:00

If you work with JQuery and VS2010 you will find usefull enabling intellisense support for JQuery, for example:

You can have the JQuery Intellisense following this steps:

Download from the JQuery site the file jquery-1.4.1-vsdoc.js, search for the Visual Studio link near the release link
Add the file to your project
Change your js file and add to the top of the file:

Hope it helps!

How to replace Flash with an Image for IPad/IPhone & disabled flash browsers

2010-08-03T18:03:00.001+02:00

If your web site users are using IPad or IPhone or simply if they disabled flash on their browser you need to replace the ugly icon with a beautiful image.

Here is the magic script, copied from the web site http://www.kirupa.com/developer/mx/detection.htm, the script shows the swf flash or replaces it with an image if Flash is not supported.

<SCRIPT LANGUAGE=JavaScript1.1>
<!--
var MM_contentVersion = 6;
var plugin = (navigator.mimeTypes && navigator.mimeTypes["application/x-shockwave-flash"]) ? navigator.mimeTypes["application/x-shockwave-flash"].enabledPlugin : 0;
if ( plugin ) {
        var words = navigator.plugins["Shockwave Flash"].description.split(" ");
        for (var i = 0; i < words.length; ++i)
        {
        if (isNaN(parseInt(words[i])))
        continue;
        var MM_PluginVersion = words[i]; 
        }
    var MM_FlashCanPlay = MM_PluginVersion >= MM_contentVersion;
}
else if (navigator.userAgent && navigator.userAgent.indexOf("MSIE")>=0 
   && (navigator.appVersion.indexOf("Win") != -1)) {
    document.write('<SCR' + 'IPT LANGUAGE=VBScript\> \n'); //FS hide this from IE4.5 Mac by splitting the tag
    document.write('on error resume next \n');
    document.write('MM_FlashCanPlay = ( IsObject(CreateObject("ShockwaveFlash.ShockwaveFlash." & MM_contentVersion)))\n');
    document.write('</SCR' + 'IPT\> \n');
}
if ( MM_FlashCanPlay ) {
        document.write('<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"');
    document.write('  codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" ');
    document.write(' ID="script" WIDTH="300" HEIGHT="200" ALIGN="">');
    document.write(' <PARAM NAME=movie VALUE="script.swf"> <PARAM NAME=quality VALUE=high> <PARAM NAME=bgcolor VALUE=#FFFFFF>  '); 
    document.write(' <EMBED src="script.swf" quality=high bgcolor=#FFFFFF  ');
    document.write(' swLiveConnect=FALSE WIDTH="300" HEIGHT="200" NAME="script" ALIGN=""');
    document.write(' TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer">');
    document.write(' </EMBED>');
    document.write(' </OBJECT>');
} else{
    document.write('<IMG SRC="script.gif" WIDTH="300" HEIGHT="200" usemap="#script" BORDER=0>');
}
//-->
</SCRIPT><NOSCRIPT><IMG SRC="script.gif" WIDTH="300" HEIGHT="200" usemap="#script" BORDER=0></NOSCRIPT>

Replace the script.swf file name with your flash and replace the script.gif image with your replacement image name.

This script is tested and working!

LEGO Universe from the developer perspective

2010-07-30T01:50:00.016+02:00

Today I installed the Lego Universe Beta but unfortunately the game is closed for some days,so I decided to analyze the game from the developer perspective.

Web site
~~Game network traffic~~ ... Lego NDA... oooppsss!
~~Game technologies~~ ....Lego NDA... oooppsss!

1) Web site
The web site is developed using ASP.net and aspx pages, it uses for client interaction JQuery 1.4.2 and other libraries. The pages loads resources from two addresses: http://universe.lego.com and http://cache.lego.com , this is a common strategy used to parallelize the browser load. There are some interesting JavaScript libraries used:

fancybox: a simple lightbox alternative for JQuery
colorbox : a light-weight, customizable lightbox plugin for jQuery
cufon : custom fonts rendering library, used for changing fonts of your HTML elements.
SWFObject : flash detection
SiteCatalyts : web site statistics
jQuery UI Effects 1.8: useful for HTML effects like Blind,Fade,Slide,, Pulsate and many more.

Others libraries packed and minified in the same file:

jQuery cookie: simple, lightweight utility plugin for reading, writing and deleting cookies
jQuery Urls: used to read request parameters of the actual URL jquery.navigation.js
jquery.rowheight.js
jquery.updateable.js
jquery.togglebox.js
jquery.rounded.js
jquery.ajaxload.js
jquery.popup.js

It’s interesting to see the “weight” of the different documents type used in the page: The “Old HTML code” has the lowest impact on the weight of the page, first come images (as expected) with 900Kb, next Scripts (270Kb!) and CSS (64Kb)… the latest is HTML with 27Kb.

2) Game network traffic

Non-Disclosure Agreement (NDA)... I will tals about this as soon as the game will be on market

3) Game technologies

Non-Disclosure Agreement (NDA)... I will tals about this as soon as the game will be on market

This is a quick and facile analysis, the most interesting thing is that behind a game there’s a world build using different tools and technologies : ASP.NET, XML, VC++, Python, CruseControl, JQuery, Patch Management, Web services, Client-Server protocols and many other, a lot of arguments to learn!

How To avoid double click on ASP.NET buttons…

2010-07-29T16:33:00.001+02:00

A common task when you develop web applications is to avoid double clicking on buttons, the user may send two or more times the form content and sometimes you may have unexpected results like double payments and other nasty effects.

Here is the code snippet used to avoid this behavior, btnSendResults is the ASP.NET buttons that causes the postback event, use in the Page_Load event:

btnSendResults.Attributes.Add("onclick", "this.disabled=true;" + ClientScript.GetPostBackEventReference(btnSendResults, "")+";return false;");

Hope it helps!

How To center “Coding Staff Popup” DNN module

2010-07-29T15:24:00.001+02:00

If you need to show a simple popup message on your Dot Net Nuke site you can download and install the good “Coding Staff Popup”, here is the demo page.

Here is the nice modal popup created with this module:

I found useful to override some behaviors like width, height, hide the title bar and reposition the popup, here is what to do:

1) Hide the title bar
Go to the module “Advanced Settings” and add to the Header section the code:

<style type="text/css">
.popup-window-header
{
display:none!important;
}
</style>

Image:

2) Resize the popup:
In the same section add the CSS style:
.jqmWindow
{
position:absolute!important;
width:1030px!important;
height:380px!important;
top:160px!important;
margin-left:0px!important;
}

3) Center the popup:
With JQuery you can easily reposition the popup using the exact window size, add to the “Advanced Settings” “Footer” the code:

Note that popupDialog and jqmWindow' are HTML elements created by the Popup module.

Here is the Picture of the module section:

Here is the page before the patch :

And here is the result, popup aligned exactly to the center, title hidden with custom popup size.

ORMBattle, Object-relational mapping performance tests

2010-07-26T10:33:00.001+02:00

Today I found out a new interesting site totally dedicated in the evaluation of Object Relational Mapping (ORM) solutions and libraries, ORMBattle : http://www.ormbattle.net/

This site shows the comparison of 8 famous technologies used for data mapping:

It shows useful charts about the number of queries executed per second and the number of basic CRUD or CUD operations:

You can find all details and test projects at

http://www.ormbattle.net/

GMAIL attachments drag & drop.

2010-07-26T09:38:00.001+02:00

If you are using GMAIL from your browser and if you have Chrome and Firefox you can send attachments simply dropping them in your new message:

This tip and other 4 useful tips are explained in this post of the official GMAIL team:
http://gmailblog.blogspot.com/2010/06/tip-5-things-you-may-not-know-you-can.html

Simply write logs from your .net app using System.Diagnostics.Trace

2010-07-23T10:59:00.001+02:00

Here is one of the simplest method for logging from your application, simply use the System.Diagnostics.Trace class and call:

System.Diagnostics.Trace.WriteLine(message);

and add to the App.Config file this section:

<?xml version="1.0"?>
<configuration>
  <system.diagnostics>
    <trace autoflush="false" indentsize="4">
      <listeners>
        <add name="myListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="MyService.log" />
        <remove name="Default" />
      </listeners>
    </trace>
  </system.diagnostics>
</configuration>

And the logging will be executed succesfully.

If you need the logs on the Event Log add:

<add name="myEventListener" type="System.Diagnostics.EventLogTraceListener"  initializeData="TraceListenerLog" />

And you’ll find the event log populated with your application log.

Migrating external assemblies used in RDLC from VS2005 to VS2010

2010-05-20T12:33:00.002+02:00

If you are using ReportViewer and RDLC reports in visual studio 2005 you may use externals assemblies for additional rules and formulas, in order to enable external assemblies you need to call the AddTrustedCodeModuleInCurrentAppDomain function.

rv.LocalReport.AddTrustedCodeModuleInCurrentAppDomain("MyLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null");

Porting this code to VS2010 without changes will generate the exception:

Exception of type 'System.Web.HttpException' was thrown.

Exception of type 'System.Web.HttpUnhandledException' was thrown.
Report execution in the current AppDomain requires Code Access Security policy, 
which is off by default in .NET 4.0 and later. 
Enable legacy CAS policy or execute the report in the sandbox AppDomain.

With the exception detail:

Exception of type 'System.Web.HttpException' was thrown.
Exception of type 'System.Web.HttpUnhandledException' was thrown.
at System.Web.UI.Page.HandleError(Exception e) 
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
at System.Web.UI.Page.ProcessRequest() 
at System.Web.Util.AspCompatApplicationStep.System.Web.HttpApplication.IExecutionStep.Execute() 
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
Exception of type 'System.Web.HttpException' was thrown.
Exception of type 'System.Web.HttpUnhandledException' was thrown.
Report execution in the current AppDomain requires Code Access Security policy, which is off by default in .NET 4.0 and later. Enable legacy CAS policy or execute the report in the sandbox AppDomain.
at Microsoft.Reporting.WebForms.LocalReport.ReportRuntimeSetupHandler.AddTrustedCodeModuleInCurrentAppDomain(String assemblyName) 
at Microsoft.Reporting.WebForms.LocalReport.AddTrustedCodeModuleInCurrentAppDomain(String assemblyName) 
at Web.Report.OnInit(EventArgs e) in C:\inetpub\wwwroot\Web\Report.aspx.cs:line 500 
at System.Web.UI.Control.InitRecursive(Control namingContainer) 
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

The solution is to use the new AddFullTrustModuleInSandboxAppDomain function, using the SetBasePermissionsForSandboxAppDomain function, here is an example:

using System.Reflection;

using System.Security;

using System.Security.Permissions;

using System.Security.Policy;

//...

//...

PermissionSet permissions = new PermissionSet(PermissionState.None);

permissions.AddPermission(new FileIOPermission(PermissionState.Unrestricted));

permissions.AddPermission(new SecurityPermission(SecurityPermissionFlag.Execution));

rv.LocalReport.SetBasePermissionsForSandboxAppDomain(permissions);

Assembly asm = Assembly.Load("MyLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null");

AssemblyName asm_name = asm.GetName();
rv.LocalReport.AddFullTrustModuleInSandboxAppDomain(new StrongName(new StrongNamePublicKeyBlob(asm_name.GetPublicKeyToken()), asm_name.Name, asm_name.Version));

Hope it helps!, and happy coding!

How to resolve Silverlight error "Could not download the Silverlight application. Check web server settings"

2010-04-30T11:15:00.000+02:00

If you deploy your Silverlight application to your web server you may receive this error when you try to load the Silverlight page:

Unhandled Error in Silverlight Application
Code: 2104
Category: InitializeError
Message: Could not download the Silverlight application. Check web server settings

You can resolve it configuring the web server Mime Types, check if this values are configured:

.xaml application/xaml+xml
.xap application/x-silverlight-app
.xbap application/x-ms-xbap

Hope it helps and Happy Coding!

Don’t trust www.tcw-tech.com and Crystal sales manager.

2010-04-16T14:21:00.008+02:00

Today I got the item I bought from a chinese website, www.tcw-tech.com, specialised in usb flash drives and hard disks.

The site looks professional, with detailed infos such as contacts, phone numbers and payment methods, as well as a detailed catalogue and interesting prices.
For such reasons my colleagues and I decided to purchase three memory sticks Kingston DataTravel 200 sized 256Gb. I had a long discussion with Ms. Crystal, the sales manager. We exchanged emails and chats on the messenger and eventually purchased 3 flash drives for a total of 130 USD.

The result? we got the drives but they are fake! Capacity is limited to 16Gb instead of the promised 256Gb.
The drives seem to be loaded with a bad and hacked firmware: when you exceed 16Gb of data, all files copied onto the drive are unreadable.
On the Internet I have found a useful utility, H2testw, specialised in testing flash drive quality. The result? All tests exceeding 16Gb returned the following:

Warning: Only 3558 of 260936 MByte tested.
The media is likely to be defective.
0 KByte OK (0 sectors)
940 MByte DATA LOST (1925120 sectors)
Details:0 KByte overwritten (0 sectors)
0 KByte slightly changed (< 8 bit/sector, 0 sectors)
940 MByte corrupted (1925120 sectors)
0 KByte aliased memory (0 sectors)
First error at offset: 0x0000000000000000
Expected: 0x0000000000000000
Found: 0xffffffffffffffff
H2testw version 1.3

I have emailed Ms. Crystal and she replied that this is a mistake and she needs to ask her manager and stuff like that..

So.. do not trust this site, they sell fake products.

Here are the contact info, do not send money to these addresses !!

Web site url	http://www.tcw-tech.com/ http://www.usbmemorychina.com (same site with different name)
Tel.	0086-0595-28833860 0086-595-28010026
Email	tcw-tech_CEO@hotmail.com usbmemorychina@gmail.com
Msn	tcw-tech_CEO@hotmail.com usbmemorychina@hotmail.com
Bank Account Number	4772755-0188-083961-8
Contact Name	YaZhan Xu or Yuhua Xue
Payment methods	Western Union, Payment Via Bank Transfer
	Transaction Fee :USD 9.00 Beneficiary Name :UMC Technology Co., Limited Bank Name :HSBC Hong Kong Beneficiary Account : 817-309172-838 Swift Code : HSBCHKHHHKH Bank Address :1 Queen's Road Central，Hong Kong
	Transaction Fee : USD 20.00 Beneficiary Name : Yuhua Xue Bank Name : BANK OF CHINA, SHENZHEN BRANCH, FUTIAN SUB-BRANCH Beneficiary Account : 4549204-0188-021314-4 Swift Code : BKCHCNBJ73B Bank Address :518000,Futian-branch,Shenzhen district,Guangdong,China
	Payment Via Western Union Transfer Bank Name : WESTERN UNION BANK First Name : Yuhua Last Name : Xue City : Shenzhen State : Guangdong Country : China
Ip Address	204.16.194.116
Other web site connected on the www.tcw-tech.com Ip address, I don’t kwok if they are the same as www.tcw-tech.com but pay attention when you send money to them.	Use http://www.ip-adress.com/reverse_ip/204.16.194.116 Number Domain/Host 1. fywatch.com 2. xanaduplaza.com 3. ccrr22s.com 4. numberonefashion.com 5. www.bestnike23.com 6. www.numberonefashion.com 7. www.e-joining.com
Web site Register info	Registrant Contact: xufan fan xu xf99b5148@163.com 13760193272 fax: 05925861834 lianban xiamen fujian 361004 cn Registrar: BIZCN.COM, INC. Whois Server: whois.bizcn.com Referral URL: http://www.bizcn.com Ip address: 204.16.194.116

Here is a an original picture of their contact info, the bank info page has been deleted from the site.

The site is connected with another site: http://www.usbmemorychina.com, same layout with some little differences, here is a screenshot:

And here are the web site information:

Web site url	http://www.usbmemorychina.com
Email	usbmemorychina@gmail.com
Msn	usbmemorychina@hotmail.com
Contact Info	Ms.Huang Sarah MSN:usbmemorychina@hotmail.com Tel: 0086-595-28833860 Email:usbmemorychina@gmail.com Ms.Mary MSN:umc-mary@hotmail.com Tel: 0086-595-28833860 Email:umcmary@gmail.com
General Manager:	Ms. Huang Sarah
Technical Support:	E-mail: umcmary@gmail.com
Ip Address
Connected Web Sites
Registrant Contatcs	Registrant Contact: huli li hu 83929414.com@qq.com 13760193272 fax: 05925861855 lianban xiamen fujian 361004 cn Ip Address:204.13.71.233
Ip Address	204.13.71.233
Other web site on the same IP. Pay attention when you send money to them.	Use http://www.ip-adress.com/reverse_ip/204.13.71.233 Number Domain/Host 1. www.niketradeweb.com 2. giftspop.com 3. www.ec98.com 4. gogoebay.com 5. cotextcn.com 6. www.wellbiznet.com 7. christianlouboutinheel.com 8. www.nikelist.com 9. www.gogoebay.com 10. nagara-pandora.com

I Hope that these info will help you saving some money.
I will update this page on a regular basis, so .. check it often!

LAST MINUTE UPDATE:

Here is another connected web site: http://chinaphonewholesale.com

Web site image:

Web site	http://chinaphonewholesale.com
Ip Address	204.16.194.104
Other web site on the same IP. Pay attention when you send money to them.	Use http://www.ip-adress.com/reverse_ip/204.16.194.104 Number Domain/Host 1. range-tech.com 2. cameshop.com 3. 66trade.com 4. www.hao-yi.com 5. www.cinzee.com 6. www.nikeallstar.com 7. hao-yi.com 8. www.unionseller.com 9. xmputian.com 10. zzpke.com

Update 2:
Opening the usb key I saw the Chipset Number that is MW8209.
Using a detection tool I found the real flash model: MT29F128G08TAA_16GB

How to disable annoying beep or system bell in VMWARE workstation

2010-03-23T10:14:00.001+01:00

VMWARE sometimes when the virtual machine is starting execute some “Beeps” using the internal speaker of your desktop.

This happens usually on Linux or MacOs machines.

Edit the .msk file and add:

mks.noBeep = TRUE

Simple and working.

How to manage localized strings in DNN Form and List XSLT

2010-03-05T12:25:00.001+01:00

Do you need to insert nationalized strings in a Form and List module on Dotnetnuke 5?

Here is the solution:

<xsl:variable name="currentCulture" select="//udt:Context/udt:CurrentCulture" />
<xsl:if test="$currentCulture='it-IT'">
Italian text    
</xsl:if>    
<xsl:if test="$currentCulture='en-US'">
English text     
</xsl:if>

Hope it helps…

How to inspect Blue Screen Issues or the Blue Screen of Death (BSOD)

2009-12-09T15:18:00.001+01:00

Hello, today I’ll show you how to address the terrible Blue Screen on windows systems, this problem i also known as “BSOD Blue Screen Of Death”

Here is a typical BSOD:

The most important info is the first error code (number 1) and, if present, the driver/dll who caused it.

The hexadecimal number following the word "STOP" is called the bug check code or Stop code.

If you read the “Device and Driver Development Tools – Bug Check Codes” you can find the error code and what it means, for example the STOP:50 is a :

Bug Check 0x50: PAGE_FAULT_IN_NONPAGED_AREA
The PAGE_FAULT_IN_NONPAGED_AREA bug check has a value of 0x00000050. This indicates that invalid system memory has been referenced.

The other parameters are specific for the error code, in this example the third parameter identifies a “Write Operation” on Memory.

Now we have two options, the Easy Way and the Hard Way, let’s start from the Easy Way.

Remember to enable the Crash Analysis option using the System Option from the Control Panel , see also this link

The Easy Way- if you need to run

Install this useful application WhoCrashed from Resplendence Software House.

Launch the application on the system where the BSOD appears, download,if asked, the Debugging Symbols from Microsoft and click the “Analyze” button, after some time the app will show you the info about the most suspect dll/driver, here is an example from the SW web site:

Upgrade/Disable/Uninstall it and… the BSOD will disappear.

The hard way – if you need to know the details

Install the “Debugging Tools for Windows” debugger, configure the Symbols Path with the right string, for example:

SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols

Use the “File—>Open Crash Dump” option and load the dump from “%SYSTEMROOT%\minidump”

At the first load you can see this message:

Execute the !analyze –v command, the debugger will analyze the call stack:

Click on the module name link and you will see the path and the details of the faulting module:

Identify the DLL vendor and update his application or uninstall/disable it if no updates are available, the BSOD should disappear from your system.

Hope it helps!

UPDATE #1

How to disable a BSOD driver from windows start

If the BSOD is caused by a driver you need to disable it from loading on windows boot.

Download from sysinternals site the AutoRuns program, execute it and open the Drivers Tab:

How to insert a Paypal button in your blogger posts footer

2009-12-05T16:35:00.001+01:00

Connect to PAYPAL.COM

Click on Merchant Services

Look on the bottom of the page, click on "Buy Now Buttons"

Choose the type of payment, Donation in this case

Choose also currenct and a name that helps identifyng the payment

Click "Create Button..."

A new window appears with the HTML that configures the payments, copy the blue code:

Go to you blogger blog, select Layout, Chanege HTML

Save a backup of your model.

Click on "Expand widget model", this is fundamental.

Look the HTML code and find the "data:post.body" TAG, insert after this tag your PAYPAL html code.

Blogger needs well formed HTML, all the inputs field need to end with "/>" the closing tag.

Correct the missing closing tags.

Click on preview....and .. .thats all, now you have a paypal footer in all your posts.

Don't forget to save the model!!!

Hope it helps!

JQuery assorted tips

2009-11-30T08:46:00.001+01:00

Here are some useful JQuery 1.2.7 code snippets:

//Select the cheched checbox:
$('#myId').find('input[@type=radio][@checked]')

//Get an array of text of the selected SELECT
var elems = $.map($('#myId).find('select :selected'),function(a){return $(a).text();})

//Get an array of the values of the selected SELECT
var txtelems = $.map($('#myId).find('[@id=innerElementId]').find('input'),function(a){return $(a).val();});

//Set the title on a element
$(idTxtSearch).attr('title','my title');

//Focus a textbox (INPUT field)
$(idTxtSearch).focus();

//reset the value of a textbox (INPUT field)
$(idTxtSearch).val('');

//not JQuery, add a trim function to the JavaScript String object
String.prototype.trim = function () 
{
    return this.replace(/^\s*/, "").replace(/\s*$/, "");
}

//ASP.NET + JQuery + blockUI
//Call the postback on a button after having blocked the page
//Note that the __doPostBack requires the name of the element, not the Id, asp.net rules.
$.blockUI({message:$('#myId').html()});
__doPostBack($('#<%= myAspNetBtn.ClientID %>').attr('name'), '');

//Attach the keyup event of a textvox
$().keyup(function(e){myFunction();});

//function for the blur and focus events
searchBoxes.focus(function(e){$(this).addClass("mycss");});  
searchBoxes.blur(function(e){$(this).removeClass("mycss");});

//reset all the checkboxes inside an element
$('#myid > input[@type=radio]').attr('checked','')

//find the first DIV inside a table row that contains a value
if ($('#myid').find('tr:contains(thestring)').find('div:eq(1)').length>0)

//reset an element and add some HTML
$('#myid').empty().append(someHTML);

//find all visible elements inside an element with class myClass
$('.myClass').find('*').css("visibility","visible");

//change the source image on some images 
$(elemDiv).find('IMG[@src*="myvalue"]').attr('src','images/oem/newimg.png');

//add the nowrap attribute to all TDs
$(elemDiv).find('TD').attr('nowrap','nowrap');

//hide an element 
$('.myClass').hide();

//disable a button
btn.attr('disabled','disabled');

//find the first element with the same attribute and get the display attribute
$("[@myattr='my-row']:first").css('display');

//Toggle a class on a element
element.toggleClass("myClass");

//Execute script after the page load
$(document).ready(function()
{
    //some js here;
});

//find the first image inside an element and chenge the image source
element.children('img:first').attr('src',newSrc);

//duplicate an HTML element
$('#myId').clone();

//get the url of an anchor with id=myId
var sUrl = $("a[@id='myId']").attr('href');

//hide all anchors inside an element
$('#myId').find('A').css('display','none');

//get the text of an element
var text = $('#myId').text();

//disable a button
$('#myId').attr('disabled', true);

//click a button after the load of the page
$(document).ready(function(){$('#myId').click()});

//check all visible checkboxes inside a table
function selectAllVisibleCheckBox(idTable)
{
    $("#" + idTable).find("input[@type$='checkbox']").each(function()
    {
        if ($(this).parents("TR").css("display")!='none')
            this.checked=true;
    }
    );
    return false;
}

//call the classical HelloWorld asmx web service using JQuery
jQuery.ajax({
    type: "POST",
    contentType: "application/json; charset=utf-8",
    url: "WebServices.asmx/HelloWorld",
    data: "{'msg':'hello!'}",
    dataType: "json"
});

Visual Studio 2005 Express Downloads

2009-11-26T14:59:00.001+01:00

Do you need to install Visual Studio 2005 Express but you don’t find it?

Here are the working link:

http://go.microsoft.com/fwlink/?LinkId=51411&clcid=0x409

http://go.microsoft.com/fwlink/?LinkId=51413&clcid=0x409

http://go.microsoft.com/fwlink/?LinkId=51405&clcid=0x409

http://go.microsoft.com/fwlink/?LinkId=51410&clcid=0x409

IE8 slow tabs opening, IE8 and ssvagent.exe investigation..

2009-11-20T14:45:00.001+01:00

Today I’ve noticed that the opening of Internet Explorer 8 was too slow, 15-20 seconds… with the window blocked.

It’s a Microsoft fault?? Let’s investigate.

I Opened the Task Manager and I saw Cpu spikes for 20 seconds during the IE start:

With Sysinternals Process Explorer I’ve investigated the process detail, on every tabs opening there was a process that started and used the CPU for 15 seconds.. the process was a Sun Microsystems program, not Ms.

I Investigated the thread detail of the process and I found that the CPU activity was on a single thread:

The detail of the thread shown that the CPU problem was correlated with functions used by the Mozilla Plugins system:

Plugins? Let’s see the Plugin section in Internet Explorer, I found Java Plugin , and it was enabled and loaded:

Let’s try to deactivate it, close and open the browser and…

Wow, now the start time is only 3 seconds, and this time is the same for the tabs opening.

Hope it helps!

UPDATE #1 - 2009-11-23

As feranm wrote I should have checked the loading time of the plugin using the “load time” column in the plugin list.

But for this plugin the loading time wasn’t available:

UPDATE #2 - 2009-11-23

In my office 4 users over 4 decided to use Firefox, they felt “Internet Explorer 8 is very slow…”
After the fix they were happy and started to use IE8 again.

Is Microsoft aware of this problem? Does Microsoft know that their product is felt by the users as “slow and unresponsive on startup”, and this bad feeling is caused by Sun Microsystems?

Cannot open the outlook window…

2009-11-18T09:17:00.001+01:00

This morning I tried to open the Outlook client and.. here is the error:

and the italian message:

Looking at the windows events log (eventvwr on command line) I saw these messages:

“Outlook: The store was last opened on a different machine.”

Searching with Google I found this little trick, Outlook has a “reset” command switch that clears the outlook state:

Open command line, go to your Outlook folder and type:

outlook.exe /resetnavpane

And the Outlook start will be fixed!

outlook.exe /resetnavpane

How to configure Sysinternals Procmon & Procexplorer debug sysmbols

2009-11-13T17:31:00.002+01:00

If you use Process Explorer or Process Monitor from sysinternals you will find useful to see the names of the called function in the call stack window.

Go to Options—>Configure Symbols and type:

Here are the strings:
C:\Program Files\Debugging Tools for Windows (x86)\dbghelp.dll
and
SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols

Here is an example of complete call stack, note the windows function names:

Remember to install the latest Debugging Tools For Windows!

Default router security settings… are dangerous

2009-11-13T14:21:00.002+01:00

Yesterday I did a little scan (with SoftPerfect NetScanner) on port 80 using a range of public ips, I needed to find a colleague’s personal web site.
I didn’t find the web site but… I found some ips responding on port 80 (web servers).
I looked on one of those address with my browser and…
I saw this strange message: “The server 79.54.62.xxx at address Default Admin.=admin/admin requires a username and a password” .

Wow!! This is security!!!!

Some genius has configured the name of the router administrative site using the name and the password, i think this is a default setting of the router (Kraun router).

I inserted admin/admin and here is the result: full access to the router configuration…

Be careful with default settings, they leave dangerous open ports in security!

How to get columns type from Query

2009-11-11T17:06:00.003+01:00

Sometimes I need to find info about columns in a table using only TSQL, here is a little query :

SELECT 
syscolumns.name AS ColName, 
systypes.name AS ColType, 
syscolumns.length AS ColSize,
syscolumns.isnullable,
systypes.collation
FROM sysobjects INNER JOIN syscolumns 
ON sysobjects.id = syscolumns.id 
INNER JOIN systypes 
ON dbo.syscolumns.xtype = dbo.systypes.xtype 
WHERE 
sysobjects.xtype='U' 
AND sysobjects.name='banners'

And here is the result, banners is a DotNetNuke table:

DNN: how to reset the host password

2009-11-10T18:04:00.002+01:00

Here is a way to reset the password of the DNN host user, it's usefull if you forget the password or if you need to install a copy of a DNN installation without knowing the host password:

Declare @UserName NVarChar(255)
Declare @NewPassword NVarChar(255)
Declare @PasswordSalt NVarChar(128)
Declare @Application NVarChar(255)

Set @UserName = 'host' -- This default DNN host user
Set @NewPassword = 'newpassword' --New password

Set @Application = (SELECT [ApplicationID] FROM aspnet_Users WHERE UserName=@UserName)
Set @PasswordSalt = (SELECT PasswordSalt FROM aspnet_Membership WHERE UserID IN (SELECT UserID FROM aspnet_Users WHERE UserName=@UserName))

Exec dbo.aspnet_Membership_ResetPassword @Application, @UserName, @NewPassword, 10, 10, @PasswordSalt, -5

Hope it helps,

SQL Azure good/bad news

2009-11-04T17:09:00.002+01:00

Good news, Sql Azure in available, is Sql server 2008, you can create Db up to 10Gb size and you can register online and activate the account in few hours.
Bad news: Sql Azure has limitation, a lot of limits and forget that your existing setup working on SQL2008 will work on Sql Azure.
Note that SqlAzure IS Sql2008 but, on line you will find how many limitation it has:

- No enterprise manager, only query window
- No profiler
- USE statement not supported
- KILL,BACKUP,SELECT INTO, BULK INSERT
- PAD_INDEX,ALLOW_ROW_LOCKS,ALLOW_PAGE_LOCKS not supported during table definition (they are common if you build script using Management Studio)
- And lot lot of limitation, see
Unsupported/Supported Data Types (like text,ntext,image): http://msdn.microsoft.com/en-us/library/ee336233.aspx
Unsupported Transact-SQL Statements : http://msdn.microsoft.com/en-us/library/ee336253.aspx
Unsupported/Supported System Stored Procedures : http://msdn.microsoft.com/en-us/library/ee336237.aspx

So, if you think that you can connect and work on SQL Azure transparently with your application... don't begin to work on Sql Azure.
If you are developing a new app from scratch.. it's worth a try.

Error C1108, "alink.dll" not found on VS2005,Windows 7

2009-10-30T12:08:00.005+01:00

After the upgrade from Vista to Windows 7 I started to see some weird errors during the build step of VS2005 VC++ projects, the error was:

"fatal error C1108: unable to find DLL: 'alink.dll'"

Another problem was the crash of mt.exe during the updating of the manifest.

If you have installe the VS2010 beta before the Windows 7 Upgrade, here is the solution to these errors:

Uninstall VS2010 beta
cmd /c "msiexec /x {19BD09BF-3BBD-3663-A5ED-50B6B2B07E42} /qb" 
cmd /c "msiexec /x {1DF6A8F6-5048-323F-8758-DA533CE0F07E} /qb"

These commands will remove the Beta1 4.0 Framework from your machine, and after this all the projects will compile succesfully.

More details on:

http://social.msdn.microsoft.com/Forums/en-US/netfxsetup/thread/a5d827d7-05b4-41b9-9565-e9e4abb12e66

Hope it helps,

Serialize and Deserialize RDL class class to\from XML

2009-10-15T11:38:00.008+02:00

If you have a ReportViewer class generated from the XSD report definition file using:
xsd.exe /c /namespace:Rdl ReportDefinition.xsd

You can serialize and deserialize the class to/from RDLC XML:

xmldoc contains the XML RDLC code and is an XmlDocument.

Deserialization, from XML to Class

Rdl.Report report = new Rdl.Report();
XmlSerializer serializer = new XmlSerializer(typeof(Report));
XmlNodeReader xmlr = new XmlNodeReader(xmldoc);
report = (Rdl.Report)serializer.Deserialize(xmlr);

Now you can change the report elements using the objects and collections inside the
Rdl.Report class.

And Serialization, from Class to XML:

XmlDocument xmldoc = new XmlDocument();
StringBuilder sb = new StringBuilder();
MyStringWriterWithEncoding sw = new MyStringWriterWithEncoding(sb, System.Text.Encoding.UTF8);
serializer.Serialize(sw, report);
string sxml = sb.ToString();
xmldoc.LoadXml(sxml);

Here is a link to the ReportDefinition.cs class:

ReportDefinition on google docs

Convert c++ bool to .NET bool

2009-10-13T11:43:00.003+02:00

Be careful when you work with Interop and you call functions written in C++ returning bool.
In c++ the bool type is managed with one byte, in .Net Framework the bool type is managed with 4bytes(32bit).

So if you have a c++ api like this:

extern "C" bool GetBoolStatusFromC();

and a definition in the c# code like this:

[DllImport("myOldCpp.dll", CharSet = CharSet.Unicode)]
extern public static bool GetBoolStatusFromC();

You could have strange results, sometimes you receive true sometimes you receive false without a clear logic.

When the C++ bool is returned it is stored with one byte in AL and it is mapped to the EAX registy that is 4 bytes replacing only the last byte.
The other 24 bits remains dirty and they should contains values from other system calls that works with the EAX register.
So, the dirty 24 bytes causes random C# bool values, without control.

The solution is:

- decorate the PInvoke declaration with [return:MarshalAs(UnmanagedType.I1)]
- change the c++ declaration and use INT as return value.

Hope it helps,

This post contains 2610 Errors - Windows errors complete list

2009-08-04T14:07:00.006+02:00

Windows errors complete list from 0 (zero) to 15301, extracted from MSDN pages, includes wininet.h errors.
This is a good reference for writing custom error messages in your apps.

Complete List is here:
https://docs.google.com/leaf?id=0B_zNfBEu90AINjFlZmIwNTgtOTg3Ni00YzJmLWIyMjUtMTdhMjk5YTdlMDdm&hl=it

ERROR_SUCCESS
0 (0x0) The operation completed successfully.

ERROR_INVALID_FUNCTION
1 (0x1) Incorrect function.

ERROR_FILE_NOT_FOUND
2 (0x2) The system cannot find the file specified.

ERROR_PATH_NOT_FOUND
3 (0x3) The system cannot find the path specified.

ERROR_TOO_MANY_OPEN_FILES
4 (0x4) The system cannot open the file.

ERROR_ACCESS_DENIED
5 (0x5) Access is denied.

ERROR_INVALID_HANDLE
6 (0x6) The handle is invalid.

ERROR_ARENA_TRASHED
7 (0x7) The storage control blocks were destroyed.

ERROR_NOT_ENOUGH_MEMORY
8 (0x8) Not enough storage is available to process this command.

ERROR_INVALID_BLOCK
9 (0x9) The storage control block address is invalid.

ERROR_BAD_ENVIRONMENT
10 (0xA) The environment is incorrect.

ERROR_BAD_FORMAT
11 (0xB) An attempt was made to load a program with an incorrect format.

ERROR_INVALID_ACCESS
12 (0xC) The access code is invalid.

ERROR_INVALID_DATA
13 (0xD) The data is invalid.

ERROR_OUTOFMEMORY
14 (0xE) Not enough storage is available to complete this operation.

....

....
ERROR_AMBIGUOUS_SYSTEM_DEVICE
15250 (0x3B92) The requested system device cannot be identified due to multiple indistinguishable devices potentially matching the identification criteria.

ERROR_SYSTEM_DEVICE_NOT_FOUND
15299 (0x3BC3) The requested system device cannot be found.

ERROR_HASH_NOT_SUPPORTED
15300 (0x3BC4) Hash generation for the specified version and hash type is not enabled on server.

ERROR_HASH_NOT_PRESENT
15301 (0x3BC5) The hash requests is not present or not up to date with the current file contents.

.net DateTime and Currency Format Samples

2009-06-30T16:06:00.002+02:00

While using different languages in .net, comparison between datetime and currency formats is sometimes useful, here are some examples in all the .net culture info. Date time/currency default formats in .NET Framework
Code	Language Name	Now.ToString	Currency.ToString
	Invariant Language (Invariant Country)	06/30/2009 16:32:32	¤1,000.23
af	Afrikaans	2009/06/30 04:32:32 nm	R 1,000.23
af-ZA	Afrikaans (South Africa)	2009/06/30 04:32:32 nm	R 1,000.23
am-ET	Amharic (Ethiopia)	30/6/2009 4:32:32 ከሰዓት	ETB1,000.23
ar	Arabic	07/07/30 04:32:32 م	ر.س.‏ 1,000.23
ar-AE	Arabic (U.A.E.)	30/06/2009 04:32:32 م	د.إ.‏ 1,000.23
ar-BH	Arabic (Bahrain)	30/06/2009 04:32:32 م	د.ب.‏ 1,000.234
ar-DZ	Arabic (Algeria)	30-06-2009 16:32:32	د.ج.‏ 1,000.23
ar-EG	Arabic (Egypt)	30/06/2009 04:32:32 م	ج.م.‏ 1,000.234
ar-IQ	Arabic (Iraq)	30/06/2009 04:32:32 م	د.ع.‏ 1,000.23
ar-JO	Arabic (Jordan)	30/06/2009 04:32:32 م	د.ا.‏ 1,000.234
ar-KW	Arabic (Kuwait)	30/06/2009 04:32:32 م	د.ك.‏ 1,000.234
ar-LB	Arabic (Lebanon)	30/06/2009 04:32:32 م	ل.ل.‏ 1,000.23
ar-LY	Arabic (Libya)	30/06/2009 04:32:32 م	د.ل.‏ 1,000.23
ar-MA	Arabic (Morocco)	30-06-2009 16:32:32	د.م.‏ 1,000.23
arn-CL	Mapudungun (Chile)	30-06-2009 16:32:32	$ 1.000,23
ar-OM	Arabic (Oman)	30/06/2009 04:32:32 م	ر.ع.‏ 1,000.23
ar-QA	Arabic (Qatar)	30/06/2009 04:32:32 م	ر.ق.‏ 1,000.23
ar-SA	Arabic (Saudi Arabia)	07/07/30 04:32:32 م	ر.س.‏ 1,000.23
ar-SY	Arabic (Syria)	30/06/2009 04:32:32 م	ل.س.‏ 1,000.23
ar-TN	Arabic (Tunisia)	30-06-2009 16:32:32	د.ت.‏ 1,000.234
ar-YE	Arabic (Yemen)	30/06/2009 04:32:32 م	ر.ي.‏ 1,000.23
as-IN	Assamese (India)	30-06-2009 আবেলি 4:32:32	1,000.23ট
az	Azeri	30.06.2009 16:32:32	1 000,23 man.
az-Cyrl-AZ	Azeri (Cyrillic, Azerbaijan)	30.06.2009 16:32:32	1 000,23 ман.
az-Latn-AZ	Azeri (Latin, Azerbaijan)	30.06.2009 16:32:32	1 000,23 man.
ba-RU	Bashkir (Russia)	30.06.09 16:32:32	1 000,23 һ.
be	Belarusian	30.06.2009 16:32:32	1 000,23 р.
be-BY	Belarusian (Belarus)	30.06.2009 16:32:32	1 000,23 р.
bg	Bulgarian	30.6.2009 г. 16:32:32	1 000,23 лв
bg-BG	Bulgarian (Bulgaria)	30.6.2009 г. 16:32:32	1 000,23 лв
bn-BD	Bengali (Bangladesh)	30-06-09 16.32.32	৳ 1,000.23
bn-IN	Bengali (India)	30-06-09 16.32.32	টা 1,000.23
bo-CN	Tibetan (People's Republic of China)	2009/6/30 16:32:32	¥1,000.23
br-FR	Breton (France)	30/06/2009 16:32:32	1 000,23 €
bs-Cyrl-BA	Bosnian (Cyrillic) (Bosnia and Herzegovina)	30.6.2009 16:32:32	1.000,23 КМ
bs-Latn-BA	Bosnian (Latin) (Bosnia and Herzegovina)	30.6.2009 16:32:32	1.000,23 KM
ca	Catalan	30/06/2009 16:32:32	1.000,23 €
ca-ES	Catalan (Catalan)	30/06/2009 16:32:32	1.000,23 €
co-FR	Corsican (France)	30/06/2009 16:32:32	1 000,23 €
cs	Czech	30.6.2009 16:32:32	1 000,23 Kč
cs-CZ	Czech (Czech Republic)	30.6.2009 16:32:32	1 000,23 Kč
cy-GB	Welsh (United Kingdom)	30/06/2009 16:32:32	£1,000.23
da	Danish	30-06-2009 16:32:32	kr 1.000,23
da-DK	Danish (Denmark)	30-06-2009 16:32:32	kr 1.000,23
de	German	30.06.2009 16:32:32	1.000,23 €
de-AT	German (Austria)	30.06.2009 16:32:32	€ 1.000,23
de-CH	German (Switzerland)	30.06.2009 16:32:32	SFr. 1'000.23
de-DE	German (Germany)	30.06.2009 16:32:32	1.000,23 €
de-LI	German (Liechtenstein)	30.06.2009 16:32:32	CHF 1'000.23
de-LU	German (Luxembourg)	30.06.2009 16:32:32	1.000,23 €
dsb-DE	Lower Sorbian (Germany)	30. 6. 2009 16:32:32	1.000,23 €
dv	Divehi	08/07/30 16:32:32	1,000.23 ރ.
dv-MV	Divehi (Maldives)	08/07/30 16:32:32	1,000.23 ރ.
el	Greek	30/6/2009 4:32:32 μμ	1.000,23 €
el-GR	Greek (Greece)	30/6/2009 4:32:32 μμ	1.000,23 €
en	English	6/30/2009 4:32:32 PM	$1,000.23
en-029	English (Caribbean)	06/30/2009 4:32:32 PM	$1,000.23
en-AU	English (Australia)	30/06/2009 4:32:32 PM	$1,000.23
en-BZ	English (Belize)	30/06/2009 04:32:32 PM	BZ$1,000.23
en-CA	English (Canada)	30/06/2009 4:32:32 PM	$1,000.23
en-GB	English (United Kingdom)	30/06/2009 16:32:32	£1,000.23
en-IE	English (Ireland)	30/06/2009 16:32:32	€1,000.23
en-IN	English (India)	30-06-2009 16:32:32	Rs. 1,000.23
en-JM	English (Jamaica)	30/06/2009 04:32:32 PM	J$1,000.23
en-MY	English (Malaysia)	30/6/2009 4:32:32 PM	RM1,000.23
en-NZ	English (New Zealand)	30/06/2009 4:32:32 p.m.	$1,000.23
en-PH	English (Republic of the Philippines)	6/30/2009 4:32:32 PM	Php1,000.23
en-SG	English (Singapore)	30/6/2009 4:32:32 PM	$1,000.23
en-TT	English (Trinidad and Tobago)	30/06/2009 04:32:32 PM	TT$1,000.23
en-US	English (United States)	6/30/2009 4:32:32 PM	$1,000.23
en-ZA	English (South Africa)	2009/06/30 04:32:32 PM	R 1,000.23
en-ZW	English (Zimbabwe)	6/30/2009 4:32:32 PM	Z$1,000.23
es	Spanish	30/06/2009 16:32:32	1.000,23 €
es-AR	Spanish (Argentina)	30/06/2009 04:32:32 p.m.	$ 1.000,23
es-BO	Spanish (Bolivia)	30/06/2009 04:32:32 p.m.	$b 1.000,23
es-CL	Spanish (Chile)	30-06-2009 16:32:32	$ 1.000,23
es-CO	Spanish (Colombia)	30/06/2009 04:32:32 p.m.	$ 1.000,23
es-CR	Spanish (Costa Rica)	30/06/2009 04:32:32 p.m.	₡1.000,23
es-DO	Spanish (Dominican Republic)	30/06/2009 04:32:32 p.m.	RD$1,000.23
es-EC	Spanish (Ecuador)	30/06/2009 16:32:32	$ 1.000,23
es-ES	Spanish (Spain)	30/06/2009 16:32:32	1.000,23 €
es-GT	Spanish (Guatemala)	30/06/2009 04:32:32 p.m.	Q1,000.23
es-HN	Spanish (Honduras)	30/06/2009 04:32:32 p.m.	L. 1,000.23
es-MX	Spanish (Mexico)	30/06/2009 04:32:32 p.m.	$1,000.23
es-NI	Spanish (Nicaragua)	30/06/2009 04:32:32 p.m.	C$ 1,000.23
es-PA	Spanish (Panama)	06/30/2009 04:32:32 p.m.	B/. 1,000.23
es-PE	Spanish (Peru)	30/06/2009 04:32:32 p.m.	S/. 1,000.23
es-PR	Spanish (Puerto Rico)	30/06/2009 04:32:32 p.m.	$ 1,000.23
es-PY	Spanish (Paraguay)	30/06/2009 04:32:32 p.m.	Gs 1.000,23
es-SV	Spanish (El Salvador)	30/06/2009 04:32:32 p.m.	$1,000.23
es-US	Spanish (United States)	6/30/2009 4:32:32 PM	$1,000.23
es-UY	Spanish (Uruguay)	30/06/2009 04:32:32 p.m.	$U 1.000,23
es-VE	Spanish (Venezuela)	30/06/2009 04:32:32 p.m.	Bs 1.000,23
et	Estonian	30.06.2009 16:32:32	1 000.23 kr
et-EE	Estonian (Estonia)	30.06.2009 16:32:32	1 000.23 kr
eu	Basque	2009/06/30 16:32:32	1.000,23 €
eu-ES	Basque (Basque)	2009/06/30 16:32:32	1.000,23 €
fa	Persian	06/30/2009 04:32:32 ب.ظ	ريال 1,000/23
fa-IR	Persian (Iran)	06/30/2009 04:32:32 ب.ظ	ريال 1,000/23
fi	Finnish	30.6.2009 16:32:32	1 000,23 €
fi-FI	Finnish (Finland)	30.6.2009 16:32:32	1 000,23 €
fil-PH	Filipino (Philippines)	6/30/2009 4:32:32 PM	PhP1,000.23
fo	Faroese	30-06-2009 16.32.32	kr 1.000,23
fo-FO	Faroese (Faroe Islands)	30-06-2009 16.32.32	kr 1.000,23
fr	French	30/06/2009 16:32:32	1 000,23 €
fr-BE	French (Belgium)	30/06/2009 16:32:32	€ 1.000,23
fr-CA	French (Canada)	2009-06-30 16:32:32	1 000,23 $
fr-CH	French (Switzerland)	30.06.2009 16:32:32	SFr. 1'000.23
fr-FR	French (France)	30/06/2009 16:32:32	1 000,23 €
fr-LU	French (Luxembourg)	30/06/2009 16:32:32	1 000,23 €
fr-MC	French (Principality of Monaco)	30/06/2009 16:32:32	1 000,23 €
fy-NL	Frisian (Netherlands)	30-6-2009 16:32:32	€ 1.000,23
ga-IE	Irish (Ireland)	30/06/2009 16:32:32	€1,000.23
gl	Galician	30/06/09 16:32:32	1.000,23 €
gl-ES	Galician (Galician)	30/06/09 16:32:32	1.000,23 €
gsw-FR	Alsatian (France)	30/06/2009 16:32:32	1 000,23 €
gu	Gujarati	30-06-09 16:32:32	રૂ 1,000.23
gu-IN	Gujarati (India)	30-06-09 16:32:32	રૂ 1,000.23
ha-Latn-NG	Hausa (Latin) (Nigeria)	30/6/2009 4:32:32 Yamma	N 1,000.23
he	Hebrew	30/06/2009 16:32:32	₪ 1,000.23
he-IL	Hebrew (Israel)	30/06/2009 16:32:32	₪ 1,000.23
hi	Hindi	30-06-2009 16:32:32	रु 1,000.23
hi-IN	Hindi (India)	30-06-2009 16:32:32	रु 1,000.23
hr	Croatian	30.6.2009 16:32:32	1.000,23 kn
hr-BA	Croatian (Latin) (Bosnia and Herzegovina)	30.6.2009 16:32:32	1.000,23 KM
hr-HR	Croatian (Croatia)	30.6.2009 16:32:32	1.000,23 kn
hsb-DE	Upper Sorbian (Germany)	30. 6. 2009 16:32:32	1.000,23 €
hu	Hungarian	2009. 06. 30. 16:32:32	1 000,23 Ft
hu-HU	Hungarian (Hungary)	2009. 06. 30. 16:32:32	1 000,23 Ft
hy	Armenian	30.06.2009 16:32:32	1,000.23 դր.
hy-AM	Armenian (Armenia)	30.06.2009 16:32:32	1,000.23 դր.
id	Indonesian	30/06/2009 16:32:32	Rp1.000
id-ID	Indonesian (Indonesia)	30/06/2009 16:32:32	Rp1.000
ig-NG	Igbo (Nigeria)	30/6/2009 4:32:32 Efifie	N 1,000.23
ii-CN	Yi (People's Republic of China)	2009/6/30 16:32:32	¥1,000.23
is	Icelandic	30.6.2009 16:32:32	1.000 kr.
is-IS	Icelandic (Iceland)	30.6.2009 16:32:32	1.000 kr.
it	Italian	2009-06-30 16:32	€ 1.000,23
it-CH	Italian (Switzerland)	30.06.2009 16:32:32	SFr. 1'000.23
it-IT	Italian (Italy)	2009-06-30 16:32	€ 1.000,23
iu-Cans-CA	Inuktitut (Canada)	30/6/2009 4:32:32 PM	$1,000.23
iu-Latn-CA	Inuktitut (Latin) (Canada)	30/06/2009 4:32:32 PM	$1,000.23
ja	Japanese	2009/06/30 16:32:32	¥1,000
ja-JP	Japanese (Japan)	2009/06/30 16:32:32	¥1,000
ka	Georgian	30.06.2009 16:32:32	1 000,23 Lari
ka-GE	Georgian (Georgia)	30.06.2009 16:32:32	1 000,23 Lari
kk	Kazakh	30.06.2009 16:32:32	Т1 000-23
kk-KZ	Kazakh (Kazakhstan)	30.06.2009 16:32:32	Т1 000-23
kl-GL	Greenlandic (Greenland)	30-06-2009 16:32:32	kr. 1.000,23
km-KH	Khmer (Cambodia)	2009-06-30 16:32:32	1,000.23៛
kn	Kannada	30-06-09 16:32:32	ರೂ 1,000.23
kn-IN	Kannada (India)	30-06-09 16:32:32	ರೂ 1,000.23
ko	Korean	2009-06-30 오후 4:32:32	₩1,000
kok	Konkani	30-06-2009 16:32:32	रु 1,000.23
kok-IN	Konkani (India)	30-06-2009 16:32:32	रु 1,000.23
ko-KR	Korean (Korea)	2009-06-30 오후 4:32:32	₩1,000
ky	Kyrgyz	30.06.09 16:32:32	1 000-23 сом
ky-KG	Kyrgyz (Kyrgyzstan)	30.06.09 16:32:32	1 000-23 сом
lb-LU	Luxembourgish (Luxembourg)	30/06/2009 16:32:32	1 000,23 €
lo-LA	Lao (Lao P.D.R.)	30/06/2009 16:32:32	1,000.23₭
lt	Lithuanian	2009.06.30 16:32:32	1.000,23 Lt
lt-LT	Lithuanian (Lithuania)	2009.06.30 16:32:32	1.000,23 Lt
lv	Latvian	2009.06.30. 16:32:32	Ls 1 000,23
lv-LV	Latvian (Latvia)	2009.06.30. 16:32:32	Ls 1 000,23
mi-NZ	Maori (New Zealand)	30/06/2009 4:32:32 p.m.	$1,000.23
mk	Macedonian	30.06.2009 16:32:32	1.000,23 ден.
mk-MK	Macedonian (Former Yugoslav Republic of Macedonia)	30.06.2009 16:32:32	1.000,23 ден.
ml-IN	Malayalam (India)	30-06-09 16.32.32	ക 1,000.23
mn	Mongolian	09.06.30 16:32:32	1 000,23₮
mn-MN	Mongolian (Cyrillic, Mongolia)	09.06.30 16:32:32	1 000,23₮
mn-Mong-CN	Mongolian (Traditional Mongolian) (People's Republic of China)	2009/6/30 ᠬᠤᠢᠢᠨᠠᠬᠢ 4:32:32	¥1,000.23
moh-CA	Mohawk (Canada)	6/30/2009 4:32:32 PM	$1,000.23
mr	Marathi	30-06-2009 16:32:32	रु 1,000.23
mr-IN	Marathi (India)	30-06-2009 16:32:32	रु 1,000.23
ms	Malay	30/06/2009 16:32:32	R1.000
ms-BN	Malay (Brunei Darussalam)	30/06/2009 16:32:32	$1.000
ms-MY	Malay (Malaysia)	30/06/2009 16:32:32	R1.000
mt-MT	Maltese (Malta)	30/06/2009 16:32:32	Lm1,000.23
nb-NO	Norwegian, Bokmål (Norway)	30.06.2009 16:32:32	kr 1 000,23
ne-NP	Nepali (Nepal)	6/30/2009 4:32:32 बेलुकी	रु1,000.23
nl	Dutch	30-6-2009 16:32:32	€ 1.000,23
nl-BE	Dutch (Belgium)	30/06/2009 16:32:32	€ 1.000,23
nl-NL	Dutch (Netherlands)	30-6-2009 16:32:32	€ 1.000,23
nn-NO	Norwegian, Nynorsk (Norway)	30.06.2009 16:32:32	kr 1 000,23
no	Norwegian	30.06.2009 16:32:32	kr 1 000,23
nso-ZA	Sesotho sa Leboa (South Africa)	2009/06/30 04:32:32 PM	R 1,000.23
oc-FR	Occitan (France)	30/06/2009 16:32:32	1 000,23 €
or-IN	Oriya (India)	30-06-09 16:32:32	ଟ 1,000.23
pa	Punjabi	30-06-09 ਸ਼ਾਮ 04:32:32	ਰੁ 1,000.23
pa-IN	Punjabi (India)	30-06-09 ਸ਼ਾਮ 04:32:32	ਰੁ 1,000.23
pl	Polish	2009-06-30 16:32:32	1 000,23 zł
pl-PL	Polish (Poland)	2009-06-30 16:32:32	1 000,23 zł
prs-AF	Dari (Afghanistan)	08/07/30 4:32 غ.و	؋1,000.23
ps-AF	Pashto (Afghanistan)	08/07/30 4:32 غ.و	؋1٬000٫23
pt	Portuguese	30/6/2009 16:32:32	R$ 1.000,23
pt-BR	Portuguese (Brazil)	30/6/2009 16:32:32	R$ 1.000,23
pt-PT	Portuguese (Portugal)	30-06-2009 16:32:32	1.000,23 €
qut-GT	K'iche (Guatemala)	30/06/2009 04:32:32 p.m.	Q1,000.23
quz-BO	Quechua (Bolivia)	30/06/2009 04:32:32 p.m.	$b 1.000,23
quz-EC	Quechua (Ecuador)	30/06/2009 16:32:32	$ 1.000,23
quz-PE	Quechua (Peru)	30/06/2009 04:32:32 p.m.	S/. 1,000.23
rm-CH	Romansh (Switzerland)	30/06/2009 16:32:32	fr. 1'000.23
ro	Romanian	30.06.2009 16:32:32	1.000,23 lei
ro-RO	Romanian (Romania)	30.06.2009 16:32:32	1.000,23 lei
ru	Russian	30.06.2009 16:32:32	1 000,23р.
ru-RU	Russian (Russia)	30.06.2009 16:32:32	1 000,23р.
rw-RW	Kinyarwanda (Rwanda)	6/30/2009 4:32:32 saa moya z.n.	RWF 1 000,23
sa	Sanskrit	30-06-2009 16:32:32	रु 1,000.23
sah-RU	Yakut (Russia)	06.30.2009 16:32:32	1 000,23с.
sa-IN	Sanskrit (India)	30-06-2009 16:32:32	रु 1,000.23
se-FI	Sami (Northern) (Finland)	30.6.2009 16:32:32	1 000,23 €
se-NO	Sami (Northern) (Norway)	30.06.2009 16:32:32	kr 1 000,23
se-SE	Sami (Northern) (Sweden)	2009-06-30 16:32:32	1.000,23 kr
si-LK	Sinhala (Sri Lanka)	2009-06-30 4:32:32 ප.ව.	රු. 1,000.23
sk	Slovak	30. 6. 2009 16:32:32	1 000,23 Sk
sk-SK	Slovak (Slovakia)	30. 6. 2009 16:32:32	1 000,23 Sk
sl	Slovenian	30.6.2009 16:32:32	1.000,23 SIT
sl-SI	Slovenian (Slovenia)	30.6.2009 16:32:32	1.000,23 SIT
sma-NO	Sami (Southern) (Norway)	30.06.2009 16:32:32	kr 1 000,23
sma-SE	Sami (Southern) (Sweden)	2009-06-30 16:32:32	1.000,23 kr
smj-NO	Sami (Lule) (Norway)	30.06.2009 16:32:32	kr 1 000,23
smj-SE	Sami (Lule) (Sweden)	2009-06-30 16:32:32	1.000,23 kr
smn-FI	Sami (Inari) (Finland)	30.6.2009 16:32:32	1 000,23 €
sms-FI	Sami (Skolt) (Finland)	30.6.2009 16:32:32	1 000,23 €
sq	Albanian	2009-06-30 4:32:32.MD	1.000,23Lek
sq-AL	Albanian (Albania)	2009-06-30 4:32:32.MD	1.000,23Lek
sr	Serbian	30.6.2009 16:32:32	1.000,23 Din.
sr-Cyrl-BA	Serbian (Cyrillic) (Bosnia and Herzegovina)	30.6.2009 16:32:32	1.000,23 КМ
sr-Cyrl-CS	Serbian (Cyrillic, Serbia)	30.6.2009 16:32:32	1.000,23 Дин.
sr-Latn-BA	Serbian (Latin) (Bosnia and Herzegovina)	30.6.2009 16:32:32	1.000,23 KM
sr-Latn-CS	Serbian (Latin, Serbia)	30.6.2009 16:32:32	1.000,23 Din.
sv	Swedish	2009-06-30 16:32:32	1.000,23 kr
sv-FI	Swedish (Finland)	30.6.2009 16:32:32	1 000,23 €
sv-SE	Swedish (Sweden)	2009-06-30 16:32:32	1.000,23 kr
sw	Kiswahili	6/30/2009 4:32:32 PM	S1,000.23
sw-KE	Kiswahili (Kenya)	6/30/2009 4:32:32 PM	S1,000.23
syr	Syriac	30/06/2009 04:32:32 ܒ.ܛ	ل.س.‏ 1,000.23
syr-SY	Syriac (Syria)	30/06/2009 04:32:32 ܒ.ܛ	ل.س.‏ 1,000.23
ta	Tamil	30-06-2009 16:32:32	ரூ 1,000.23
ta-IN	Tamil (India)	30-06-2009 16:32:32	ரூ 1,000.23
te	Telugu	30-06-09 16:32:32	రూ 1,000.23
te-IN	Telugu (India)	30-06-09 16:32:32	రూ 1,000.23
tg-Cyrl-TJ	Tajik (Cyrillic) (Tajikistan)	30.06.09 16:32:32	1 000;23 т.р.
th	Thai	30/6/2552 16:32:32	฿1,000.23
th-TH	Thai (Thailand)	30/6/2552 16:32:32	฿1,000.23
tk-TM	Turkmen (Turkmenistan)	30.06.09 16:32:32	1 000,23m.
tn-ZA	Setswana (South Africa)	2009/06/30 04:32:32 PM	R 1,000.23
tr	Turkish	30.06.2009 16:32:32	1.000,23 YTL
tr-TR	Turkish (Turkey)	30.06.2009 16:32:32	1.000,23 YTL
tt	Tatar	30.06.2009 16:32:32	1 000,23 р.
tt-RU	Tatar (Russia)	30.06.2009 16:32:32	1 000,23 р.
tzm-Latn-DZ	Tamazight (Latin) (Algeria)	30-06-2009 16:32:32	1,000.23 DZD
ug-CN	Uighur (People's Republic of China)	2009/6/30 16:32:32	¥1,000.23
uk	Ukrainian	30.06.2009 16:32:32	1 000,23 грн.
uk-UA	Ukrainian (Ukraine)	30.06.2009 16:32:32	1 000,23 грн.
ur	Urdu	30/06/2009 4:32:32 PM	Rs1,000.23
ur-PK	Urdu (Islamic Republic of Pakistan)	30/06/2009 4:32:32 PM	Rs1,000.23
uz	Uzbek	30/06 2009 16:32:32	1 000 su'm
uz-Cyrl-UZ	Uzbek (Cyrillic, Uzbekistan)	30.06.2009 16:32:32	1 000,23 сўм
uz-Latn-UZ	Uzbek (Latin, Uzbekistan)	30/06 2009 16:32:32	1 000 su'm
vi	Vietnamese	30/06/2009 4:32:32 CH	1.000,23 ₫
vi-VN	Vietnamese (Vietnam)	30/06/2009 4:32:32 CH	1.000,23 ₫
wo-SN	Wolof (Senegal)	30/06/2009 16:32:32	1 000,23 XOF
xh-ZA	isiXhosa (South Africa)	2009/06/30 04:32:32 PM	R 1,000.23
yo-NG	Yoruba (Nigeria)	30/6/2009 4:32:32 Ale	N 1,000.23
zh-CN	Chinese (People's Republic of China)	2009/6/30 16:32:32	￥1,000.23
zh-HK	Chinese (Hong Kong S.A.R.)	30/6/2009 16:32:32	HK$1,000.23
zh-MO	Chinese (Macao S.A.R.)	30/6/2009 16:32:32	MOP1,000.23
zh-SG	Chinese (Singapore)	30/6/2009 PM 4:32:32	$1,000.23
zh-TW	Chinese (Taiwan)	2009/6/30 下午 04:32:32	NT$1,000.23
zu-ZA	isiZulu (South Africa)	2009/06/30 04:32:32 PM	R 1,000.23

And here is the code used to generate this table:

DateTime dt = DateTime.Now;
double d = 1000.234;
string sFormat = String.Empty;
CultureInfo[] arCl = CultureInfo.GetCultures(CultureTypes.AllCultures);
SortedDictionary<string, CultureInfo> cl = new SortedDictionary<string, CultureInfo>();
foreach (CultureInfo ci in arCl)
   cl.Add(ci.Name, ci);

SortedDictionary<string, CultureInfo>.Enumerator myenum = cl.GetEnumerator();
do
{
   CultureInfo ci = myenum.Current.Value;
   try
   {
       sFormat = String.Format("<tr><td>{0,-12}</td><td>{1,-40}</td>", ci.Name, ci.EnglishName);
       sFormat += "<td>" + dt.ToString(CultureInfo.CreateSpecificCulture(ci.Name)) + "</td>";
       sFormat += "<td>" + d.ToString("c", CultureInfo.CreateSpecificCulture(ci.Name)) + "</td></tr>\r\n";
   }
   catch
   {
       sFormat = "";
   }
   textBox1.Text += sFormat;
}
while (myenum.MoveNext());

Sito www.idifetti.com

2009-06-29T14:08:00.003+02:00

Ecco un sito sviluppato con DNN (DotNetNuke), integra DNN ed il ASP.net Classified Resource Kit.

http://www.idifetti.com/

Potete registrarvi gratuitamente e segnalare i difetti di oggetti o servizi da voi acquistati.

Buone segnalazioni!

Pubblica post

Disable the message "Rows processed" in Sql Query Analyzer

2009-04-28T15:51:00.005+02:00

Here is how to disable the annoying message "Rows processed: 1" displayed when you execute queries using Sql Query Analyzer:

Th command is :
SET NOCOUNT ON
go

Simple?

Creare shortcut globali su Vista : HoeKey

2009-04-24T10:55:00.002+02:00

Volete creare uno shortcut da tastiera che esegua una ricerca di google con il testo selezionato in una qualsiasi applicazione windows?

Oppure volete creare delle scorciatoie con un numero qualsiasi di caratteri della tastiera?

Tutto questo utilizzando 300Kb di RAM?

Ecco il programma da utilizzare: HoeKey:

http://www.bcheck.net/apps/hoe.htm

Completamente programmabile, ecco un esempio di comandi:

Ed un esempio di parametri:

Ed ecco il comando per eseguire una ricerca con google:

~G=Run|http://www.google.com/search?source=ig&hl=en&rlz=&q=%S&aq=f&oq=;

Esempio:

Tasto + G e..... ecco il risultato:

HOWTO NOT develop a web login page

2009-04-22T09:49:00.004+02:00

Yesterday I was mining some information about bar codes on google, and I found this page:

After some surfing I found a login page:

Damnn... I neeed a password!
Here is the viewsource of the page:

Interesting, the Archivio checks with an ajax service...
Here is the code of the Archivio function:

Uhmmm... flag? Let me find on the upper code....

Ok, now we try one of these flags...:

Bingo! Here is the magical access to the page.

Don't hide the key of your house near the house door..

DOTNETNUKE e JQuery

2009-04-21T17:40:00.002+02:00

Se volete utilizzare JQuery all'interno di DotNetNuke (DNN) potete includere la libreria tra gli script di DNN che vengono caricati da ogni pagina.

Il problema è che DNN utilizza già una funzione javascript chiamata $.

Per poter utilizzare JQuery si deve chiamare la funzione "noConflict" che rimappa la funzione $ su un altro nome.

Ecco un esempio:

<script>
var $$ = jQuery.noConflict();
// jQuery ora è accessibile tramite la funzione $$
alert($$(document));
</script>

Howto Create a SQL Conditional View

2009-04-21T12:46:00.000+02:00

Here is a script on how to create a conditional view based on a parameter

Sometimes things seems simple, this instruction is valid:

if @condition = '1' then

begin

Create Table...

end

Here is the equivalent instruction, where Table is substituted by View:

IF EXISTS (

SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vwTest]') AND OBJECTPROPERTY(id, N'IsView') = 1 )

BEGIN

CREATE VIEW [dbo].[vwTest] AS SELECT * from MYTABLE

END

This command fails with the error:

Messagge 156, livello 15, stato 1, riga 4

Incorrect syntax near the keyword 'VIEW'.

The alternative is to use the “exec” command:

exec N'CREATE VIEW [dbo].[vwTest] AS SELECT * from MYTABLE'

But here is the sad message:

Messagge 102, livello 15, stato 1, riga 1
Incorrect syntax near 'CREATE VIEW [dbo].[vwTest] AS SELECT * from MYTABLE'.

The solution is to use the stored procedure sp_executesql:

sp_executesql N'CREATE VIEW [dbo].[vwTest] AS SELECT * from MYTABLE'

Don’t forget , if you are passing the command using a parameter, to define it as ntext/nchar/nvarchar, here is the strange message if you don’t use this types:

Incorrect syntax near ...

Hope it helps!

Documentazione Local Policies e User Rights Assignment

2009-04-15T14:53:00.002+02:00

Ecco la documentazione MSDN del significato delle "assegnazioni diritti utenti" presenti nei Criteri di protezione locali da windows Xp in poi.

http://technet.microsoft.com/en-us/library/cc780182.aspx

Database size via query

2009-04-15T11:18:00.004+02:00

Here are some usefull Sql commands for space verification on a database:

-- DB space

exec sp_spaceused

--space for a table

exec sp_spaceused 'tablename'

-- databases list

exec sp_databases

-- SQL version

Select @@version

-- All sql server version infos

exec xp_msver

Trace Sql senza Profiler e senza installazione di software aggiuntivo

2009-02-06T14:18:00.003+01:00

Ecco come effettuare il trace dell'attività SQL su un SQl server in cui non è disponibile il SQL profiler.

Gli script sono tratti dal sito
http://www.mssqltips.com/tip.asp?tip=1035

Il trace creato può essere gestito tramite le seguenti istruzioni:

EXEC sp_trace_setstatus 1, 1 --abilita il trace

EXEC sp_trace_setstatus 1, 0 --disabilita il trace

EXEC sp_trace_setstatus 1, 2 --cancella il trace e salva su file

--numero trace attive:

SELECT * FROM :: fn_trace_getinfo(default)

--importazione in una tabella del file di trace

drop table sqlTableToLoad

SELECT * INTO sqlTableToLoad

FROM ::fn_trace_gettable(N'c:\TestTrace.trc', DEFAULT)

--query varie

select * from sqlTableToLoad where textdata like '%select%'

select * from sqlTableToLoad where textdata like '%Chiamate%'

/***************************************************************/

-- abilitazione trace

-- da errore -12 se il file c:\TestTrace.trc non è stato eliminato

/**************************************************************/

-- Declare variables

DECLARE @rc INT

DECLARE @TraceID INT

DECLARE @maxFileSize bigint

DECLARE @fileName NVARCHAR(128)

DECLARE @on bit

-- Set values

SET @maxFileSize = 5

SET @fileName = N'C:\TestTrace'

SET @on = 1

-- Create trace

EXEC @rc = sp_trace_create @TraceID output, 0, @fileName, @maxFileSize, NULL

-- If error end process

IF (@rc != 0) GOTO error

-- Set the events and data to collect

EXEC sp_trace_setevent @TraceID, 45, 1, @on

EXEC sp_trace_setevent @TraceID, 45, 12, @on

EXEC sp_trace_setevent @TraceID, 45, 13, @on

EXEC sp_trace_setevent @TraceID, 45, 14, @on

EXEC sp_trace_setevent @TraceID, 45, 15, @on

EXEC sp_trace_setevent @TraceID, 45, 16, @on

EXEC sp_trace_setevent @TraceID, 45, 17, @on

EXEC sp_trace_setevent @TraceID, 10, 1, @on

EXEC sp_trace_setevent @TraceID, 10, 12, @on

EXEC sp_trace_setevent @TraceID, 10, 13, @on

EXEC sp_trace_setevent @TraceID, 10, 14, @on

EXEC sp_trace_setevent @TraceID, 10, 15, @on

EXEC sp_trace_setevent @TraceID, 10, 16, @on

EXEC sp_trace_setevent @TraceID, 10, 17, @on

EXEC sp_trace_setevent @TraceID, 12, 1, @on

EXEC sp_trace_setevent @TraceID, 12, 2, @on

EXEC sp_trace_setevent @TraceID, 12, 3, @on

EXEC sp_trace_setevent @TraceID, 12, 4, @on

EXEC sp_trace_setevent @TraceID, 12, 5, @on

EXEC sp_trace_setevent @TraceID, 12, 6, @on

EXEC sp_trace_setevent @TraceID, 12, 7, @on

EXEC sp_trace_setevent @TraceID, 12, 8, @on

EXEC sp_trace_setevent @TraceID, 12, 9, @on

EXEC sp_trace_setevent @TraceID, 12, 10, @on

EXEC sp_trace_setevent @TraceID, 12, 11, @on

EXEC sp_trace_setevent @TraceID, 12, 12, @on

EXEC sp_trace_setevent @TraceID, 12, 13, @on

EXEC sp_trace_setevent @TraceID, 12, 14, @on

EXEC sp_trace_setevent @TraceID, 12, 15, @on

EXEC sp_trace_setevent @TraceID, 12, 16, @on

EXEC sp_trace_setevent @TraceID, 12, 17, @on

-- Set Filters

-- filter1 include databaseId = 6

--EXEC sp_trace_setfilter @TraceID, 3, 1, 0, 6

-- filter2 exclude application SQL Profiler

EXEC sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'

-- Start the trace

EXEC sp_trace_setstatus @TraceID, 1

-- display trace id for future references

SELECT TraceID=@TraceID

GOTO finish

-- error trap

error:

SELECT ErrorCode=@rc

-- exit

finish:

/*******************************************************/

Sql server datetime format

2009-01-02T21:57:00.006+01:00

Sometimes is useful to get on SQL server clean date time values, without the hh:mm:ss, here are the examples starting from a simple GetDate().

For example you may need the date of the first day of the week or of the first day of the month.Here is how to get these values:

select getdate()
today date with hour
Output: 2008-02-14 17:31:13.727

select DATEADD(dd, DATEDIFF(d,0,getdate()), 0)
today
Starting:2008-02-14 17:31:13.727
Output: 2008-02-14 00:00:00.000

select DATEADD(dd, DATEDIFF(d,-1,getdate()), 0)
tomorrow
Starting:2008-02-14 17:31:13.727
Output: 2008-02-15 00:00:00.000

select DATEADD(dd, DATEDIFF(d,2,getdate()), 0)
yesterday
Starting:2008-02-14 17:31:13.727
Output: 2008-02-12 00:00:00.000

select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)this month
Starting:2008-02-14 17:31:13.727
Output: 2008-02-01 00:00:00.000

select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)monday
Starting:2008-02-14 17:31:13.727
Output: 2008-02-11 00:00:00.000

select dateadd(wk,-1,DATEADD(wk, DATEDIFF(wk,0,getdate()),0))
last week
Starting:2008-02-14 17:31:13.727
Output: 2008-02-04 00:00:00.000

select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
this year
Starting:2008-02-14 17:31:13.727
Output: 2008-01-01 00:00:00.000

select dateadd(m,-1,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))
1 month ago
Starting:2008-02-14 17:31:13.727
Output: 2008-01-01 00:00:00.000

select dateadd(m,-6,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))
6 months ago
Starting:2008-02-14 17:31:13.727
Output: 2007-08-01 00:00:00.000

Hope it helps,

Matteo

Sql server kill active connections

2008-12-03T15:42:00.003+01:00

Here is a good TSQL query that eliminates all the active connections.

It's usefull when your code forgets to close the connection object.


SET NOCOUNT ON
DECLARE @spid INT,
@cnt INT,
@sql VARCHAR(255) ,
@dbname varchar(50)

set @dbname = 'mydbname'

SELECT @spid = MIN(spid), @cnt = COUNT(*)
FROM master..sysprocesses
WHERE dbid = DB_ID(@dbname)
AND spid != @@SPID

PRINT 'Starting to KILL '+RTRIM(@cnt)+' processes.'

WHILE @spid IS NOT NULL
BEGIN
PRINT 'About to KILL '+RTRIM(@spid)
SET @sql = 'KILL '+RTRIM(@spid)
EXEC(@sql)
SELECT @spid = MIN(spid), @cnt = COUNT(*)
FROM master..sysprocesses
WHERE dbid = DB_ID(@dbname)
AND spid != @@SPID
PRINT RTRIM(@cnt)+' processes remain.'
END

Found at: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=890339&SiteID=1

dnslookup VS ping : 1-0

2008-05-30T15:25:00.002+02:00

Problema: il ping non sembra risolvere correttamente un indirizzo mentre nslookup è ok.

OPERAZIONI:

Ping miosito.miodominio.it : BAD ADDRESS >> (deve essere un 192.168.1.10)

Nslookup miosito.miodominio.it : OK >> è 192.168.1.10

ipconfig /displaydns: mostra che la cache DNS contiene l’indirizzo sbagliato

ipconfig /flushdns: pulisce la cache dns ma il ping COMUNQUE risponde con l’indirizzo sbagliato

SOLUZIONE:

net stop Dnscache

net start Dnscache

E l’indirizzo viene risolto correttamente!

Nslookup interroga direttamente il server DNS.

Il ping utilizza invece la cache DNs fornita dal servizio Dnscache.

Se il Dnscache si incricca… riavviarlo risolve il problema

La domanda successiva (senza risposta) è:

Perché il servizio DNSCache risolve l’indirizzo utilizzando il DNS secondario (internet) e non quello primario (intranet) ?

Property IsLocked is not available - La proprietà IsLocked non è disponibile

2008-05-20T09:03:00.003+02:00

Sometimes after rebooting the machine with sql server 2005 standars installed I cannot connect using the sa user and I receive an error when I try to manage the user:

"La proprietà IsLocked non è disponibile per Account di accesso 'sa'"

Or, in english:

Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

The only solution is to unlock the sa user using the command:

alter login sa

with password = 'yourpwd' unlock,

check_policy = off,

check_expiration = off

After this all works ok.

For details look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1673143&SiteID=1

Hope it helps,

Matteo

Enable/Disable ASP.NET AJAX Timer using JavaScript

2008-04-15T15:35:00.002+02:00

This function controls an asp.net Timer using Javascript:

var timerServiceStatus = $get('<%= TimerServiceStatus.ClientID %>').control;

timerServiceStatus._startTimer();//Timer start

timerServiceStatus._stopTimer(); //Timer stop

ViewState su Session aka "come risparmiare kbytes al browser"

2008-04-08T17:08:00.001+02:00

Il ViewState di una vostra pagina inizia ad essere un compagno un po’ “ingombrante”?

Il Browser inizia a zoppicare quando deve caricare la vostra pagina?

La prima indicazione è capire perché il ViewState occupa tanto spazio, ma se proprio non potete farne a meno ecco qualche istruzione per spostarlo all’interno della session.

L’esempio è preso da un articolo del MSDN magazine Luglio 2006:

/// FIX X DIMENSIONE VIEWSTATE
/// <summary>
/// Evita caricamento VIEWSTATE nel browser
/// </summary>
/// <returns></returns>

protected override object LoadPageStateFromPersistenceMedium()
{
string key = Request.RawUrl + "_VIEWSTATE";
object state = Session[key];
return (state == null) ?
base.LoadPageStateFromPersistenceMedium() : state;
}

protected override void SavePageStateToPersistenceMedium(object viewState)
{
string key = Request.RawUrl + "_VIEWSTATE";
Session[key] = viewState;
}
/// FINE FIX X DIMENSIONE VIEWSTATE

Free Sql profiler x Sql Express/MSDE

2008-03-28T16:59:00.001+01:00

E’ disponibile sul sito http://code.google.com/p/sqlexpressprofiler/ un profiler sql gratuito che permette di sostituire il sql profiler non incluso in MSDE e SQL Express.

Non richiede setup ed è stato sviluppato in .net.

Enjoy!

Load AppSettings and ConnectionString from an external shared file

2008-03-13T16:13:00.004+01:00

You can share from different .Net applications (web & windows form) the same connection string and the same application configuration without duplicates, you can change the web.config with the code:

</connectionStrings>

You ca do the same to the AppSettings:

</appSettings>

If you are using the EnterpriseLibrary here is the right configuration string:

<section name="enterpriseLibrary.ConfigurationSource" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ConfigurationSourceSection, Microsoft.Practices.EnterpriseLibrary.Common, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> . . . .

And add:

<enterpriseLibrary.ConfigurationSource selectedSource="File Configuration Source">

<add name="File Configuration Source" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.FileConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

filePath="@EnterpriseLib.config" />

</sources>

</enterpriseLibrary.ConfigurationSource>

Hope it helps...

Url Mapping su ASP.NET 2.0

2008-03-13T16:13:00.002+01:00

Ecco come creare degli indirizzi “Virtuali” a cui l’applicazione web può puntare:

  <system.web>
   <urlMappings enabled="true">
   <add url="~/VIRTUALREPORT.aspx" mappedUrl="~/REALPAGE.aspx?VIEW=REPORT" />
   <add url="~/VIRTUALALARM.aspx" mappedUrl="~/ REALPAGE.aspx?VIEW=ALARM" />
   </urlMappings>

Matteo

Sql Server DateTime Format

2008-02-14T17:58:00.002+01:00

A volte su SQL server può essere necessario ricavare alcune date “pulite” dall’orario partendo da un semplice GetDate().

Ad esempio può servire la data del primo giorno della settimana, o del primo giorno del mese ecc.

Ecco un modo abbastanza elegante per ricavare questi dati:

select getdate() --ora iniziale
2008-02-14 17:31:13.727

select DATEADD(dd, DATEDIFF(d,0,getdate()), 0) --oggi
Output: 2008-02-14 00:00:00.000

select DATEADD(dd, DATEDIFF(d,-1,getdate()), 0) --domani
Output: 2008-02-15 00:00:00.000

select DATEADD(dd, DATEDIFF(d,2,getdate()), 0) --ieri
Output: 2008-02-12 00:00:00.000

select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) --mese corr
Output: 2008-02-01 00:00:00.000

select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) --lunedì
Output: 2008-02-11 00:00:00.000

select dateadd(wk,-1,DATEADD(wk, DATEDIFF(wk,0,getdate()),0)) --settimana scorsa
Output: 2008-02-04 00:00:00.000

select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0) --quest'anno
Output: 2008-01-01 00:00:00.000

select dateadd(m,-1,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)) --1 mese fa
Output: 2008-01-01 00:00:00.000

select dateadd(m,-6,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)) --6 mesi fa
Output: 2007-08-01 00:00:00.000

Spero sia utile,

Matteo

ASP.NET 2.0 Sitemap

2008-02-01T01:08:00.003+01:00

Here is a working example of sitemap in asp.net 2.0, remember that the control works in conjunction with web.config location security settings

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0">
<siteMapNode url="~\default.aspx" title="Home" description="" roles="*">
<siteMapNode title="Folder1" description="" url="" roles="*">
<siteMapNode url="~\Page1.aspx" title="Dati Agenzia" description="" roles="Admin" />
<siteMapNode url="~\Page2.aspx" title="Dati Personale" description="" roles="NormalUser"/>
</siteMap>

And here's the settings in web.config:

<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
<providers>
<add name="XmlSiteMapProvider" description="Default SiteMap provider."
type="System.Web.XmlSiteMapProvider " siteMapFile="Web.sitemap" securityTrimmingEnabled="true"/>
</providers>
</siteMap>

Is also important to set the permission on the web.config file, like this:

DropDownList binding to List

2007-11-13T15:25:00.001+01:00

Here is the simplest way to bind an asp.net DropDownList to List<string>:

List<string> list = new List<string>();
list.Add("AAA");
list.Add("BBB");
mydrop.DataSource = list;
myAnno.DataBind();

Little question on sql... Null or not null?

2007-11-08T14:40:00.001+01:00

Executing this TSQL code, what will be the result? "True or False" or "Not defined?"

if 'a' <> null or 'a' = null
print 'true or false!'
else
print 'not defined...!'

Answer: the first condition is neither true nor false, is… undefined.
Don’t compare columns using the ‘= null’ or ‘<> null’, pay attention, the results should be very different from what you expect.
You need to use ‘IS NULL’ and ‘IS NOT NULL’, these are the correct operators for managing null values in Sql server.

if null <> null or null = null
print 'true or false!'
else
print 'not defined...!'

Same story for the above statement, the result is… “Not defined!”

Matteo

">">Site Feed