Database Programming using C# Visual Basic 2005 and SQL Server 2005

( Secrets of Developing an Accounting Package using C#, Visual Basic 2005 revealed )



Objective

The objective of this book is to teach the secrets of developing an accounting software package for the .Net platform using Visual Basic, C# , ADO .Net, SQL Server and Crystal Reports. Techniques of developing a complete accounting software package are taught using business logics, programs, flow charts and this makes learning easier. You will also learn how to create stored procedures and triggers, program the transactions of an Accounting Software, program reports using Crystal Reports, about disconnected architecture, MDI applications and how to use T-SQL.



Contents

Chapter : 1. Visual Basic 2005.

1. The .NET Framework 2.0
2. Components of the .NET Framework 2.0
3. Features provided by CLR
4. Visual Studio Integrated Development Environment
5. Creating a Project in Visual Studio
6. User Interface Elements of Visual Studio.Net IDE
7. Windows Forms
8. Windows Form Controls
9. Visual Basic Language Features
10. Procedures in Visual Basic

Chapter : 2. Visual C# 2005

1. Data Types
2. Variables
3. Initialization of Variables
4. Variable Scope
5. Constants
6. Arrays
7. Assigning Values to Arrays
8. Two Dimensional Arrays
9. Multi-Dimensional Arrays
10. Jagged Arrays
11. Operators
12. Control Flow Constructs

Chapter : 3. OOPs in Visual Basic & C#

1. Structures
2. Access Modifiers
3. Creating a Structure in Visual Basic
4. Creating a Structure in C#
5. Creating a Class in Visual Basic & C#
6. Property Declarations in Visual Basic & C#
7. Constructors
8. Destructors
9. Inheritance
10. Procedure Overriding
11. Implementing Visual Inheritance

Chapter : 4. SQL Server

1. SQL Server Management Studio
2. Authentication Modes in SQL Server
3. Understanding Windows Authentication mode
4. Understanding SQL Server Authentication mode
5. Changing SQL Server Authentication mode
6. SQL Server Object Explorer
7. Securing the Database
8. Create Logins
9. Add Logins to Server Roles
10. Fixed Roles
11. Grant access to Databases
12. Implementing Physical Database Schema
13. Creating the Database Files
14. Configuring the File Growth
15. Using Multiple Files
16. Multiple File Groups
17. Creating a Database with File Groups
18. Creating schemas
19. Tables with SQL Server Management Studio
20. Creating Tables with SQL Server Script
21. Creating Primary Keys
22. Using Identity Columns and GUIDS
23. Declarative referential integrity
24. Creating Indexes
25. Structured Query Language
26. T-SQL
27. Triggers
28. Transactions

Chapter : 5. ADO.Net

1. An introduction to ADO.Net
2. The ADO.Net Object Model
3. Dot Net Data Providers
4. Connection Object
5. Command Object
6. DataReader
7. DataAdapter
8. DataSet
9. Typed vs Untyped Datasets
10. Navigating through Datasets
11. Updating the Database using Dataset and DataAdapter
12. Detecting & Handling changes to Data in a Dataset

Chapter : 6. Accounting

1. Business Transactions
2. Financial Position and Accounting Equation
3. Accounts
4. Commonly used Accounts
5. Chart of Accounts
6. Groups
7. Double Entry System
8. Analysis of Transactions
9. The Voucher System
10. Typcial Transactions
11. Financial Statements

Chapter : 7. Developing the Financial Accounting Application - Visual Basic

1. Developing the Masters
2. Creating the Project
3. Writing Standard Modules
4. Creating the FinAccounting Database
5. Exploring the FinAccounting Database
6. Populating the Group Table with Chart of Accounts
7. Designing & Programming the Accounts Form
8. Programming the AccountsForm
9. Writing a Constructor
10. Programming the AccountsForm_Load() event procedure
11. Saving Account details into the DataSet
12. Moving to a particular row in the DataSet
13. Achieving error free/rapid data entry by enable/disable controls
14. Validating the data entered in the Amount TextBox control
15. Developing the Transactions
16. Developing the Tran Class
17. Designing and Programming the Journal form
18. Designing and Programming the VouRec form
19. Designing and Programming the PurSal form

Chapter : 8. Developing the Financial Accounting Application - C#

1. Developing the Masters
2. Creating the Project
3. Set the Startup form in C#
4. Creating the Constants
5. Populating the Group Table with Chart of Accounts
6. Designing & Programming the Accounts Form
7. Programming the AccountsForm
8. Writing a Constructor
9. Programming the AccountsForm_Load() event procedure
10. Saving Account details into the DataSet
11. Moving to a particular row in the DataSet
12. Validating the data entered in the Amount TextBox control
13. Developing the Transactions
14. Developing the Tran Class
15. Designing and Programming the Journal form
16. Designing and Programming the VouRec form
17. Designing and Programming the PurSal form

Chapter : 9. Creating Reports in Crystal Reports using Visual Basic and C#

1. Introduction
2. Designing and Programming the Trial Balance
3. Designing and Programming the DayBook
4. Designing and Programming the Registers

Chapter : 10. Developing Components for Three Tier Applications

1. Introduction to Class Libraries
2. Multi Tier Architecture
3. Creating a Class Library for the Data Layer
4. Creating a Class Library for the Business Layer

Technical Perspective

This book adopts an object oriented approach to develop an Visual Basic and SQL Server Accounting application. You will appreciate why an object oriented approach is used in application development. The programs which come with source code reveal the benefits of OOPs. The reports and transactions dealt with in this book are unique to an Accounting application. This book lays a good foundation for developing a client/server accounting application.

Unlike most other books, Application Series books cover all the end to end issues of developing database applications.

About VKINFOTEK  |   Testimonials