JQuery - Callback when all AJAX action is finished

JQuery - Callback when all AJAX action is finished

Just to do:

http://api.jquery.com/ajaxStop/

OData - Data query protocol standard

International effort to standardize way data is queried / accessed in web apps.

http://www.odata.org/introduction

Here is another one - free open database WEB API accessible:

http://data.worldbank.org/developers

used here:

http://code.msdn.microsoft.com/Introduction-to-HttpClient-4a2d9cee

UI Mockup tools

I never can't remember where to find them when you quickly need one.
So here it is.
If you only once had short deadline to deliver UI app mockup then you could use some of these.

http://www.c-sharpcorner.com/blogs/6483/top-tools-for-mockups-and-wireframes.aspx

Free online colaboration tool:

https://trello.com/

Representing proper T-SQL string of .NET float & double types

You build a dynamic T-SQL statement in C#.
There is .NET double variable.
You need correct culture independent version of your double variable.
In many European cultures decimal separator is comma and not dot.

So when you pick double value from app.GUI defined by client culture it will be:
1,01

If you inject this in T-SQL statement it is of course invalid.
To workaround this  use InvariantCulture.


var result = 1E-1;
string MysqlDoubleString = Convert.ToString(result, System.Globalization.CultureInfo.InvariantCulture);

Please note that above scenario of building dynamic T-SQL is very risky and unsecure since it is prone to SQL injection attacks.

Always use classic ADO.NET SQLParameter class instead.