हिंदी में देखें |

Computer Courses

Programming Language

ADO.Net



ADO.Net At the releasing time of the .NET Framework, Microsoft introduced a new data access model, called ADO.NET. The ActiveX Data Object acronym was no longer relevant, as ADO.NET was not ActiveX, but Microsoft kept the acronym due to the huge success of ADO. In reality, it’s an entirely new data access model written in the .NET Framework.

ADO.NET supports various data sources through both ODBC and OLE-DB, but it also offers another option of using database-specific data providers.

These data providers offer greater performance by being able to take advantage of data-source-specific optimizations.
The original release of ADO.NET included a SQL provider and an OLE-DB provider, with the ODBC and Oracle providers being introduced later. But it supports a number of other providers too.


Contents :-

  • ADO.Net

    History of Data Access

    Data Access in starting days
    Birth of Universal Data Access
    Data Access Consumers

    Introduction ADO.Net

    Overview of ADO.NET
    ADO.NET Architecture
    Benefits of ADO.NET
    Difference between ADO and ADO.NET

    Standardized Database Objects and Design

    Creating Databases
    Naming Conventions
    Primary Keys
    Foreign Keys
    Indexes
    Views
    Normalization

    ADO.NET Essentials

    Overview of .NET Data Provider
    Connection Strings
    Connections
    Dataset
    Using Data Adapter
    Using Data Reader
    DataTable
    DataSet, DataTable, DataReader, or an Object?

    Standard Data Types

    DataTypes in SQL Server

    Data Bindings

    Introduction (Data Binding)
    Windows Forms versus Web Applications
    Data Binding in ASP.NET
    Windows Forms Applications

    Binding Controls to Database

    Simple Binding
    Complex Binding
    Binding Data to Controls
    Navigating in Datasets
    Using SQL Parameters

    Handling Database in Code

    The OleDbConnection Class
    The SqlConnection Class
    The OracleConnection Class
    The OleDbCommand Class
    The SqlCommand Class
    The OracleCommand Class
    The OleDbDataAdapter Class
    The SqlDataAdapter Class
    The DataSet Class
    The OleDbDataReader Class
    The SqlDataReader Class
    The DataTable Class
    The DataRow Class
    The DataColumn Class
    The DataRelation Class

    Data Source, Data Control Parameters & Different views

    Understanding Data Source Controls
    Working with Data Source Control Parameters
    Data Binding using Databound Controls
    Working with GridView Control
    Working with DetailsView Controls
    Binding Standard Web Server Controls
    Controls Designed for use with Databases
    Using Data Lists in Web Applications
    Using Repeaters in Web Applications
    Working with FormView

    New Features of ADO.NET 2.0

    Salient features of ADO.NET 2.0

    ADO.NET Essentials

    Overview of .NET Data Provider
    Connection Strings
    Connections
    Dataset
    Using Data Adapter
    Using Data Reader
    DataTable
    DataSet, DataTable, DataReader, or an Object?

    ADO.NET Essentials

    Overview of .NET Data Provider
    Connection Strings
    Connections
    Dataset
    Using Data Adapter
    Using Data Reader
    DataTable
    DataSet, DataTable, DataReader, or an Object?

    ADO.NET Essentials

    Overview of .NET Data Provider
    Connection Strings
    Connections
    Dataset
    Using Data Adapter
    Using Data Reader
    DataTable
    DataSet, DataTable, DataReader, or an Object?

    ADO.NET Essentials

    Overview of .NET Data Provider
    Connection Strings
    Connections
    Dataset
    Using Data Adapter
    Using Data Reader
    DataTable
    DataSet, DataTable, DataReader, or an Object?

    ADO.NET Essentials

    Overview of .NET Data Provider
    Connection Strings
    Connections
    Dataset
    Using Data Adapter
    Using Data Reader
    DataTable
    DataSet, DataTable, DataReader, or an Object?

Read More.....

Tags- What is ASP NET and ADO Net? | What are the benefits of Ado net? | What is DataSet in Ado net with example? | What is ADO NET explain with diagram? | What is full form of Ado? | What is ADO NET stands for? | How does Ado Net work? | What is dataset in C#? | What is Linq C#? | What is Datareader in Ado net? | What is ADO NET components? | What is ADO What are its objects? | What is data adapter in Ado net? | What is dataset in asp net? | What are the ADO net objects? | What does OLE DB stand for? | Is Entity Framework an ORM? | What is Ajax in dot net? | What is Datatable in asp net? | What is ADO NET object model? | What is the difference between VB Net and Java? | What is the difference between connected and disconnected architecture in Ado net? | What is DAO in VB? | What is meant by Adodb? | What is ADO ASP? | What is data reader in asp net? | What is Entity Entity Framework? | What is ADO in VB net? | What is Adodb in VB? | What is RDO in VB? | What is RDO? | What is DAO and ADO? | What is ODBC in VB? | What is the difference between ODBC and JDBC? | What is a ODBC driver? | How do I set up ODBC? | How do I create an ODBC connection in SQL Server? | How do I open an ODBC file? | How do I create an ODBC connection in Access? | What's a DSN? | What is JDBC connection? | What is ODBC Data Source Administrator?



UpImage
Home|Indian Doctors|Indian Hospitals|Utility|Career|Electronics|Family|General|Health|PC Tips|Technology|About Us|About Admin|Feedback|Apply For Job Computer Courses|Login| Created by - Er. Sanjay Singh