accounting software using vb visual basic asp .net sql server

Database Programming using Visual Basic 2005, C# 2005 & SQL Server 2005

(Includes accounting software source code and Covers Client Server Three Tier architecture)

ISBN: 81-901331-5-2
Price: $19.90/-
Weight: 2.4 Pounds
Pages: 562

Worldwide shipping.
Choose the low cost 7 day
Air Mail (REGISTERED)
or 3 days Courier Service.

• Jumpstart your career in the Microsoft's .Net world with this book.
• Develop a complete accounting application using Microsoft's VB 2005 and C# 2005 which runs on a network.
• Discover the power of using ADO .Net with Visual Basic 2005, C# 2005 and SQL Server 2005.
• Design an application based on three tier architecture including Data Layer, Business Layer and Presentation Layer using Class Libraries, with Microsoft's VB 2005, C# 2005 and Microsoft's SQL Server 2005.
• Write Stored Procedures for implementing business logics, inlcuding inserting, updating, retrieving and deleting data from SQL Server 2005 database.
• Add, edit and delete data in Datagridview control placed on a Visual Basic form.
• Call Stored Procedures in C# 2005 and VB 2005 applications.
• Learn how to implement Overloading and Overriding in a database application.
• Learn the architecture of ADO .Net (Disconnected architecture) and build superior database applications using Visual Basic 2005, C# 2005 and SQL Server 2005.
• Master how to use .Net DataProvider components including Connection, Command, DataReader and DataAdapter
• Use both OLEDB and SQLServer DataProviders right in your application.
• Master how to access a database using DataReader. Learn -
  • Establishing a connection with Connection object
  • Executing commands with Command objects
  • Using DataReader to read data from the database
• Master how to access a database using DataSet. Learn -
  • Establishing connection with Connection object
  • Instantiating Command object
  • Instantiating DataAdapters
  • Setting DataAdapter Command properties, Select Command, Insert Command, Delete Command and Update Command
  • Populating the DataSet using the DataAdapter in Visual Basic
  • Typed vs UnTyped DataSets
  • Creating the DataSet object
  • Populating the DataSet using the DataAdapter
  • Navigating through Dataset
  • Updating DataSet using DataTable and DataRow objects
  • Updating the Database using DataSet and DataAdapter
  • Detecting and handling changes to data in a DataSet
  • Accepting or Rejecting changes to data in a DataSet
  • Clearing records in a DataSet
  • Copying structure of a DataSet to a new datatable
  • Filtering the DataSet and Populate the Listbox
  • Moving to a particular row in the DataSet using the Binding Context object
• Program a transaction with ADO .Net using Transaction object
• Implement Visual Inheritence in Windows forms in Visual Basic Database Application
• Create a Class Library for Data Layer and Business Layer in Visual Basic