Random News Feed

Expression Studio 4 is out and my 60-day tool

I was really excited last Monday after seeing Expression Studio 4 has been released (I have to admit that I'm one of those developers who logged in at MSDN at 12 midnight to check if the RTM bits are already out. hehe). I think this is great news for all XAMLers all over the world. On thing that I'm really sad about though is that our corporate MSDN license only has Expression Studio 4 Professional and not the Ultimate version. Bummed. So I ended up downloading the 60 day trial up until I can figure out how I can get a copy of the full version (OK, here's the part that I ask donations to get a full copy but I'll leave that out. LOL).

Sad, but still happy. At least I have 60 days to enjoy this new tool. ;)




How To: Count the occurrence of a character in a string in SQL

Last night I was trying to cleanup the spammers from the database of devpinoy.org and while I was evaluating the result sets i was able to conclude that aside from using common spam text like 'cheap', 'buy', 'free', 'deal', 'viagra', 'prozac' that 30% of the false emails that spam accounts are using multiple dots on their email address. A good example is a subset below from the list of offenders that I found in the devpinoy db.


Having found that fact I immediately created a sql script that will delete users from the database if they have more than 2 dots in their email address.

Enough with the side note and here is some code.



DECLARE @string2check varchar(50) DECLARE @character2find char SET @string2check
= 'this
is a very long string' SET @character2find
= 'i' PRINT LEN(@string2check)
- LEN(REPLACE(@string2check,
@character2find, ''))


What the code above is doing is that it is removing the characters that matched our search key and then subracts the length of that string to the original string to find the total occurrence of the character we are looking for.

Now, if you want to use this as a function you can use this:



CREATE FUNCTION udf_CountCharOccurence
(    @string2check varchar(500)
,    @character2find char )RETURNS INT BEGIN RETURN (LEN(@string2check)
- LEN(REPLACE(
                                @string2check,
@character2find)                                         )
                                ) END GO

The code above works great but there's a catch. If you are concerned with case sensitivity then the code above wont work. The way around it is to use COLLATION which is supported by the SQL function below:



CREATE FUNCTION udf_CountCharOccurenceCaseSensitive
(    @string2check varchar(500)
,    @character2find char )RETURNS INT BEGIN RETURN (LEN(@string2check)
- LEN(REPLACE(
                                @string2check COLLATE SQL_Latin1_General_Cp1_CS_AS,
@character2find COLLATE SQL_Latin1_General_Cp1_CS_AS, '')
                                        )
                                ) END GO

In order to use this in your query all you need to do is


