1 / 10

ADO.Net

>. 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

hunter
Download Presentation

ADO.Net

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. > ADO.Net

  2. 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

  3. How Do To Get ADO.Net • Part of .Net framework provided by Microsoft • Part of Visual Basic

  4. 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

  5. Goal • Leverage • Integrated XML support • Program • Create Tables • Build Applications

  6. What Makes Up .Net Core Additional Transaction CommandBuilder ConnectionStringBuilder Parameter Exception Error ClientPermission • Connection • Command • DataReader • DataAdapter • DataSet

  7. Connect to Database Providers • Oracle • SQL • Open Database Connectivity (ODBC) • Object Linking and Embedding Database (OLEDB) • EntityClient Provider • SQL Server Compact 4.0

  8. 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

  9. 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

  10. 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

More Related