20-12-2012, 02:08 PM
Online Examination Visual Basic Project
Online Examination.doc (Size: 1.25 MB / Downloads: 38)
System Definition
The company manufactures various types of products related to pharmaceutical laboratory. This company purchase raw material from India as well as from abroad. The product manufactured by company is distribute to various distributor located in different city for sale. This company doing repairing of pharmaceutical instrument also.
The system assists into the determination about purchase of products. It also does analysis of the products lying in the godown, calculates weighted average purchase rates. It also maintains stock by part receipt and dispatch module, and also perseveres record of repairing of instrument received by customers or internal person
Introduction to visual basic
Visual basic is most popular programming language in the world, and generally use as a front end for database application. There are some important reasons to use Visual Basic rather than others.
Capability: VB is capable of producing software as sophisticated as any of the others data-access techniques available. There is little you can do in say, Developer 2000 that cannot be implemented equally well with ADO or OO4O.
Flexibility: You do not have to use VB for only database access. You can use it to write a text processor, an e-mail listener, or 10,000 other tasks.
Familiarity: Being the most popular language in the world means there is as steady supply of talented staff for you to add to your development teams. When the general supply is short, you will still be more likely to find development staff then for other language.
Popularity: The popularity of a product is important for you to become familiar with because you will see more magazine articles and books as well as have better supply of third-party products from companies who will devote their resources in which there is a playback
Microsoft Visual Basic, the fastest and easiest way to create applications for Microsoft Windows. Whether you are an experienced professional or brand new to Windows programming, Visual Basic provides you with a complete set of tools to simplify rapid application development.
The "Visual" part refers to the method used to create the graphical user interface (GUI). Rather than writing numerous lines of code to describe the appearance and location of interface elements, you simply add prebuilt objects into place on screen. If you've ever used a drawing program such as Paint, you already have most of the skills necessary to create an effective user interface.
The "Basic" part refers to the BASIC (Beginners all-purpose Symbolic Instruction Code) language, a language used by more programmers than any other language in the history of computing. Visual Basic has evolved from the original BASIC language and now contains several hundred statements, functions, and keywords, many of which relate directly to the Windows GUI. Beginners can create useful applications by learning just a few of the keywords, yet the power of the language allows professionals to accomplish anything that can be accomplished using any other Windows programming language.
The Visual Basic programming language is not unique to Visual Basic. The Visual Basic programming system, Applications Edition included in Microsoft Excel, Microsoft Access, and many other Windows applications uses the same language. The Visual Basic Scripting Edition (VBScript) is a widely used scripting language and a subset of the Visual Basic language. The investment you make in learning Visual Basic will carry over to these other areas.
Visual Basic Editions
Visual Basic is available in three versions; each geared to meet a specific set of development requirements.
• The Visual Basic Learning edition allows programmers to easily create powerful applications for Microsoft Windows and Windows NT®. It includes all intrinsic controls, plus grid, tab, and data-bound controls.
• The Professional edition provides computer professionals with a full-featured set of tools for developing solutions for others. It includes all the features of the Learning edition, plus additional ActiveX controls, the Internet Information Server Application Designer, integrated Visual Database Tools and Data Environment, Active Data Objects, and the Dynamic HTML Page Designer.
Introduction to SQL Server
Microsoft SQL Server OLAP Services provides an online analytical processing (OLAP) architecture for rapid access to data warehouse data. Data from the data warehouse is extracted, summarized, organized, and stored in multidimensional structures for rapid response to user queries.
OLAP Services and PivotTable Service provide the capability to design, create, and manage cubes from data warehouses and to provide client access to OLAP data. The OLAP server manages the data; PivotTable Service works with the server to provide client access to the data.
Client/Server Architecture
Microsoft SQL Server is designed to work effectively in a number of environments:
• As a two-tier or multitier client/server database system
• As a desktop database system
Client/Server Database Systems:
Client/server systems are constructed so that the database can reside on a central computer, known as a server, and are shared among several users. Users access the server through a client or server application:
• In a two-tier client/server system, users run an application on their local computer, known as a client that connects over a network to the server running SQL Server. The client application runs both business logic and the code to display output to the user, and is also known as a thick client.
• In a multitier client/server system, the client application logic is run in two locations:
• The thin client is run on the user’s local computer and is focused on displaying results to the user.
• The business logic is located in server applications running on a server. Thin clients request functions from the server application, which is itself a multithreaded application capable of working with many concurrent users. The server application is the one that opens connections to the database server and can be running on the same server as the database, or it can connect across the network to a separate server operating as a database server.
This is a typical scenario for an Internet application. For example, a server application can run on a Microsoft Internet Information Services (IIS) and service thousands of thin clients running on the Internet or an Intranet. The server application uses a pool of connections to communicate with a copy of SQL Server. SQL Server can be installed on the same computer as IIS, or it can be installed on a separate server in the network.
Desktop Database Systems:
While SQL Server works effectively as a server, it can also be used in applications that need stand-alone databases stored locally on the client. SQL Server can configure itself dynamically to run efficiently with the resources available on a client, without the need to dedicate a database administrator to each client. Application vendors can also embed SQL Server as the data storage component of their applications.
Database Architecture:
Microsoft® SQL Server™ data is stored in databases. The data in a database is organized into the logical components visible to users. A database is also physically implemented as two or more files on disk.
When using a database, you work primarily with the logical components such as tables, views, procedures, and users. The physical implementation of files is largely transparent. Typically, only the database administrator needs to work with the physical implementation.
Selecting an ODBC Driver
Now that we have found out what types of ODBC drivers there are and what are and what their capabilities are, it is time to select one for working With your SQL Server database. One of the most frustrating aspects of ODBC is finding a driver that does whet you want. Many drivers claim high compatibility to the various conformance levels, but each new driver has slightly different capabilities or, what is worse, affects the capabilities of those you last installed on your machine. Given the speed with which things change, it is difficult to the definitive on which drivers that come either from SQL Server or Oracle and learn to understand and live with their peculiarities.
My recommendation is to either one of these company’s ODBC driver but be careful before you upgrade. Do not get copies of all the latest versions and blindly install them without allowing for the fact that they may interface with each other. If you have test machine, then install any new driver on that and make sure it works as advertised and does not destructively interface with othr drivers. Sometimes the only way to get out of a situation like this is to reformat the hard drive and start again.
One particular case in point is the driver that came as part of MDAC1.5, the Microsoft Data Access Component, that provides features for ADO (Active Data Components). The new driver exposed a bug in RDO2.0, which was not fixed until Visual Basic 6.0.