PRINT dbo.udf_CountCharOccurenceCaseSensitive('This
is a long text','i')

Or if you want to put it to use to meet the criteria that I mentioned about dots on emails you can do it this way:


SELECT * FROM Users WHERE dbo.udf_CountCharOccurenceCaseSensitive(EmailAddress,'.')
> 2


HTH




How To: Change table cell color depending on its value using jQuery

Here's a nifty trick using jQuery on how to iterate on all rows of a table except the first row, how to get the value of a column in the current row being iterated and how to change the table cell color depending on the value it contains.

In this case we wanted to change the color of the 3rd column depending on whether it is higher or lower than the second column. There are two examples in here. The first one is select the table via its ID and the second version is selecting the table based on its class name.



 <script
src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>

<script type="text/javascript"> 


$(document).ready(function()

{ 


//iterate
through all the rows in our table called yourtable


//excluding
the first row because those are column titles


$("#yourtablename
tr:not(:first)").each(function()
{ 




//get
the value of the table cell located


//in
the third column of the current row


var priceYesterday = $(this).find("td:nth-child(2)").html();

var priceToday = $(this).find("td:nth-child(3)").html();



//check
if its greater than zero


if (priceToday
> priceYesterday){

//change
the color of the text to green if its a positive number


$(this).find("td:nth-child(3)").css("color", "#00FF00");

}

else if(priceToday
< priceYesterday){

//change
the color of the text to red if its a negatice number


$(this).find("td:nth-child(3)").css("color", "#FF0000");

}

});



//iterate
through all the rows in our table called yourtable


//excluding
the first row because those are column titles


$(".yourtableclassname
tr:not(:first)").each(function()
{ 




//get
the value of the table cell located


//in
the third column of the current row


var priceYesterday = $(this).find("td:nth-child(2)").html();

var priceToday = $(this).find("td:nth-child(3)").html();



//check
if its greater than zero


if (priceToday
> priceYesterday){

//change
the color of the text to green if its a positive number


$(this).find("td:nth-child(3)").css("color", "#00FF00");

}

else if(priceToday
< priceYesterday){

//change
the color of the text to red if its a negatice number


$(this).find("td:nth-child(3)").css("color", "#FF0000");

}

});



});

</script>

Below is the full source for this sample:



Iterating to the table via table id

Product Name	Yesterday	Today
Egg	1.95	2.10
Sugar	1.92	1.88
Milk	1.95	1.97
beans	3.15	3.06

Iterating to the table via class name

Product Name	Yesterday	Today
Egg	1.95	2.10
Sugar	1.92	1.88
Milk	1.95	1.97
beans	3.15	3.06




<html>

<head>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>

<script type="text/javascript"> 


$(document).ready(function()

{ 


//iterate
through all the rows in our table called yourtable


//excluding
the first row because those are column titles


$("#yourtablename
tr:not(:first)").each(function() { 




//get
the value of the table cell located


//in
the third column of the current row


var priceYesterday = $(this).find("td:nth-child(2)").html();

var priceToday = $(this).find("td:nth-child(3)").html();



//check
if its greater than zero


if (priceToday
> priceYesterday){

//change
the color of the text to green if its a positive number


$(this).find("td:nth-child(3)").css("color", "#00FF00");

}

else if(priceToday
< priceYesterday){

//change
the color of the text to red if its a negatice number


$(this).find("td:nth-child(3)").css("color", "#FF0000");

}

});



//iterate
through all the rows in our table called yourtable


//excluding
the first row because those are column titles


$(".yourtableclassname
tr:not(:first)").each(function() { 




//get
the value of the table cell located


//in
the third column of the current row


var priceYesterday = $(this).find("td:nth-child(2)").html();

var priceToday = $(this).find("td:nth-child(3)").html();



//check
if its greater than zero


if (priceToday
> priceYesterday){

//change
the color of the text to green if its a positive number


$(this).find("td:nth-child(3)").css("color", "#00FF00");

}

else if(priceToday
< priceYesterday){

//change
the color of the text to red if its a negatice number


$(this).find("td:nth-child(3)").css("color", "#FF0000");

}

});



});

</script>

</head>

<body>

<h3>Iterating to the table via table id</h3>

<table id="yourtablename">

<thead>

<tr>

<td>Product Name</td>

<td>Yesterday</td>

<td>Today</td> 


</tr>

</thead>

<tbody>

<tr>

<td>Egg</td>

<td>1.95</td>

<td>2.10</td>

</tr>

<tr>

<td>Sugar</td>

<td>1.92</td>

<td>1.88</td>

</tr> 


<tr>

<td>Milk</td>

<td>1.95</td>

<td>1.97</td>

</tr>

<tr>

<td>beans</td>

<td>3.15</td>

<td>3.06</td>

</tr> 


</tbody>

</table>



<h3>Iterating to the table via class name</h3>

<table class="yourtableclassname">

<thead>

<tr>

<td>Product Name</td>

<td>Yesterday</td>

<td>Today</td> 


</tr>

</thead>

<tbody>

<tr>

<td>Egg</td>

<td>1.95</td>

<td>2.10</td>

</tr>

<tr>

<td>Sugar</td>

<td>1.92</td>

<td>1.88</td>

</tr> 


<tr>

<td>Milk</td>

<td>1.95</td>

<td>1.97</td>

</tr>

<tr>

<td>beans</td>

<td>3.15</td>

<td>3.06</td>

</tr> 


</tbody>

</table>

</body>

</html>

You can copy and paste the code above and put it on a new file to see it running or you can view this sample running here: jquery_change_table_cell_color_depending_on_value.html (3.05 KB)

HTH




How To: Calculate Mathematical Expressions in .NET

Everyday you learn something new. You do. That is if you let yourself to be taught everyday.

I didn't know that you could solve this expression string in .NET in one line of code: "4 + 5 + 10 - 4 / 5 * 2"


