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

• Numerous code examples illustrate how to use ADO.NET with Microsoft’s SQL Server and Access databases.
• Step-by-step examples show how to develop ADO.NET-based Web applications and create Web services.
• Shows ADO.NET connectivity for MySQL, Oracle 8i/9i, Excel, Sybase, and text databases.
• What You Need to Know sections on the C# language, XML, and Windows Forms make it easy even for relative novices to get up to speed quickly.

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 a software developer with Kruse Inc., a document-management software company, and is also an MCP in Visual C++ 6.0. He’s the founder of both Mindcracker and C# Corner, a premier online resource for C# and .NET developers. Chand has a master’s degree in computer science and a bachelor’s degree in mathematics.