Develop an Accounting Software using Visual Basic and sql server


Contents


what is in it for you

Visual Basic Client Server Application Development

To develop a Client Server application, one needs to have a clear understanding of client side issues and server side issues. This is precisely the objective of this book, to give you a complete ground up information on how to set up a client server network, how to design the interface, how to setup the database, design the database, program the stored procedures and handle multiple clients simultaneously.
  • Develop commercial applications to run on a network using Microsoft's technologies, Visual Basic and SQL Server.
  • Discover the power of combining ADO and Sql in Visual Basic (VB) for data manipulation.
  • Program forms, transactions, and reports of an accounting application using Visual Basic.
  • Secrets of hard coding, techniques used by professionals who develop quickbooks, SAP, Peachtree, STFB, MYOB revealed.
  • Own the source code (Visual Basic) provided in the book and use it to your benefit.
  • Covers all networking topics and helps you build a foundation in networking.
  • Retreive and save transactions over a network using Microsoft's Visual Basic (Visual Basic).
  • Design a database for a client server application.
  • For setting up client server network you should know the following :- DNS Server, IP Address, Domain Model, Domain Controller and Active Directory Services. With this book it is easy to do all of these effortlessly.
  • Master Server Side programming. Learn writing stored procedures, triggers and setting constraints.
  • A great resource for programmers working in service companies like Accenture, Infosys, SAP Implementation, IBM and consultants.
  • Creating a Connection object in Visual Basic.
  • Retrieving records from the datasource in a Visual Basic Application.
  • How to create Multiple Command Objects Using a Single Connection object in Visual Basic.
  • Using the Execute command, insert a new record, update and delete a record in a Visual Basic database application.
  • Executing a Stored Procedure in SQL Server having INPUT and OUTPUT parameters using a Command object in Visual Basic.
  • Creation of RecordSert in Visual Basic as a Server-side Recordset and Client-side Recordset.
  • Assigning a Lock in Visual Basic for a client-side Recordset object.
  • Navigating a recordset and Binding controls to a recordset in Visual Basic.
  • Use a recordset to add a new record, delete and modify.
  • Add a Class to the project in Visual Basic.
  • Creating Database Integrity constraints using scripts.
  • These set of books are a hands on guide to gain proficiency in accounting applications is a sure step towards ERP application development.
technologies used to write erp books are .net, sql server and C#

More

Pack Offers

cover image of azure cloud book

Develop Azure Applications

Azure Cloud is gaining popularity and is competing with Amazon Elastic Cloud and Google Cloud for a spot in the billion dollar Cloud computing space.

With this book learn how to use - Table (an Azure Table is different from a SQL Server Table), Queue, Blob storage services, use your local machine to create an Application and a Service, how Azure splits a Table to achieve Load Balancing, Scalability based on the Partition Key, AppFabric Service Bus, Access Control Service, role of Fabric Controller, features of Azure SQL Database and Content Delivery Network.

Many have mastered Cloud Programming and are enjoying the benefits. Why not you?

View Highlights » View Contents »
cover image of foundation database programming book

Create your Own Accounting Software

A foundation book to Master Accounting Software Development, VB.Net, C# and OOPs programming. Detailed explanation of the Accounting domain for programmers is included. SQL and ADO.Net is also covered in detail.

This book gives you a strong foundation in Application Development.

A thorough understanding of the contents will enable you to grasp the topics covered in the accompanying books quite easily. This is because, the accounting domain is dealt with great detail in this book.

The ideal book to get started with application development in the .Net world.

View Highlights » View Contents »

cover image of asp.net book

Create your Own WEB ERP Software using ASP.Net

This book opens you to the Web. Using ASP.Net, C# and SQL Server as the tools, you will learn to build a Multi Tier Web Application as recommended by Microsoft. You will learn implementing inline GridView control, Transaction Management for a layered Web Application, build Data Access component and a Business Layer component.

Opens you to a world of opportunities. You will be able to develop a Web ERP application including all the five modules and learn how to use the TreeView control and GridView control to implement transactions such as Purchase Invoice, Sales Order and Sales Invoice.

View Highlights » View Contents »
cover image of entity framework book

ASP.Net MVC 5 Application Development Using Entity Framework 6 and VS 2015

Entity frameworks is the latest buzz in .Net programming and is the data access technology for Microsoft OS based hand held devices and web applications. Learn to integrate EF into an ASP.Net Application and MVC application. Create, explore and query the Entity Data Model. Learn how to use ObjectDataSource control and GridView control in an ASP.Net Application.

Also, learn to build Three-Tier ASP.Net application, create a business-class, implement methods in the class to perform CRUD operations and bind a GridView to the ObjectDataSource control. Learn how to handle concurrency and managing Transactions.

View Contents »