using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; namespace KeithRull.SimpleExpressionCalculator
{ class Program
{ static void Main(string[]
args) { string expressionToEvaluate = "4
+ 5 + 10 - 4 / 5 * 2"; var result = new DataTable().Compute(expressionToEvaluate, null);
Console.Write(result); Console.Read(); } } } 

The result is 17.4. Nifty huh? You can also group the expressions to display a clearer evaluation instruction and it still will work.

string expressionToEvaluate = "(((4 + 5) + (10 - 4)) / 5) * 2"; //will result to 6

This is all cool but there's a gotcha. DataTable.Compute() method can only evaluate simple expressions so your

string expressionToEvaluate = "Tan(10) * 2"; //error

Would throw an exception of type EvaluateException because it could not recognize the function Tan().

One solution you could take to solve this problem is to use a dynamic language in the DLR like IronRuby or IronPython.


namespace KeithRull.SimpleExpressionCalculator
{ class Program
{ static void Main(string[]
args) { string expressionToEvaluate = "Tan(20)
* 2"; var p = new IronPython.Hosting.PythonEngine();
var result = p.EvaluateAs<double>(expressionToEvaluate);
Console.Write(result); Console.Read(); //will
output: 4.47432188844948 } } } 

You can check out Kirill Osenkov's post for more info regarding this approach.

Another way which i think is the better way is using a third-party library that already support this like NCalc.

NCalc is an open source Mathematical Expression Evaluator for .NET that can parse any expression and evaluate the result, including static or dynamic parameters and custom functions.



using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using NCalc; namespace KeithRull.SimpleExpressionCalculator
{ class Program
{ static void Main(string[]
args) { string expressionToEvaluate = "Tan(20)
* 2"; Expression e = new Expression(expressionToEvaluate);
var result = e.Evaluate();
Console.Write(result); Console.Read(); //will
output: 4.47432188844948 } } }

Pretty cool huh?!





Just Released: Silverlight 4 Tools for VS 2010, new SL themes and WCF RIA Services

Just in case you missed it, Tim Heuer has announced that Silverlight 4 Tools for Visual Studio 2010, WCF RIA Services and 3 new SL themes have been released today. This is an exciting news for Silverlight aficionados who have been waiting for the RTM version of SL4 Tools since the last RC who are itching to put their hands on this new set of goodies.

If you want to learn more about SL, the best place to start is to go to Silverlight.net and checkout the Getting Started section. I would also suggest you follow Tim's blog and subscribe to his updates and also as follow Silverlight Cream for the latest stream of info from SL developers.

If you are looking for Silverlight books for beginners my suggestion would be to get Laurent's book (a SL4 edition will come out in September) and start from there. You should also checkout Jeff Pairies mind boggling book about Silverlight animation and also John Papa's classic SL book that talks about data-driven services with Silverlight. Although some of these books are 1-2 versions behind I still believe that there are a lot of value in them that you can still apply with your Silverlight 4 projects.



I've just downloaded the package via the WPI and I can't tell you how much excited I am to see SL4T-4-VS2010 RTMed. This will surely be a fun week.




Nice, time to rock this ship!


How To: Change the row and column colors of a table using jQuery

Here's a quick and easy way to alternate the row colors of a table using jQuery



<script>

