Friday, February 25, 2011

Computer Keyboards Designed To Prevent Repetitive Strain Injury (RSI)

Computer Keyboards Designed To Prevent Repetitive Strain Injury (RSI)

An ergonomic keyboard is a computer keyboard designed with ergonomic considerations to minimize muscle strain and a host of related problems.

Kinesis

TouchStream LP QWERTY

Repetitive Strain Injury (RSI)

Monday, February 21, 2011

Unix Power Tools

Don't Confuse Regular Expressions with Wildcards.

Both the shell and programs that use regular expressions have special meanings for the asterisk *, question mark ?, parentheses ( ), square brackets [ ], square brackets { } and vertical bar |.

Multiple commands can be issued on the command line, separated by a semicolon (;).

Q & A: newline
Q & A: others

sed tutorial
Unix Power Tools
Searching for Text with grep
sed scripts
IBM: sed by example
sed examples

Thursday, February 10, 2011

VB.NET: Import and Export Excel Data with LINQ to XML

Embedded VB.NET Expressions

In Visual Basic 9.0, an XML literal is considered an expression. If you want to assign a value to an object representing an XML tree, you can simply write that value as an assigned expression, as
follows:

Dim customers = _
From customer In Me.CustomersDataSet.Customers _
Where customer.RowState <> DataRowState.Deleted _
AndAlso Not customer.IsAbbrevNull _
Order By customer.Abbrev _
Select <Row>
<Cell><Data ss:Type="String"><%= customer.Abbrev %></Data></Cell>
<Cell><Data ss:Type="String"><%= If(customer.IsNameNull, "", customer.Name)%> </Data></Cell>
<Cell><Data ss:Type="String"><%= If(customer.IsPhoneNull, "", customer.Phone)%> </Data></Cell>
<Cell><Data ss:Type="String"><%= If(customer.IsCountryNull, "",customer.Country)%> </Data></Cell>
</Row>

VB.NET: Import and Export Excel Data with LINQ to XML

Wednesday, February 09, 2011

Writing a long string in multiple lines

Writing a long string will always produce scrollbars in the editor. So it’s better to split it to multiple lines which is more easy to read.

String LongLine = @”...............
...................................
..................................."

You can escape ” by using "".

Tuesday, February 08, 2011

Moq

Moq (pronounced "Mock") is the mocking library for .NET developed from scratch to take full advantage of .NET 3.5 (i.e. Linq expression trees) and C# 3.0 features (i.e. lambda expressions) that make it the most productive, type-safe and refactoring-friendly mocking library available. And it supports mocking interfaces as well as classes.

Codeproject C#: Mock a database repository using Moq

Monday, February 07, 2011

Designing and Building RESTful Web Services with WCF 3.5

When you design a RESTful service, you focus on the resources that make up your system, their URIs, and their representations.

RESTful services conform to the HTTP uniform interface – you simply need to decide which of those methods you’ll support for each resource.

In order to remove humans from the equation, you’ll need to use resource representations that are easy to programmatically consume.

MSDN: A Guide to Designing and Building RESTful Web Services with WCF 3.5

Wednesday, February 02, 2011

Find Duplicate Image Files On Windows PC

If you are a quick fingered photo-snapper or a wallpaper junkie then the thousand of images on your hard drive could be a treasure hoard. But scattered among them could also be a few hundred duplicate images eating up space on your hard drive. Even worse, un-optimized raw images could be eating up chunks of bytes and can be officially called junk.

So, how do we go about covering up our laziness and cleaning up our image folders?

Here’s a list of software apps in no relative order of merit
that can find duplicate image files.

MAKEUSEOF: 5 Ways To Find Duplicate Image Files On Windows PC

Tuesday, February 01, 2011

Map and unmap XML elements in Excel

To import and export XML data files in Excel, you must create an XML map, and then map and unmap XML elements to cells to get the results that you want.

Microsoft Office Excel 2007

By using XML maps, you can easily add, identify, and extract specific pieces of business data from Excel documents