Ado net
Download
1 / 10

ADO.Net - PowerPoint PPT Presentation


  • 160 Views
  • Uploaded on

>. ADO.Net. What is Ado.Net ?. Microsoft A ctiveX D ata O bjects Programming interface to access data in a database and update, manipulate or retrieve information Automatically installed as Part of Microsoft .NET Framework Simply-Set of Classes or Frameworks

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'ADO.Net' - hunter


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Ado net

>

ADO.Net


What is ado net
What is Ado.Net?

  • Microsoft ActiveX Data Objects

  • Programming interface to access data in a database and update, manipulate or retrieve information

  • Automatically installed as Part of Microsoft .NET Framework

  • Simply-Set of Classes or Frameworks

  • Library for accessing Databases


How do to get ado net
How Do To Get ADO.Net

  • Part of .Net framework provided by Microsoft

  • Part of Visual Basic


Types of net apps
Types of .Net Apps

  • Can connect to a database using ADO.NET to execute, run, retrieve and modify information:

    • ASP.NET Web Application

    • Windows Application

    • Console Application


Ado net
Goal

  • Leverage

  • Integrated XML support

  • Program

  • Create Tables

  • Build Applications


What makes up net
What Makes Up .Net

Core

Additional

Transaction

CommandBuilder

ConnectionStringBuilder

Parameter

Exception

Error

ClientPermission

  • Connection

  • Command

  • DataReader

  • DataAdapter

  • DataSet


Connect to database providers
Connect to Database Providers

  • Oracle

  • SQL

  • Open Database Connectivity (ODBC)

  • Object Linking and Embedding Database (OLEDB)

  • EntityClient Provider

  • SQL Server Compact 4.0


How to connect to a database
How to Connect to a Database

  • Create an ADO connection to a database

  • Open the database connection

  • Create an ADO dataset

  • Open the dataset

  • Extract the data you need from the dataset

  • Close the dataset

  • Close the connection


Connection syntax
ConnectionSyntax

.xxxFile

Compile and Run ADO.Net

http://msdn.microsoft.com/en-us/library/dw70f090(v=vs.71).aspx

  • Import/usingSystem.Data.Odbc

  • Import/usingSystem.Data.EntityClient

  • Import/usingSystem.Data.SqlServerCe

  • Import/usingSystem.Data.SqlClient

  • Import/usingSystem.Data.OracleClient

  • Import/usingSystem.Data.OleDb


Helpful links
Helpful Links

  • w3schools

  • http://www.w3schools.com/ADO/ado_ref_connection.asp

  • Microsoft

  • http://msdn.microsoft.com/en-us/library/h43ks021(v=vs.71).aspx

  • http://msdn.microsoft.com/en-us/library/32c5dh3b(v=vs.71).aspx


ad