Practical Database Programming With Visual C#.NET

by
Edition: 1st
Format: Paperback
Pub. Date: 2010-04-05
Publisher(s): Wiley-IEEE Press
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $153.38

Buy New

Arriving Soon. Will ship when available.
$146.08

Rent Textbook

Select for Price
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$132.00
$132.00

Used Textbook

We're Sorry
Sold Out

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

This book is mainly designed for college students who take the database programming course in the Visual Studio.NET environment and want to learn both fundamental knowledge and practical techniques in designing and building of professional database program applied in real commercial and industrial applications in Visual C#.NET. The proposed book provides a detailed description about the practical considerations and applications in database programming with Visual C#.NET 2008 with authentic examples and detailed explanations. More important, a new writing style is developed and implemented in this book, combined with real examples, to provide readers with a clear picture as how to handle the database programming issues in Visual C#.NET 2008 environment.Unlike most other Visual C# database programming books in the current market, which discuss and present the database programming techniques with huge blocks of programming codes from the first page to the last page, this proposed book tries to use a new writing style to show readers, especially to the college students, how to develop professional and practical database programs in Visual C#.NET 2008 environment by using Visual Studio.NET 2008 Design Tools and Wizards related to ADO.NET 3.5, and to apply and manage codes that are auto-generated by using Wizards. By using this new style, the over headache caused by using those huge blocks of programming codes can be removed. Instead, a simple and easy way to create database programs using the wizards can be developed to attract students' learning interest, reducing the learning curve and furthermore to enable students to build professional and practical database programming in more efficient and interesting ways.

Author Biography

Dr. Ying Bai is an Associate Professor in the Department of Computer Science and Engineering at Johnson C. Smith University (JCSU). Before joining JCSU, Dr. Bai worked as a senior software engineer in the field of automatic control and testing equipment in Silicon Valley, California, and Columbus, Ohio. He has a great deal of experience in robotics control, robot calibrations, and related software programming, as well as accurate measurements in industrial and academic fields. Dr. Bai is a Senior Member of IEEE and a member of ACM. In recent years, he has published six books in multi-language interface programming, serial port programming, electronics, fuzzy logic technology, and database programming with Visual Basic.NET.

Table of Contents

Preface
Acknowledgement
Introduction
Introduction to Databases
What are databases and database programs
Develop a Database
Sample Database
Identifying Keys
Define Relationships
ER Notation
Data Normalization
Database Components in Some Popular Databases
Create Microsoft Access Sample Database
Create Microsoft SQL Server 2005 Sample Database
Create Oracle 10g XE Sample Database
Homework
Introduction to ADO.NET
The ADO and ADO.NET
Overview of the ADO.NET 2.0
The Architecture of the ADO.NET 2.0
The Components of ADO.NET 2.0
Homework
Introduction to Language Integrated Query (LINQ)
Overview of Language Integrated Query
Introduction to LINQ Query
The Architecture and Components of LINQ
LINQ to Objects
LINQ to DataSet
LINQ to SQL
LINQ to Entities
LINQ to XML
C# 3.0 Language Enhancement for LINQ
Homework
Data Selection Query with Visual C#.NET
Data Query with Visual Studio Design Tools and Wizards
A Completed Sample Database Application Example
Visual Studio.NET 2008 Design Tools and Wizards
Build a Sample Database Project - SelectWizard with SQL Server Database
Add and Utilize Visual Studio.NET Wizards and Design Tools
Query and Display Data using the DataGridView Control
Use DataSet Designer to Edit the Structure of the DataSet
Bind Data to Associated Controls in LogIn Form
Develop Codes to Query Data Using the Fill() Method
Use Return a Single Value to Query Data for LogIn Form
Coding for the Selection Form
Bind Data to the Associated Controls in Faculty Form
Develop Codes to Query Data From the Faculty Table
Display Pictures for Faculty Form
Binding Data to Associated Controls in Course Form
Develop Codes to Query Data for Course Form
Build a Sample Database Project - SelectWizardOracle with Oracle Database
Data Query with Runtime Objects
Introduction to Runtime Objects
Query Data Using Runtime Object to Microsoft Access 2007 Database
Query Data Using Runtime Object to SQL Server Database
Query Data Using Runtime Object to Oracle Database
Homework
Data Inserting with Visual C#.NET
Data Inserting with Visual Studio.NET Design Tools and Wizards
Insert New Data Into a Database
Insert Data into the Microsoft Access Database Using a Sample Project InsertWizard
Insert Data into the SQL Server Database Using a Sample Project SQLInsertWizard
Insert Data into the Oracle Database Using a Sample Project OracleInsertWizard
Data Insertion with Runtime Objects
The General Run Time Objects Method
Insert Data into the SQL Server Database Using the Run Time Object Method
Insert Data into the Microsoft Access Database Using the Run Time Objects
Insert Data into the Oracle Database Using the Run Time Objects
Insert Data into the Database Using the LINQ Queries
Insert Data into the Database Using Stored Procedures
Homework
Data Updating and Deleting with Visual C#.NET
Data Updating and Deleting with Visual Studio.NET Design Tools and Wizards
Update or Delete Data Against Databases
Update and Delete Data for Microsoft Access Database
Update and Delete Data For SQL Server Database
Update and Delete Data For Oracle Database
Data Updating and Deleting with Runtime Objects
The Run Time Objects Method
Update and Delete Data For SQL Server Database Using the Run Time Objects
Update and Delete Data for Oracle Databases Using the Run Time Objects
Update and Delete Data Against Database Using Stored Procedures
Update and Delete Data against Databases Using the LINQ to SQL Query
Homework
Accessing Data in ASP.NET
What is .NET Framework
What is ASP.NET and ASP.NET 3.5: 636
Develop ASP.NET Web Application to Select Data from SQL Server Databases
Develop ASP.NET Web Application to Insert Data Into SQL Server Databases
Develop Web Applications to Update and Delete Data in SQL Server Databases
Develop ASP.NET Web Applications with LINQ to SQL Query
Develop ASP.NET Web Application to Select Data from Oracle Database
Develop ASP.NET Web Application to Insert Data Into Oracle Database
Develop ASP.NET Web Application to Update and Delete Data in Oracle Databases
Homework
ASP.NET Web Services
What Are Web Services and Their Components
Procedures to Build a Web Service
Build ASP.NET Web Service Projects to Access SQL Server Database
Build ASP.NET Web Service Project to Insert Data Into SQL Server Database
Build ASP.NET Web Service to Update and Delete Data for SQL Server Database
Build Windows-Based Web Service Clients to Consume the Web Services
Build Web-Based Web Service Clients to Consume the Web Services
Build ASP.NET Web Service Project to Access Oracle Database
Build Web Service Clients to Consume the Web Service - WebServiceOracleSelect
Build ASP.NET Web Service Project to Insert Data Into Oracle Database
Build Web Service Clients to Consume the Web Service - WebServiceOracleInsert
Build ASP.NET Web Service to Update and Delete Data for Oracle Database
Build Web Service Clients to Consume the Web Service
Homework
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.