1 Educators providing Ado.Net courses in Sheffield

ADO.NET TRAINING COURSE DESCRIPTION This ADO.net training course is designed to enable developers to use the toolset provided with.NET for data access including ADO.net objects, data controls, designers and interoperability with earlier ADO objects. The course is applicable for those using C# or VB.NET with ADO.NET WHAT WILL YOU LEARN * Retrieve and manipulate data using Microsoft's ADO.NET library. * Work with the ADO.NET object model. * Update data, including handling stored procedures, parameters, and return value. * Search, sort and filter data. * Leverage the power of XML. ADO.NET TRAINING COURSE DETAILS * Who will benefit: Programmers working with ADO.Net. * Prerequisites: Effective programming with VB.NET or Concise introduction to C# * Duration 2 days ADO.NET TRAINING COURSE CONTENTS * Introducing ADO.Net Traditional Data Access Architecture. ADO.Net Disconnected Data Access Architecture. Different components of ADO.Net. * A review of basic SQL queries SQL SELECT Statement. SQL INSERT Statement. SQL UPDATE Statement. SQL DELETE Statement. * Common data access tasks with ADO.Net Accessing Data using ADO.Net. Defining the connection string. Defining a Connection. Defining the command or command string. Defining the Data Adapter. Creating and filling the DataSet. * A Demonstration Application The Interface. Loading the table. Filling the controls on the Form. Navigating through the records. * Updating Data Steps for updating the table. Building the Application. Loading the table and displaying data in the form's controls. Initialising Commands. Adding Parameters to the commands. The ToggleControls() method of our application. Editing (or Updating) Records. Event Handler for the Save Button. Event Handler for the Cancel Button. Inserting Records. Deleting a Record. * Using Stored Procedures Sample Stored Procedures. UPDATE Stored Procedure. INSERT Stored Procedure. DELETE Stored Procedure. SELECT Stored Procedure. Using Stored Procedures with ADO.Net.

COMPLETE VB.NET TRAINING COURSE DESCRIPTION A hands on introduction to programming in Visual BASIC .Net. WHAT WILL YOU LEARN * Build Visual BASIC applications. * Build simple components * Debug Visual BASIC programs. * Examine existing code and determine its function. COMPLETE VB.NET TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to program in Visual BASIC. Anyone wishing to build Windows based applications. * Prerequisites: None although experience in another high level language would be useful. * Duration 5 days COMPLETE VB.NET TRAINING COURSE CONTENTS * Writing your first program Visual Studio, forms designer, running VB programs, the UI, properties, writing the code. * Toolbox Controls Basic use, input controls, ActiveX controls. * Menus and Dialog Boxes Menus, Dialog Box controls, event procedures. * Visual Basic .NET variables and operators Variables, I/O, data types, constants, operators, Math Methods, precedence. * Decision Structures and Loops and Timers Event-Driven programming, If…Then, Select Case, For…Next Loops, Timer Control. * Debugging Visual Basic .NET Programs Break Mode, watch & command windows. * Structured Error Handling Try...Catch, Finally, Err Object, retry periods. * Modules and Procedures Standard modules, public variables, procedures. * Arrays and Collections to Manage Data Fixed-Size & dynamic Arrays, ReDim Preserve, object collections, Controls Collection. * Text Files and String Processing Text Box object, Text String methods, sorting. * Automating Office Applications Application objects, automation in VB, the Object Browser, the Process Component. * Deploying Visual Basic .NET Applications Planning a deployment, ways to deploy an application, deployment projects, options. * Managing Windows Forms Forms, positioning, manipulation, adding controls, organizing controls, Startup Object. * Adding Graphics and Animation Effects System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency. * Inheriting Forms and Creating Base Classes Inheriting forms, inheritance picker, base classes and inheritance, classes in projects. * Working with Printers PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes. * Database programming with ADO.NET Databases, ADO.NET, Data Adapters, Datasets, Bound & Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database. * Displaying HTML Documents Using IE IE Object, Internet Controls, IE Events. * Web Forms for Interactive Web Applications ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.

ASP.NET TRAINING COURSE DESCRIPTION Our hands on ASP.NET training course that will teach students how to create a simple ASP.NET application that delivers dynamic content to the web. The course is applicable for those using C# or VB.NET with ASP.NET. WHAT WILL YOU LEARN * Create a web form with server controls * Separate page code from content with code-behind pages, page controls, and components. * Display dynamic data from a data source by using ADO.NET and data binding. * Debug ASP.NET pages by using trace. ASP.NET TRAINING COURSE DETAILS * Who will benefit: Programmers working with ASP.NET. * Prerequisites: HTML5 development fundamentals VBNet_course.htm or C++ programming foundation * Duration 3 days ASP.NET TRAINING COURSE CONTENTS * Working with ASP.NET Introducing ASP.NET. Creating web forms. Adding ASP.NET code to a page. Handling page events. * Using Web Controls Web controls and HTML controls compared. Using intrinsic controls. Using input validation controls. Introduction to user controls. * Using trace in ASP.NET pages Overview of tracing. Trace information. Page-level trace and application-level trace. * Separating code from content Advantages of partitioning an ASP.NET page. Creating and using code-behind pages. Creating and using components and classes. Inheritance of classes. Interfaces. * Using ADO .NET to access data Accessing text files. Overview of ADO .NET Connecting to a data source. Accessing data with DateSets. Using DataViews. Accessing data with DataReaders. Using XML data with a DataSet. * Creating an ASP.NET Web Application Requirements of a web application. Sharing information between pages. Securing an ASP.NET application. Web services. Creating a simple web service using Visual Studio.NET Calling a web service using Visual Studio.NET