Database Programming using C# 2008, Visual Basic 2008 and SQL Server

( Secrets of Developing an Accounting Package using C#, Visual Basic 2008 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 2008.

1. Components of the .NET Framework 3.5
   • ASP.Net
   • .Net Ajax
   • LINQ
   • ADO.Net Entity Framework and DataServices
   • Windows Workflow Foundation
   • Windows Communication Foundation
   • Windows Presentation Foundation
   • Windows Cardspace
   • Windows Forms
   • Console Application Services
   • ADO.Net
   • .Net Framework base classes
   • Common Language Runtime
2. Namespaces
3. Assemblies
4. Features Provided by the CLR
5. Compiling and Execution Steps in Net framework
6. Visual Studio 2008 Integrated Development Environment
7. Creating a New Project in Visual Studio 2008
8. User Interface elements of Visual Studio 2008 IDE
   • Design Window
   • WPF Designer
   • Web Forms Designer
   • The Solution Explorer Window
   • The Properties Window
9. Toolbox
   • The Output Window
   • The Task list window
   • The Server Explorer Window
   • The Class View Window
   • The Code Editor Window
10. Windows Forms
    • Windows Form Properties
    • Windows Forms Events, Handles keyword
    • Windows Form Methods
    • How to set the Startup form in VB 2008
    • How to set the Startup form in C# 2008
11. Windows Form Controls and Events
    • Text box Control
    • Label Control
    • ListBox Control
    • Selecting Items in ListBox Control
    • CheckBox Control
    • ComboBox Control
    • RadioButton Control
    • GroupBox Control
    • Button Control
12. Control Events
    • Keyboard Events
    • Mouse events
    • Control - specific events
13. Visual Basic 2008 Language Features
14. Data Types
15. Variables
    • Declaring Variables
    • Variable Naming Conventions
    • Variable Initialization
    • Variable Scope
      • Block Scope
      • Procedure Scope
      • Module Scope
      • Namespace Scop
    • Life time of a variable
16. Constants
17. Arrays
    • Declaring an array
    • Multidimensional Arrays
    • Assigning values to array elements
    • Dynamic Arrays
    • Preserve Keyword
18. Operators
    • Arithmetic Operators
    • Comparison Operators
    • Logical Operators
    • Concatenation Operators
19. Control flow constructs
20. Decision structures
    • If - Then - Else
    • Select Case Construct
21. Loop structures
    • While - End While Loop Structure
    • Do-Loop Structure
    • For-Next Loop Structure
22. Nested Control Statements
23. Procedures in Visual Basic 2008
24. Sub Procedures
    1. Access Modifiers used with Sub Procedures
    2. Argument Declaration in a Sub Procedure
    3. Passing arguments to a Sub Procedure
    4. Calling a Sub Procedure
    5. Types of Sub procedures
       • General procedures
       • Event-handling procedures
25. Function procedures
    • Return Values of a Function Procedure
    • Calling a Function Procedure
26. Property Procedures
27. Procedure Overloading
    • How to create Parameter Array
    • Rules to be followed while using a Paramter Array
    • Passing arguments of a Parameter Array

Chapter : 2. Visual C# 2008

1. Data Types in C# 2008
2. Variables
3. Rules to create an identifier
4. Initialization of Variables
5. Variable Scope
6. Block Scope
7. Constants
8. Arrays
9. Assigning values to Arrays
10. Two Dimentional Arrays
11. MultiDimensional Arrays
12. Jagged Arrays
13. Operators
    • Arithmetic Operators
    • Relational Operators
    • Logical Operators
    • Assignment Operators
    • Increment and Decrement Operators
    • Ternary Operators
14. Control flow constructs
15. Conditional Statements
    • if..else
    • switch..case statement
16. Loops
    • while loop
    • do...while loop
    • for loop
17. Collections
18. Non-Generic Collections
19. Generic Collections
20. Working with ArrayList
21. Adding items to the ArrayList using an Add Method
22. Iterating through items
    • Using Indexers
    • Using Enumerators
    • Using ForEach loop
23. Inserting items to the ArrayList using Insert and InsertRange method
24. Adding items to the ArrayList using AddRange Method
25. Removing items from ArrayList
26. IndexOf Method
27. Problems with ArrayList
28. Generics
29. When to use a Collection?
30. Performance issues when working with collectins -List and Dictionary
31. Adding Data into List
32. Collection initializers
33. Interating through the Customer List
34. Sorting in Lists
35. Usageof IComparable and IComparer and interafce to sort Lists of objects on custom classes

Chapter : 3. OOPs in VB and C# 2008.

1. Namespaces
2. Creating a Namespace in VB.Net
3. Creatig a Namespace in C#
4. Creating Nested Namepsaces in VB.Net
5. Creating Nested Namepsaces in C#
6. How to access members of a namespace in VB.Net
7. Creation of aliases for namespaces in VB.Net and C#.Net
8. How to access members of a namespace in C#
9. Structures
10. Declaring a Structure
11. Access Modifiers
12. Similarities between Classes and Structures
13. Differences between Classes and Structures
14. Create a Structure in Visual Basic 2008
15. Structures and Property Procedures
16. Initialization in Structures
Structure and Constructors
17. Create a Structure in C #
18. Writing a Constructor to initialize Structure member variables in C# 2005
19. Class
20. Advantages of using Classes and Objects
21. Creating a Class in Visual Basic 2008
22. Property Procedures
23. Property Declaration in VB 2008
24. Property Declaration in C# 2008
25. C# Language Feature: Automatic Properties
26. Constructors
27. Instance Constructor in VB 2008
28. Instance Constructor in C# 2008
29. Write the code to instantiate the class
30. Run the application
31. Shared constructor in VB 2008
32. Static constructor in C# 2008
33. Destructors
34. Finalize() Destructor
35. Dispose() method
36. Inheritance
    • Declaration of Account Class
    • Constructor overloading in vb.net
    • Creating a derived class - PartyAccount
    • Creating a constructor in derived class with parameters
    • Creating a derived class - BankAccount
37. Polymorphism
    • Compile time Polymorphism/ Method OverLoading
    • Implementing runtime Polymorphism / Overriding
    • example of runtime Polymorphism in Vb 2008 and C#
38. Abstract Classes
    • Creating Abstract Classes
    • Creating Abstract Members in Abstract Class
    • Implementing Abstract Class
    • Testing - Abstract class
    • Testing - Abstract class and Polymorphism
    • Polymorphism through Inheritance
    • Creating An Abstract Class in C# 2008
    • Implementing An Abstract Class in C#
    • Testing - Abstract class and Polymorphism in C#
39. Interfaces
    • Difference between interfaces and abstract classes
    • Why use interfaces
    • Declare an Interface in VB 2008
    • Create Invoice class which implements IPayableHandler Interface
    • Create Employee class which implements IPayableHandler Interface
    • Testing - Interface and Polymorphism in VB 2008
40. Declare an Interface in C# 2008
41. Create Invoice class which implements IPayableHandler Interface
42. Create Employee class which implements IPayableHandler Interface
43. Testing - Interface and Polymorphism in C# 2008
44. 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 2008 and C# 2008

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. 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 : 9. 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 2008 and C# 2008 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.