- Microsoft's Visual Basic, ASP.Net and SQL Server Software Development simplified.
- Web application development using ASP.Net and SQL Server.
- Client Server Application development.
- Desktop Application development.
- Accounting Software development demystified.
- Get a Solid foundation for entering into the ERP world.
- Kiss Goodbye to expensive training programs.
- Develop a complete accounting application using Microsoft's VB 2005 and C# 2005 which runs on a network.
- Jumpstart your career in the Microsoft's .Net world with this book.
- 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, including 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.
- 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 in Visual Basic.
- 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 Inheritance in Windows forms in Visual Basic .Net Database Application.
- Create a Class Library for Data Layer and Business Layer in Visual Basic .Net.