Monday, May 26, 2008

Does Size Matter.....
When it comes to RDBMS it wont any more.....


SQLite is a ACID-compilant Relational Database Management System. The whole package comes up to only 500Kb approximately.  SQLite was created by D. Richard Hipp and the source code of which is in public domain.


The main feature of SQLite is its not a separate process instead SQLite Library is Linked in and hence integrates with the part of the application. It follows 3 out of 4 rules of database transactions that are Atomic, Isolated and Durable. As it has no foreign key attribute hence it doesn't satisfy the consistency requirement. SQLite also supports and triggers the complex queries. Its also a dynamically typed i.e. types are assigned to individual values instead of individual columns. Also several threads and processes can simultaneously access the database. 


SQLite can be used with a large number of programming languages including BASIC, C, C++, Common Lisp, Java, C#, Delphi, Lua, Tcl, R, PHP, Perl, Ruby, Objective-C (on Mac OS X), Python, newLispSmalltalk, using connection engines.


Source: http://www.sqlite.org/,http://en.wikipedia.org/wiki/SQLite

A book for the Not so Dumb..........

If you think you know the basics of programming, and have ample time to learn a new Programming Language then checkout this book.........


Author(s):Francesco Balena (Wintellect) 


With at-least of 1600 pages covers the whole of Visual Basic .net. A good reference book if you are a student or any professional who needs to get the new generation of Microsoft Certification. It takes a Bottom-Up approach, initially dealing with the .Net framework itself, covering the various aspects of a programming language like Variables, Loops, Condition statements, Modules, Control flow and so on.

In the second part Object Oriented Programming (OOP's) concepts are explained in a detailed and in a concise manner, and covers Overloading, Overriding, Events, Constructors and Destructors and similar OOP's concepts . The third part again deals with the .Net framework in a detailed manner covering topics such as Boxing and Un-Boxing, Serialization, Threading and similar topics. Basics of using and developing applications using Windows Form is covered up in the fourth part.

The fifth part is dedicated to Databases i.e. ADO.net and deals with using databases with VB.net in Connected and Disconnected mode and also XML related topics.  And the last part deals with ASP.net programming using VB.net.

Overall this book is a must read for any one who wants to learn VB.net programming from the ground-up to the expert level.

Image Courtesy: Microsoft

Tuesday, April 15, 2008

Books to Learn Visual Basic .net


Curious to learn VB 2005 but dont know which books to refer then read on..... 


Book 1: Perfect starting point for Amateurs



This book which is also a Self study guide to a MCSD.Net topic covers the whole of VB.Net also VC#.net. Ideal for beginners as it starts from the ground up and moves ahead slowly but steadily covering each and every aspect of both the languages i.e. VB.Net and VC#.Net. Each topic has a brief to the point explanation and a code sample in both the languages.


If you are thinking of getting certified in VB.Net this book is a must read.


The only drawback of this book are the examples are given part by part and the user need to use his imagination a lot to put all the code together and get it running. But as the same code is provided in the included CD-ROM this is not a big issue.



Friday, April 11, 2008

Simple Reporting Application in VB.Net 2005


All who have worked on VB.Net 2005 with database have designed Report some or the other time. Reporting is one such feature which comes in handy at all times. 
Beginners have a tough time in figuring out how to create a Data-report in VB 2005. If you have worked previously on VB 6.0 or any lower versions the Data-Report functionality is sadly not available any more in VB.net. The same hase been replaced by ReportViewer another powerfull tool for creating User Reports in VB.net or even VC#.net
The following tutorial explains the simplest way to create a Report using ReportViewer.





Complete Tutorial can be found Here