$(document).ready(function()

{

//set
the color of the row based on rowindex $(".report-table-horizontal
tr:even").css("background-color", "#FFF8DC");

$(".report-table-horizontal
tr:odd").css("background-color", "#FFFBD0");



//highlight
the table titles by selecting the first row $(".report-table-horizontal
tr:first").css("background-color", "#FFCC33");



});

</script>

The resulting code will apply the to the table and would look like this:



Basically what the code is doing is that it is selecting a css class called "report-table-horizontal" and applies the style to the tr attribute of the table based on their row index whether they are even or odd.

Now if you want to change the color of a  table column you can do so using this script:


<script>
$(document).ready(function()
{ //set
the color of the row based on rowindex $(".report-table-vertical
tr:even").css("background-color", "#FFF8DC");
$(".report-table-vertical
tr:odd").css("background-color", "#FFFBD0"); //set
the color of the first column $(".report-table-vertical
td:first-child").css("background-color", "#FFCC33");
}); </script>




The difference on this code is the third line wherein we specified that the style will be applied on the first td element of the table. Alternately you can use the nth-child(n) selector instead to do the same task:



$(".report-table-vertical
td:nth-child(1)").css("background-color", "#FFCC33");


Hope this helps. You can view the live sample here:
alternating table colors with jquery.html (2.42 KB)

or just copy and paste the HTML code below to a new file:


<html>
<head> <title>Working with tables in jQuery</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
<script> $(document).ready(function()
{ //set
the color of the row based on rowindex $(".report-table-horizontal
tr:even").css("background-color", "#FFF8DC");
$(".report-table-horizontal
tr:odd").css("background-color", "#FFFBD0"); //highlight
the table titles by selecting the first row $(".report-table-horizontal
tr:first").css("background-color", "#FFCC33"); //set
the color of the row based on rowindex $(".report-table-vertical
tr:even").css("background-color", "#FFF8DC");
$(".report-table-vertical
tr:odd").css("background-color", "#FFFBD0"); //set
the color of the first column $(".report-table-vertical
td:nth-child(1)").css("background-color", "#FFCC33");
}); </script> <style type="text/css">
body { font-family: Arial; } </style> </head> <body> <h2>Alternating
row colors in a
table with jquery</h2>
<table class="report-table-horizontal">
<tr> <td width="100px">Firstname</td>
<td width="100px">Lastname</td>
<td>Email</td> </tr> <tr> <td>Keith</td> <td>Rull</td>
<td>keith@example.com</td> </tr> <tr> <td>Charissa</td>
<td>Rull</td> <td>charissa@example.com</td> </tr> <tr>
<td>Zoe Adrielle</td> <td>Rull</td> <td>zoe@example.com</td>
</tr> <tr> <td>John</td> <td>Doe</td> <td>jdoe@example.com</td>
</tr> <tr> <td>Jane</td> <td>Doe</td> <td>janedoe@example.com</td>
</tr> <tr> <td>Tony</td> <td>Brown</td> <td>brown@example.com</td>
</tr> <tr> <td>Lisa</td> <td>Sally</td> <td>sally@example.com</td>
</tr> </table> <br /> <h2>Change the color of the the first
column with jquery</h2>
<table class="report-table-vertical">
<tr> <td width="100px">Product</td>
<td>Price</td> </tr> <tr> <td>Eggs</td> <td>$1.10</td>
</tr> <tr> <td>Flour</td> <td>$1.20</td> </tr>
<tr> <td>Carrots</td> <td>$0.35</td> </tr> <tr>
<td>Cucumber</td> <td>$0.50</td> </tr> <tr> <td>Melon</td>
<td>$0.99</td> </tr> </table> </body> <html>

Most popular Searches

Bbc news news Health feed news right now General Developer News art news News and Opportunities General Motors service pins medical news business news medical news today Shopping taxi news web marketing Fun and Entertainment Internet general microwave CPA Marketing Genius Blog

About FeedListing.com

• Why sudmit your blog feed?

  You may have a blog, and that blog may be full of very interesting content, but it's not serving much of a purpose beyond honing your writing skills and allowing you to get something off your chest if other people aren't reading it.

  As with getting visitors or potential customers in any other aspect of your online business, it is going to take some promotion.

  There are a ton of directories and search engines specifically catering to blogs, and it is probably in the best interest of your blog's readership to get it listed in as many as possible. Start with us and sumbmit your feed at once, it only takes a couple of seconds.

• Welcome

  FeedListing.com pretends to become the reference on feed listing.

Categories

.NET
Advertising & Marketing
Africa
Americas
Art & writing
Articles & tutorials
Asia
Australia
Automobile
C/C++
CA
Cisco
Computers
Construction
Developer News
Europe
Finance
Foods & Beverages
Fun & Entertainment
Games
General
Hardware & PDA
Health
Human resources
IBM
Internet
Java
Legal
Locals
Media
Microsoft
Moreover
News & Opportunities
News4Sites
NewsIsFree
Real Estate
Science & Education
Security
Shopping
Society
Software
Sports
SQL & databases
Sun
Telecom & Wireless
Thoughts & comments
Travel
UK
US
Web development
World

Recommended

• Hamburger Phone
• Free Horoscope

Sponsors