Articles

  1. Introduction to Microsoft .Net Framework

    Submitted by planetsourcecode on
    .Net is the development platform for the future by Microsoft. The aim of Microsoft is to work in a distributed environment. There are may reasons behind this vision first , it will encourage classes/codes to be organized in one place rather then they are distribute in many places, earlier like in visual basic environment it is very difficult to manage the codes.
  2. VB.NET Introduction

    Submitted by planetsourcecode on
    Some times back the visual basic was the mostly widely used for developing applications. The VB is most popular for its graphical environment. The Visual Basic .Net is the extension of visual basic programming language. The new language provides many new features. If we compare the VB with VB.NET, there are huge changes in all areas. The VB.NET is designed to take advantage of the .NET framework classes. New features (in comparison with VB) 1).
  3. Using Stored Procedures with ASP.NET

    Submitted by planetsourcecode on
    Stored procedures are series of SQL statements grouped into a single unit, we can pass parameters to the stored procedures same like the passing parameters to the functions Simple stored procedure USE [databasename] GO /****** Object: StoredProcedure [dbo].[user_insert_mycomment] Script Date: 11/19/2008 22:45:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
  4. Execute Commands Methods: How to use it?

    Submitted by planetsourcecode on
    We have 4 types of Exceute methods, through which we can excecute the quries angainst Database. 1). ExecuteNonQuery(() 2). ExecuteReader() 3). ExecuteScalar() 4). ExceuteXmlReader() 1). ExecuteNonQuery(() Explanation: Executes a command but does not return any value or output usage conditions: UPDATE, INSERT, DELETE statements using System; using System.Data;
  5. Database Programming with JDBC

    Submitted by coderz on

    Type 4 drivers or Native protocol driver is known to be the one with the best features and functions. Type 4 driver does not have any native methods and is a complete Java driver. You need not to install it on the client before use and the can be easily downloaded or configured on a system very easily. One of the best features of Type 4 driver is that it interacts directly with the DBMS server.

    Firstly, you need to register the type of driver that you are using by using the string,
    Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

  6. Database Programming with Microsoft Access

    Submitted by coderz on

    Microsoft Access is a DBMS that is known to almost all of us. Most of the computer professionals must have used this DBMS at least once in their lifetime. With the help of Microsoft Access we can easily create new relational databases, insert, and update and delete data. Microsoft Access has gained more popularity with its ability to relate one or more tables in the database.