A Programmer's Guide to ADO.NET in C#

ISBN-13: 9781893115392 / Angielski / Miękka / 2002 / 750 str.

Mahesh Chand; Michele LeRoux Bustamante; Mike Gold

Opis

This is the book on ADO.NET ADO.NET is the latest database technology from Microsoft and is the most powerful way to manipulate a database to date. A Programmer's Guide to ADO.NET in C# begins by taking readers through an overview of C# and then delves into ADO.NET. Mahesh Chand provides details on how to use each of .NET's major data providers, including OLE DB, SQL Server, and the release version of ODBC. This book also serves as a great reference for the methods and properties associated with these data providers' classes. In addition, Chand shows C# programmers how to work with XML classes, integrate XML into the ADO.NET architecture, and use the power of XML to transfer, read, and store data. A Programmer's Guide to ADO.NET in C# provides developers with handy ideas for taking advantage of the Visual Studio .NET IDE and for tying data to myriad, powerful Windows Forms and Web Forms, including the multifaceted DataGrid control. Chand also discusses how you can use ADO.NET to develop Web applications and create Web services. Easy-to-follow, visually rich examples illustrate how to create and execute stored procedures, work with triggers and views, create and update tables, and perform event handling in ADO.NET. Chand also guides you through the development of a Web-based guest book. About the Author: Mahesh Chand is presently engaged as a software developer with Kruse Inc. He has been working with Microsoft database technologies including ODBC, DAO, ADO, and OLEDB for over five years. He has a M.S. degree in Computer Science, a B.S. in Mathematics, and is also a Microsoft Certified Professional in VC]+. Mahesh is the founder of two Web sites: C# Corner, http: //www.c-sharpcorner.com, one of the largest community sites for .NET developers, and Mindcracker, http: //www.mindcracker.com.

Spis treści

1: Introduction to C#.- 2: Introduction to Windows Forms.- 3: Overview of ADO.NET.- 4: Data Components in Visual Studio .NET.- 5: ADO.NET Data Providers and Disconnected Classes.- 6: Working with XML.- 7: Developing Web Applications Using ADO.NET.- 8: Using Web Services with ADO.NET.- 9: Handling ADO.NET Events.- 10: Different Flavors of ADO.NET.- 11: Working with the ODBC .NET Data Provider.- Appendix A: Relational Databases: Some Basic Concepts.- Understanding Normalization.- Introducing Sets, Cursors, and ADO.NET.- Using Locking.- References and Resources.- Appendix B: Commonly Used SQL Statements.- Understanding SQL References.- Understanding Views.- Using SQL Server’s SELECT...FOR XML Clause.- References and Resources.