Today we have seen most of the data access layers on the web. Here I have placed some peace of simple Data Access class for your use. This will helpful if you are using quires. This will not useful for stored procedures. You simply form the query and call the ExecuteQuery function.
Class Methods and properties:
ExecuteQueryMode-Enumarator type of Execute Query Mode.
GetConnectionString () – Get the Connection string from the connectionStrings part of the Config file.
CreateConnectionObject () – To create the Connection Object
OpenConnectionObject () – Open the Connection
CloseConnectionObject () …

As other sample (Hello world) WCF services, this service is also going to help you understanding how to develop a simple WCF service and its client in Visual Studio.Net, but I tried to explain the way more elaborately. The sample given here is a simple file based employee details repository service. This Article also helps you to know how the client project can discover the WCF service hosted in the server.

Are you using / developing applications for Windows Vista? What if your application requires administrator privileges to perform a task? (For example, probably this would happen when you develop a host application for your WCF Service). This article helps you understanding the UAC clearly and developing application to run with privileged rights.

Usually boolean values are stored as bit fields in database tables. If we require only a few boolean values to be stored in the table, it would be good to have them as separate bit fields. But consider when we want to store some series of boolean values in the database; I have good idea to avoid creating fields for each of such boolean values in the table. For example, choosing weekdays, months in a scheduling kind of problems, attendance for 8 hours of a day in school/college management applications, …

The Visual Basic.Net doesn’t contain the refactoring which is one of the major advantages for the C# programmers. Often I miss the Encapsulate Field feature in VB.Net which helps us for geneting public properties of a class and associated Get & Set methods. Initially I had a thought of doing a code fragment in VB.Net for parsing private data members and automatically generating public properties along with their Set and Get methods.
The hardcore requirement of encapsulation (in Re-factoring) of private members with public properties  comes in the Entity class in …

Don’t lose your nerve when you forced to work with pointers?
Introduction
Pointer is an interesting feature of C language. It plays a vital role in major C programs. It is not a complicated data structure; instead it is very simple one that helps us in building many blocks of data structure such as linked list, trees and files.
Declaring pointers
Pointers are variables that store address of other variables (memory locations). As pointer always stores address of memory locations and address of a memory location is always an integer, it will be always …

The following code is for the ListNode class of List node objects. This example list program is built for storing strings. The list node class given here has two data members viz., Data and Link. Data is of the type string to store list item in it and Link is again of the type ListNode to refer next node in the list.
Though .Net contains inbuilt classes for creating linked lists, the recoded C# program given here is to help the readers to understand how the linked lists are really working. …

Introduction
Though all of the programming languages enhanced to provide basic date, time and calendar calculations, writing hard logic for a simple requirements such as calander improves our programming skill. Let us consider about calculating day of a week for a given date and calender for a given month in C language. This is for helping learners of C language.

The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.
TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn’t use as much undo space as a DELETE.
The DROP command removes a table from the database. All …

The Producer-Consumer problem is the traditional one to explain the concept of multitasking with shared memory access in operating systems. This program demonstrates how a shared memory is being accessed by two different threads which run concurrently through an Applet. The producer thread continuously produces an item (here it generates a random number) and inserts into the stockpile (here it is an array limited in size), until space exists. The other thread named consumer, consumes an item (here it simply removes the item from the array). If there is no …