Favorite Gadgets: June 2012

Monday, June 25, 2012

Windows 8 - From a Consumer And a Developer Perspective - CodeProject

Here is a very interesting article about Windows 8. Has some information that i did not know that could help anyone when we will need to switch to it.

Windows 8 - From a Consumer And a Developer Perspective - CodeProject

Access VBA: Creating Text File or Table from Query - CodeProject

Example SQL outer join query with Null placeholders in the result set. The Null markers are represented by the word NULL in place of data in the results. Results are from Microsoft SQL Server, as shown in SQL Server Management Studio. (Photo credit: Wikipedia)

Introduction to this great article about using Access to create Textfiles based on data in the Database!

Access is both a handy tool and a pain in the neck to use. It removes all of the complexities of using SQL Server, DB2, or Oracle and provides a nice point and click interface. However, It does not follow all of the SQL rules and will not do full outer joins. Also, Access documentation and support sucks. It does provide a VBA interface that allows us to code around the problems.
My assignment was to run a stored query 90 times to get a sample set of data for 90 days. I came up with two solutions. The first created a text file using tab delimiters and the second built a table dynamically. The code should work for any record set created from any query.

Access VBA: Creating Text File or Table from Query - CodeProject

Monday, June 18, 2012

A beginner's tutorial for understanding Windows Communication Foundation (WCF) - CodeProject

Need to get a start for understanding Windows Communication Foundation (WCF)? Start here:

This article is an introduction to the Windows Communication Foundation (WCF). We will try to see the basic concepts behind WCF and will try to implement a small WCF service. We will also work out some small examples of how a WCF service can be consumed.

A beginner's tutorial for understanding Windows Communication Foundation (WCF) - CodeProject

Saturday, June 16, 2012

Android Application with SQLite Database - CodeProject

One of the most common programming tasks is connecting your application to Database. Here is an article about connecting am Android app to a SQLite Database.

Android provides several options for you to save persistent application data. The solution you choose depends on your specific needs, such as whether the data should be private to your application or accessible to other applications (and the user) and how much space your data requires.

Android Application with SQLite Database - CodeProject

Friday, June 15, 2012

Video Games: Digital vs Retail Sales [infographic]

Video Games: Digital vs Retail Sales [infographic]

Wednesday, June 13, 2012

WiFi HotSpot / WiFi Tether - Android Apps on Google Play

Need some apps for turning your Android phone into a mobile hotspot? Check these apps out, one of them might help you.

WiFi HotSpot / WiFi Tether - Android Apps on Google Play

Wifi Hotspot & USB Tether Lite

FoxFi

Writing Android GUI using C++(3:debug) - CodeProject

This is how you debug an Android GUI written in C++

Writing Android GUI using C++(3:debug) - CodeProject

Tuesday, June 12, 2012

Silverlight 5 – Elevated Trust In-Browser « xamlgeek

Image representing Microsoft Silverlight as de...

Image via CrunchBase

This will be useful

In Silverlight 5 it is possible to enable applications to run with elevated permissions in-browser.
The code snippet below will open Notepad.exe using the AutomationFactory in Silverlight. Using the AutomationFactory requires elevated permissions.

To run the snippet in Silverlight 4 the application must run with elevated permissions and in out-of-browser. In Silverlight 5 it is possible to run the snippet in-browser and with elevated permissions.

Silverlight 5 – Elevated Trust In-Browser « xamlgeek

iClarified - Apple News - Tactus Shows Off Real Physical Keyboard That Rises Out of Touchscreens [Video]

I want one!!!

iClarified - Apple News - Tactus Shows Off Real Physical Keyboard That Rises Out of Touchscreens [Video]

Saturday, June 9, 2012

Deployment made simple using Powershell - CodeProject

This is going to come in very handy. I was just looking for something like this!!!

Powershell scripts allow you to take advantage of .NET libraries and write scripts which are almost as powerful as the .NET code itself. You can do many powerful operations like call external DLLs, use .NET namespaces like System.IO, System.Net, run processes and intercept output, call web services etc. The possibilities are endless. Here, I will show you a Powershell script which assists you in day to day deployment of websites. Everyday, we make changes to web projects, which need to be deployed to development servers, sometimes on beta servers, and finally on the production server. Using this script, you can automate all the manual work that you do again and again on your deployment package every time you upload your website to some server. We use this script in Pageflakes every single day during our local development server upload, beta release, and final production server release. All we do is run the script, go to the server, and extract a zip file on the web folder, and that's all. The new version gets deployed within two minutes without any manual work at all, and completely removes any possibility of human error during deployment.

Deployment made simple using Powershell - CodeProject

Friday, June 8, 2012

Creating an Entity Framework connection from another - CodeProject

Creating an Entity Framework connection from another - CodeProject

The above link telles you how to make an entity framework connection from another entity framework connection!

Thursday, June 7, 2012

Microsoft® “Roslyn” CTP

I just learned about "Roslyn" from Microsoft. It works out that it gives you very detailed ability to write out scripts that gives your software the ability to write it's own code.

Traditionally, compilers are black boxes – source code goes in one end and object files or assemblies come out the other end. The Roslyn project changes that model by opening up the Visual Basic and C# compilers as APIs. These APIs allow tools and end-users to share in the wealth of information the compilers have about code. The Roslyn CTP previews the next generation of language object models for code generation, analysis, and refactoring, and the upcoming support for scripting and interactive use of VB and C#.

Microsoft® “Roslyn” CTP

Deploying Silverlight with WCF Services - CodeProject

Image via CrunchBase

This one is handy

Deploying Silverlight with WCF Services - CodeProject

Wednesday, June 6, 2012

iTextSharp | Free software downloads at SourceForge.net

I have been researching methods for creating software for generating PDF files on the fly. One such way is to use iText.

iText# (iTextSharp) is a port of the iText open source java library for PDF generation written entirely in C# for the .NET platform. Use the iText mailing list to get support.