ado net
Download
Skip this Video
Download Presentation
ADO.Net

Loading in 2 Seconds...

play fullscreen
1 / 10

ADO.Net - PowerPoint PPT Presentation


  • 158 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
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
slide5
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