+612 9045 4394
A Programmer's Guide to ADO.NET in C# : Expert's Voice - Mahesh Chand

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

Expert's Voice

Paperback Published: 25th April 2002
ISBN: 9781893115392
Number Of Pages: 740

Share This Book:


or 4 easy payments of $31.26 with Learn more
Ships in 7 to 10 business days

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.

Forewordp. xi
About the Authorp. xiv
About the Technical Reviewerp. xv
Acknowledgmentsp. xvi
Introductionp. xvii
Introduction to C#p. 1
Understanding the C# Languagep. 1
Writing Your First C# Program: "Hello, C# World!"p. 6
Understanding C# Componentsp. 7
Summaryp. 68
Introduction to Windows Formsp. 69
Design-Time versus Run-Time Developmentp. 69
Writing a Command-Line Windows Forms Applicationp. 70
Writing a Windows Forms Application Using the VS .NET IDEp. 78
Windows.Forms Namespacep. 100
Summaryp. 121
Overview of ADO.NETp. 123
What Is ADO.NET?p. 123
Why ADO.NET Was Designedp. 125
Advantages of ADO.NETp. 126
Comparing ADO.NET and ADOp. 128
Overview of ADO.NET Namespaces and Classesp. 129
Understanding ADO.NET Componentsp. 132
Writing ADO.NET Applicationsp. 138
Creating a Sample ADO.NET Applicationp. 142
Writing a Simple ADO.NET Program with Visual Studio .NET IDEp. 145
Summaryp. 151
Data Components in Visual Studio .NETp. 153
Creating Your ADO.NET Projectp. 153
Using the Server Explorerp. 154
Using Visual Data Componentsp. 162
Using DataSet and DataView Componentsp. 199
Using the Data Form Wizardp. 208
Data Form Wizard: Looking under the Hoodp. 223
Summaryp. 227
ADO.NET Data Providers and Disconnected Classesp. 229
Looking at the ADO.NET Architecturep. 230
Exploring the ADO.NET Class Hierarchyp. 232
Understanding ADO.NET Disconnected Classesp. 237
Using DataSet, DataView, and DataViewManagerp. 273
Using ADO.NET Data Providersp. 279
Summaryp. 353
Working with XMLp. 355
Defining XML-Related Terminologyp. 355
XML Overviewp. 359
DOM Overviewp. 372
Microsoft .NET and XMLp. 375
Reading XMLp. 380
The XmlWriter Classesp. 388
The XmlConvert Classp. 393
Understanding the DOM Implementationp. 393
Transformation and XSLTp. 402
ADO.NET and XMLp. 405
Navigation in XMLp. 415
Visual Studio .NET and XML Supportp. 420
Summaryp. 433
Developing Web Applications Using ADO.NETp. 435
Introducing ASP.NETp. 435
Understanding Web Forms and Web Servicesp. 437
Developing Your First ASP.NET Web Applicationp. 438
Creating Your First ADO.NET Web Applicationp. 450
Using ASP.NET Server-Side Controlsp. 455
Data Binding in ASP.NETp. 462
Creating a Guest Book in ASP.NETp. 478
Paging in DataGrid Controlp. 490
Adding, Editing, and Deleting Data in Web Formsp. 496
Introducing the Table Web Controlp. 503
Summaryp. 509
Using Web Services with ADO.NETp. 511
Exploring Web Services and the .NET Framework Libraryp. 512
Creating a Web Service in VS .NETp. 512
Testing Your Web Servicep. 521
Creating the Web Service Consumerp. 525
Executing Asynchronous Web Servicesp. 539
Summaryp. 543
Handling ADO.NET Eventsp. 545
Introducing ADO.NET Eventsp. 545
Summaryp. 570
Different Flavors of ADO.NETp. 573
Working with Stored Procedures and Viewsp. 573
COM Interoperabilityp. 594
Using the ADO Recordset in ADO.NETp. 595
Using ADOX with ADO.NETp. 598
Accessing OLAP Server Data with ADO.NETp. 600
Summaryp. 612
Working with the ODBC .NET Data Providerp. 613
Understanding the ODBC .NET Data Providerp. 613
Accessing MySOL Databasesp. 621
Accessing Text File Databasesp. 633
Accessing Excel Databasesp. 641
Working with Oracle Databasesp. 644
Working with Sybase Databasesp. 651
Summaryp. 652
Relational Databases: Some Basic Conceptsp. 653
Understanding Normalizationp. 654
Introducing Sets, Cursors, and ADO.NETp. 660
Using Lockingp. 661
References and Resourcesp. 666
Commonly Used SOL Statementsp. 667
Understanding SOL Referencesp. 667
Understanding Viewsp. 680
Using SOL Server's SELECT...FOR XML Clausep. 682
References and Resourcesp. 682
Indexp. 685
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9781893115392
ISBN-10: 1893115399
Series: Expert's Voice
Audience: General
Format: Paperback
Language: English
Number Of Pages: 740
Published: 25th April 2002
Publisher: Apress
Country of Publication: US
Dimensions (cm): 23.6 x 18.85  x 4.04
Weight (kg): 1.22