Beginning C# Databases - From Novice to Professional

List of 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.

Summary

No matter what programs you develop, there always exists a bottom line: you must know how to access and manipulate data. While data can be stored in many places, large quantities of frequently accessed data must be structured appropriately in relational databases like SQL Server. Meanwhile, data access in .NET is achieved through the ADO.NET classes—which essentially replace ActiveX Data Objects (ADO), combining ADO-style ease with the power of XML.

Product details

• Authors: Scott Allen, Syed Fahad Gilani, Jacob Hammer Pedersen, James Huddleston, Ranga Raghuram, Jon Reid
• Publisher: Springer EN
• Languages: English
• Product format: Paperback / Softback
• Released: 19.11.2004
• EAN: 9781590594339
• ISBN: 978-1-59059-433-9
• No. of pages: 648
• Dimensions: 178 mm x 235 mm x 34 mm
• Weight: 1197 g
• Illustrations: XXIV, 648 p.
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > IT; B, windows, Software Engineering, sql, xml, C#, Database Management, Software Engineering/Programming and Operating Systems, Programming, database programming, Professional and Applied Computing, Databases, relational database, structured design