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

by Mahesh Chand

- The authors are the premier writers for the C-Sharp Corner Web Site, one of the most popular Web sites for .NET articles, examples, discussions, and jobs (www.c-sharpcorner.com) - This is one of the few books for C# programmers that focuses on databases and ADO.NET. - Contains numerous examples (code) that illustrate how to use ADO.NET with Microsoft's SQL Server and Access databases - and even includes an example that shows how to connect to the...

• Format: Paperback
• Language: English
• ISBN: 1893115399
• ISBN13: 9781893115392
• Release Date: April 2002
• Publisher: Apress
• Length: 718 Pages
• Weight: 2.85 lbs.
• Dimensions: 1.6" x 7.4" x 9.3"

Customer Reviews

Excellent

I absolutely agreed - This book is an excellent introduction for the developer new to ADO.NET. The book is geared towards the C# developer using VS.NET so if that doesn't describe you then you will want to look else where. If that does describe you then this is the book you want. The book starts with an introduction to C# which is probably good enough for someone familiar with Java or C++. This is followed by a brief introduction to ADO.NET and how to use VS.NET to build data driven applications. Chapter 5, the longest chapter in the book, is an excellent explanation of using ADO.NET disconnected classes and data providers. The author does an excellent job of explaining these critical topics. The book goes on to explain how XML documents fit into ADO.NET and follows this with a discussion of web applications, web services, and ADO events. The book contains a nice discussion of the ODBC data provider including how to install it into the VS.NET toolkit. This information is not easily found elsewhere. I especially like the author's style, which makes the book feel like a discussion with an enthusiastic co-worker rather than as a dry treatise. The book contains quite a few step-by-step, screen-by-screen examples of building applications. If you are (or plan to be) a C# developer and are new to ADO.NET you are unlikely to find a better book than this one for making this complex topic easily reachable. I start working with ASP.NET Web Services and Web Application and use MySQL as back end. I've seen couple of books but none of them provides good coverage on ODBC data provider. Author has done an exellent explaing database connectivity with various ODBC data sources. Good coverage of XML Services and intro to Web Applications. An above average book for ADO.NET, XML and Web database programmers. I agree with other reviewer that the author's style, which makes the book feel like a discussion with an enthusiastic co-worker rather than as a dry treatise. Normally you would think developing Web Services are a "BIG DEAL" but author explained in a way which makes Web services a "Peice of Cake". Based on this book, I wrote a Web service, which works as a Database Layer for my three ASP.NET applications to send data back and forth. Cheers!

The near perfect introduction to ADO.NET

This book is an excellent introduction for the developer new to ADO.NET. The book is geared towards the C# developer using VS.NET so if that doesn't describe you then you will want to look elsewhere. If that does describe you then this is the book you want. The book starts with an introduction to C# which is probably good enough for someone familiar with Java or C++. This is followed by a brief introduction to ADO.NET and how to use VS.NET to build data driven applications. Chapter 5, the longest chapter in the book, is an excellent explanation of using ADO.NET disconnected classes and data providers. The author does an excellent job of explaining these critical topics. The book goes on to explain how XML documents fit into ADO.NET and follows this with a discussion of web applications, web services, and ADO events. The book contains a nice discussion of the ODBC data provider including how to install it into the VS.NET toolkit. This information is not easily found elsewhere. I especially like the author's style, which makes the book feel like a discussion with an enthusiastic co-worker rather than as a dry treatise. The book contains quite a few step-by-step, screen-by-screen examples of building applications. If you are (or plan to be) a C# developer and are new to ADO.NET you are unlikely to find a better book than this one for making this complex topic easily reachable.

Absolutely Amazing

