Leading Dot Net Training Institute in Dehradun
Ado-Dot-Net-Training

Windows Forms & ADO.NET Training

ADO.NET is the underlying framework for data access within .NET applications,and facilitates access to a range of relational and non-relational data sources, including Microsoft SQL Server, Oracle, and XML files, as well as any database for which a native or OLEDB-based provider is available. Applications can use ADO.NET to connect to any of these data sources to select, manipulate, and change data.


Course Outline


Windows Forms

  • What Are Windows Forms?
  • Windows Forms Class Hierarchy
  • Building a Form
  • The Application Class
  • Trapping Events
  • Buttons
  • Labels and Textbox Controls
  • Using the Forms Designer
  • Code Generated by Forms Designer
  • Adding Event Handlers
  • Creating Attractive Forms
  • Creating Easy To Use Forms
  • Checkbox, Radio Button, and Group Box
  • Numeric Up/Down
  • Trackbar
  • Progress
  • MonthCalendar
  • DateTimePicker
  • Listbox and Combo box
  • DomainUpDown
  • ListView
  • Storing Objects in List Controls
  • Modal vs. Modeless Dialogs
  • Message Boxes
  • Common Dialogs
  • Creating a Modal Dialog
  • Configuring the Dialog Result
  • Access Data from the Dialog
  • Validating Data
  • Error Provider Control
  • Modal Dialogs
  • Creating a Modeless Dialog
  • Main Menus
  • Context Menus
  • Building a Status Bar
  • Building a Toolbar
  • Using the Timer Control
  • Parent/Child Relationships
  • Owner/Owned Relationships
  • Top-Most Forms
  • Multiple Document Interface
  • Managing Parent/Child Menus
  • Programming the Clipboard
  • Visual Inheritance
  • Panel
  • TreeView
  • Splitter
  • Tab Control
  • Image Resources
  • Resource Files
  • String Resources
  • Working with Resources in Visual Studio
  • Resource Managers
  • Cultures and Internationalization
  • Building Localizable Forms
  • Application Class
  • Processing and Filtering Windows Messages
  • Application Lifetime and Events
  • Configuration Files
  • Windows Registry
  • ADO.NET Overview
  • .NET Data Providers
  • Using DataReaders
  • Data Sets
  • Data Tables
  • Data Views
  • Data Binding
  • Interacting with XML Data
  • ToolStrip Control
  • SplitContainer Control
  • Web Browser Control
  • DataGridView Control
  • Other .NET Controls
  • New Data Binding
  • Application Settings
  • BackgroundWorker Component
  • ClickOnce Deployment
  • Minor Project 1
  • Project Case Study 1
  • Minor Project 2
  • Project Case Study 2
  • Minor Project 3
  • Project Case Study 3


ADO.NET

  • Microsoft Data Access Technologies
  • From ADO to ADO.NET
  • ADO.NET Architecture
  • Namespaces and Classes
  • Interfaces
  • DataSets and Disconnected Access
  • First ADO.NET Programs
  • .NET Data Providers
  • DbConnection
  • Connection Classes
  • Connection Strings
  • Connection Pooling
  • Connection Events
  • Error Handling
  • Database Programs with ASP.NET
  • DbCommand
  • Command Objects
  • Creating Commands
  • Executing Commands
  • Parameterized Queries
  • Command Types
  • Using Stored Procedures
  • Batch Queries
  • DataReaders
  • IDataReader
  • IDataRecord
  • Type-Safe Accessors
  • Null Columns
  • ExecuteReader Options
  • Multiple Result Sets
  • Obtaining Schema Information
  • DataSet
  • DataAdapter
  • Command Objects
  • DataTable
  • DataColumn
  • DataRow
  • Row States and Versions
  • Accept or Reject Changes
  • DataTable Events
  • Updating a Database from a DataSet
  • Command Builders
  • Filtering DataTables
  • Multiple Table DataSets
  • Schema
  • Constraints
  • Relations
  • Navigating a DataSet
  • DataMapping
  • Creating a DataSet Programmatically
  • Strong Coupling Between ADO.NET and XML
  • Rendering XML from a DataSet
  • Controlling XML Output
  • Reading XML into a DataSet
  • XML Schema and DataSets
  • Typed DataSets
  • Table Adapters
  • Synchronizing DataSets and XML
  • XML Serialization
  • Data Binding in Windows Forms
  • Simple Data Binding
  • Complex Data Binding
  • DataGrid Binding
  • DataView
  • Filtering and Sorting
  • Data Binding with .NET
  • DataSets and Concurrency
  • Optimistic Concurrency
  • Pessimistic Concurrency
  • Handling Concurrency Violations
  • ADO.NET Transactions
  • Database Transactions
  • Using Server Explorer in Visual Studio
  • Asynchronous Database Operations
  • Multiple Active Result Sets
  • Bulk Copy in ADO.NET
  • Language Integrated Query (LINQ)
  • Bridging Objects and Data
  • Using Object Relational Designer
  • Filtering, Ordering and Aggregation
  • Inserts, Deletes and Updates
  • LINQ to SQL
  • LINQ to Dataset
  • Minor Project 1
  • Project Case Study 1
  • Minor Project 2
  • Project Case Study 2
  • Minor Project 3
  • Project Case Study 3

Course Registration

TESTIMONIALS


KEEP IN TOUCH

Subscribe to Our Newsletter to get Important News & Offers