vkinfotek

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

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

cover image of database programming using VB, C# and SQL server book with isbn and price


Next Book Contents >>


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.

highlights of Database Programming book


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
  17. Structure and Constructors
  18. Create a Structure in C #
  19. Writing a Constructor to initialize Structure member variables in C# 2005
  20. Class
  21. Advantages of using Classes and Objects
  22. Creating a Class in Visual Basic 2008
  23. Property Procedures
  24. Property Declaration in VB 2008
  25. Property Declaration in C# 2008
  26. C# Language Feature: Automatic Properties
  27. Constructors
  28. Instance Constructor in VB 2008
  29. Instance Constructor in C# 2008
  30. Write the code to instantiate the class
  31. Run the application
  32. Shared constructor in VB 2008
  33. Static constructor in C# 2008
  34. Destructors
  35. Finalize() Destructor
  36. Dispose() method
  37. 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
  38. Polymorphism
    • Compile time Polymorphism/ Method OverLoading
    • Implementing runtime Polymorphism / Overriding
    • example of runtime Polymorphism in Vb 2008 and C#
  39. 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#
  40. 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
  41. Declare an Interface in C# 2008
  42. Create Invoice class which implements IPayableHandler Interface
  43. Create Employee class which implements IPayableHandler Interface
  44. Testing - Interface and Polymorphism in C# 2008
  45. 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, erp software development books cover all the end to end issues of developing database applications.





















.net, sql server, C#, symbols. owned by microsoft.


order