Flylib.com
Database Access with Visual Basic .NET (3rd Edition)
Database Access with Visual Basic .NET (3rd Edition)
ISBN: 0672323435
EAN: 2147483647
Year: 2003
Pages: 97
Authors:
Jeffrey P. McManus
,
Jackie Goldstein
BUY ON AMAZON
Main Page
Table of content
Copyright
Preface
Who This Book Is For
How This Book Is Organized
The Software Environment
Keeping in Touch
About the Authors
About the Contributor
About the Technical Reviewers
Acknowledgments
Chapter 1. Database Basics
What Is a Database?
Business Cases
Tables and Fields
Manipulating Data with Objects
Data Types
Creating a Database Schema
Relationships
Normalization
Creating a User Interface in a Windows Forms Application
Summary
Chapter 2. Structured Query Language Queries and Commands
What Is a Query?
Testing Queries with the Server Explorer
Retrieving Records with the SELECT Clause
Designating a Record Source with the FROM Clause
Specifying Criteria with the WHERE Clause
Sorting Results with ORDER BY
Displaying the Top or Bottom of a Range with TOP
Joining Related Tables in a Query
Performing Calculations in Queries
Aliasing Field Names with AS
Queries That Group and Summarize Data
Union Queries
Subqueries
Manipulating Data with SQL
Using Data Definition Language
Summary
Chapter 3. Getting Started with SQL Server 2000
Setting Up and Running Microsoft SQL Server 2000
Getting Started with SQL Server 2000: The Basics
Summary
Chapter 4. ADO.NETData Providers
Overview of ADO.NET
Overview of .NET Data Provider Objects
The Connection Object
The Command Object
The DataReader Object
Using the Connection and Command Design-Time Components
Other Data Provider Objects
Summary
Chapter 5. ADO.NETThe DataSet
Applications and Components of the DataSet
Populating and Manipulating the DataSet
Using the DataSet Component
Summary
Chapter 6. ADO.NETThe DataAdapter
Populating a DataSet from a Data Source
Updating the Data Source
Summary
Chapter 7. ADO.NETAdditional Features and Techniques
Detecting Concurrency Conflicts
Table and Column Mappings
DataViews
Strongly Typed DataSet s
Summary
Chapter 8. Visual Studio.NET Database Projects
Creating a Database Project
Database References
Scripts
Queries
Summary
Chapter 9. XML and .NET
An Overview of XML
XML Classes in .NET
Extending SQL Server with SQLXML 3.0 and IIS
Using XML, XSLT, and SQLXML to Create a Report
Summary
Chapter 10. ADO.NET and XML
Basic Reading and Writing of XML
Creating an XmlReader from a Command Object
The XmlDataDocument Object
Summary
Chapter 11. WebForms: Database Applications with ASP.NET
An Overview of ASP.NET
Accessing a Database Through ASP.NET
Improving the Performance of ASP.NET Database Applications Through Stored Procedures
Summary
Chapter 12. Web Services and Middle-Tier Technologies
Using the Middle Tier to Provide Presentation Logic
Using Data in the Middle Tier
Exposing Objects Through Web Services
Putting It All Together
Summary
Database Access with Visual Basic .NET (3rd Edition)
ISBN: 0672323435
EAN: 2147483647
Year: 2003
Pages: 97
Authors:
Jeffrey P. McManus
,
Jackie Goldstein
BUY ON AMAZON
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Connecting to an Access Databasefrom ASP.NET
Passing Null Values to Parameters
Using Auto-Incrementing Columns Without Causing Conflicts
Using Manual Transactions
Getting a SQL Server Query Plan
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 1.1 Install OpenSSH to Replace the Remote Access Protocols with Encrypted Versions
Step 3.2 Use PuTTY / plink as a Command Line Replacement for telnet / rlogin
Step 4.6 How to use PuTTY Passphrase Agents
Step 5.1 General Troubleshooting
Conclusion
Adobe After Effects 7.0 Studio Techniques
Alpha Channels and Premultiplication
Optimizing After Effects
Optimizing Tracking Using 3D
Conclusion
Battle of the Color Spaces
MySQL Clustering
Obtaining, Installing, and Configuring MySQL Cluster on Other Platforms
Backup and Recovery
Security and Management
Physical Factors
Load Balancing and Failover
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
The Functional Triad Computers in Persuasive Roles
Computers as Persuasive Media Simulation
Increasing Persuasion through Mobility and Connectivity
The Ethics of Persuasive Technology
Captology Looking Forward
User Interfaces in C#: Windows Forms and Custom Controls
Classic Controls
Modern Controls
Data Controls
GDI+ Basics
GDI+ Controls
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies