Full Description
No matter what programs you develop, there always exists a bottom line: you must know how to access and manipulate data. This book teaches you all the essential data manipulation skills that you will need when you code in C#.
Data can be stored in many places, but large quantities of data that need to be frequently accessed are usually stored in relational databases such as SQL Server. Knowing how this data is structured, and how to access and update it, are therefore the most important programming tasks the professional programmer needs to learn.
As well as teaching you database basics, such as using SQL to communicate with databases, this book provides you with detailed and code-practical techniques to access data in C# across a wide range of specific coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 1.1 and offers you the best contemporary practice in this core programming area that you'll find yourself using in nearly all of your .NET projects.
Contents
Installing MSDE.- A Simple Data-driven App.- Introducing SQL.- What is ADO.NET?- Connecting to the Database.- Getting the Data.- Using the DataReader.- The DataSet and DataAdapter.- Data and Windows Applications.- Using Data in ASP.NET Pages.- Validating User Input.- Tables and Relationships.- More About SQL.- Views and Stored Procedures.- Indexes and Constraints.- Database Security.- ADO.NET and XML.- Handling ADO.NET Errors.- Transactions.- ADO.NET Events.- Irregular Data.- Data Practice in VS2005.- Appendix A: Custom Query Tool.- Appendix B: XML Primer.