This is an excellent for both who are new to ADO.NET and for those that are making the transition from ADO to ADO.NET. The book covers all the important part of ADO.NET in detail to give the readers different concepts in approaching things. The parts of the book that really helped me out to understand and use ADO.NET are as follow with little description. Overview of ADO.NET - This gave me a short and sweet look at what ADO.NET is all about and why I should use it in my application and what are the advantages and disadvantages of ADO.NET over the old ADO. Working with XML - An excellent chapter that gave details about how to use XML and ADO.NET, it covered the important XML classes in detail and how XML can be beneficial in application to make things easier ASP.NET - This again made it short and sweet in a nutshell on how to get started in using ASP.NET using of course, ADO.NET Web Services - I had never even looked at web services before I read this chapter, now I can safely say I got a very good understanding on what they are all about and why we would use them as well as how to easily write web services with the chapter written in this book. Different Flavors - Information in this section I will not use on daily basic but it never hurts to know what other things ADO.NET can do for those that want to explore different aspects of it. Handling Events - Another short and sweet chapter right on the money ODBC.NET - This chapter is definitely recommended for those that are working with non Microsoft databases, even things like Microsoft Excel and Flat files. Excellent chapter as far as explaining how to work with Oracle, Sybase and MySQL. Overall I definitely recommend this book for anyone writing database applications or simply those that want to know what they are getting themselves into as far as databases go. Most of the software I write involve database interaction so I will be using this book a lot to understand different aspects. Again, definitely recommended - 5 Stars *****

Good. I Guess

Good to write Windows and Web database applications. After reading it takes no time to write applications. Few things: ... says two authors but there is only one author. Author could've done a better job covering ADO.NET classes in more depth. I found good ceverage on couple of topics and some of them are XML Coverage, ODBC, ADO.NET Events handling. For beginners to intermediate programmers, not bad at all.

Detailed Review

I was reading this review in .Net Programmer's Magazine and found it useful. Here is some of it in case any body is interested. Overall good book for ADO.NET Beginners. Cheers!- MaxUnderstanding Basics First three chapters of this book are for beginners, who have no idea of C# and ADO.NET. Chapter 1 and chapter 2 of this book are for beginners, who are migrating to C# from other languages specially C++, VB or Java. Chapter 1 covers basic syntaxes of C# language and Chapter 2 shows how to develop Windows applications using Windows Forms and Visual Studio .NET. Chapter 3 is the chapter, which I liked a lot. This is a small chapter, but this is where author clears every concept of ADO.NET, its architecture and its components. I like author's graphical approach, which I don't find in other books. Author explains each and every component of ADO.NET architecture graphical and shows how all components fit together and builds ADO.NET, one of the best database access technology developed by Microsoft so far.Chapter 4 of the book is totally dedicated to visual ADO.NET components and Visual Studio .NET. Author shows how you can take advantage of Visual Studio .NET's rich features including Server Explorer, Data-bound controls, Data Form Wizard and so on.ADO.NET Disconnected classes and Data Providers Chapter 5 is the most important and biggest chapter of the book. In this chapter, author shows you the broad view of ADO.NET architecture and basic building blocks of ADO.NET and ADO.NET data providers. Author has divided this chapter into two parts. First part covers disconnected classes such as DataSet, DataTable, DataColumn and DataRow and how to use them in a disconnected manner. The second part of the chapter covers OleDb and Sql data providers, their components and how to write applications using Sql Server and Acccess databases. In this chapter, author goes from one component to other one by one by starting from the Connection component, followed by Command, DataAdapter, DataReader and so on. XML and ADO.NET 6th Chapter of the book covers XML and ADO.NET. Author starts this chapter with a brief introduction of XML followed by reading, writing, deleing, searching, and navigating through XML documents. The second part of this chapter shows the relationship between ADO.NET and XML. Again, author's visual oriented approach clears many concepts, which are hard to understand by just reading few pages. Web Development and ADO.NET Chapter 7 and Chapter 8 are dedicated to Web development and ADO.NET. In these chapters, authors first clears basic concepts of ASP.NET model and shows how to write simple Web applications using ASP.NET and Visual Studio .NET. After that author shows how to use ASP.NET DataGrid and other data-bound controls to develop database applications using ADO.NET. Author also shows how to develop a Guest book application. Another application shows how to write Web applications which lets you add, edit and update data through Web pages. Chapter 8