SF State ISYS 546 - Introduction to ADO.Net, VB.Net Database Tools and Data Binding (40 pages)

Previewing pages 1, 2, 3, 19, 20, 38, 39, 40 of 40 page document View the full content.
View Full Document

Introduction to ADO.Net, VB.Net Database Tools and Data Binding



Previewing pages 1, 2, 3, 19, 20, 38, 39, 40 of actual document.

View the full content.
View Full Document
View Full Document

Introduction to ADO.Net, VB.Net Database Tools and Data Binding

109 views


Pages:
40
School:
San Francisco State University
Course:
Isys 546 - Client Server Db App Dev
Client Server Db App Dev Documents

Unformatted text preview:

Introduction to ADO Net VB Net Database Tools and Data Binding ISYS546 Steps to Retrieve Data Establishes a connection to the database Executes commands against the database Store data results A Simplified View of ADO Net Objects Ado Net Data Provider Adapter Connection Data Consumer Dataset WinForm Command Reader WebForm ADO NET Objects Connection Object Represent a connection to the database Command Object The command object allows us to execute a SQL statement or a stored procedure DataReader It is a read only and forward only pointer into a table to retrieve records DataSet Object A DataSet object can hold several tables and relationships between tables DataAdapter This the object used to pass data between the database and the dataset Data Providers ODBC Provider Open Database Connectivity A driver manager Used for relational databases OLE DB Provider OLE DB interfaces provide applications with uniform access to data stored in diverse information sources or data stores Access SQL Server Provider Oracle Provider Using ODBC Windows XP Control Panel Administrative Tools DataSource ODBC Three types of data source names User DSN usable only by you and only on the machine currently using System DSN Any one using the machine can use File DSN Can be copied and used by other computers with the same driver installed VB NET Database Tools Database connection Tools Connect to database Data Source Server Explorer Data connections Right click data connection Add Connection Tables Views Create new SQL Server Database Toolbox Data tab Data Add New Data Source Creating SQL Server Database From Server Explorer right click data connection and choose Create new SQL Server Database Server name LocalServerName SQLExpress Add new table Right click Tables and choose Add New Table Add rows Right click the table name and choose Show table data How to create an ADO Net object Automatically generated when creating data bound form Form wizard Using Data Adapter Wizard Using code Example dim



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Introduction to ADO.Net, VB.Net Database Tools and Data Binding and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Introduction to ADO.Net, VB.Net Database Tools and Data Binding and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?