Using SQLite with .NET

Introduction
SQLite is a serverless SQL database engine.
It can be easily embedded into any software application, without the need to run any other database services on the host machine. The entire database engine and data are included in a single file, which is platform-independent.
Therefore depending on the project type, and data requirements, it could be [...]

Read Full Post »

ASP.NET: How to use an XMLDataSource with a GridView

Introduction
GridView is one of the most popular ASP.NET data controls.
It is most commonly used to display data coming from a database.
However, a GridView can also read and display data from plain XML files.
This tutorial is showing how to setup an XMLDataSource and associate it with a GridView.
XML data
Let’s start by creating a simple XML file [...]

Read Full Post »

Unit Testing J2ME applications with J2MEUnit and Eclipse

Introduction
Unit Testing verifies that the smallest bits of testable source code behave exactly as expected. Test-driven development is based on Unit Testing, and the use of automated testing frameworks.
The most popular Java testing framework is JUnit. Unfortunately JUnit cannot work in J2ME projects, since J2ME does not support Reflection. However J2MEUnit comes to the rescue, [...]

Read Full Post »

ASP.NET – How to call a server-side method from client-side JavaScript

Introduction
This is a tutorial on how to call a server-side ASP.NET method from a client-side JavaScript method.
If you are wondering when that could become useful, imagine the following scenario:
A Web Application having an implemented authentication system.
Users log in with their username and password.
At any point the user is able to log out by clicking on [...]

Read Full Post »

SQL Server: INSERT INTO with SubQuery

Introduction
This is a short tutorial on how to insert data with a subquery on SQL Server databases.
The reason I am writing about it is that the required syntax is not that obvious!
Sample tables and data
Let’s create two simple tables for this tutorial with the names ‘Customers’ and ‘Orders’.
CREATE TABLE [dbo].[Customers](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](100) [...]

Read Full Post »

Using log4net with Oracle 10g

Introduction
This tutorial describes the required steps needed to be followed for logging with log4net on Oracle 10g.
Prerequisites
- Oracle 10g (could also be working with Oracle 11g, however I haven’t tried it – please leave a comment if you try it)
- Oracle Data Access Components for Windows (ODAC) / (ODP.NET)
- log4net (1.2.10)
Step 1
Creating the SQL table, [...]

Read Full Post »

Google App Engine – Using the template system and CSS

This is my second article about the Google App Engine.
On the previous article, I have gone through the installation/setup process, and a “Hello World” project.
Introduction
While developing web applications it is always a good practice to separate the presentation layer from the application logic. This approach is recommended for all modern web frameworks, whether that is [...]

Read Full Post »

Google App Engine – Getting Started – Setup and Hello World application

Introduction
Lately I have been reading quite a lot of articles about Google App Engine, and I just couldn’t resist trying it out myself.
Google App Engine enables you to build web applications on the same scalable systems that power Google applications.
If this is the first time you are hearing about the Google App Engine, it would [...]

Read Full Post »