Flylib.com

Books Software

 
 
 

Chapter 5: Handling ADO.NET Events


Chapter 5: "Handling ADO.NET Events"

Events are useful for notifying you when some action happens to an object. An event can have a method associated with it. Not too many books cover the ADO.NET events in details. This chapter shows you how you can handle events for ADO.NET objects. It covers almost every ADO.NET data component event and how to use them in your applications.



Chapter 6: "Integrating XML with ADO.NET"

This chapter begins with the introduction of the classes provided by the .NET Framework Library to work with Extensible Markup Language (XML) documents. This chapter discusses how to read from and write to XML documents using the .NET Framework Library classes. After that it discusses how to navigate through XML documents. The chapter also discusses XML transformations. In addition, this chapter covers the relationship between ADO.NET and XML and shows how to mix them up and use rich ADO.NET database components to display and manipulate XML data. Finally, this chapter covers the XPathNavigator class, which navigates XML documents.



Chapter 7: "Data Binding and Windows Forms Data-Bound Controls"

Data-bound controls are not only ease to use, but they also provide many built-in features that programmers will find useful. This chapter discusses the basics of data binding and data-bound controls, as well as how to develop interactive Graphical User Interface (GUI) database applications using these controls in minimal time and with minimal effort. This chapter covers how to use Windows controls such as the TextBox , Button , Label , CheckBox , ComboBox , ListBox , and DataGrid controls in the data-binding process and how to write your custom data-bound applications to navigate through the records of a data source. In this chapter, you'll learn some data-binding techniques that are hard to find in other ADO.NET books.



Chapter 8: "Constraints and Data Relations"

This chapter discusses constraints and data relations in detail. First, this chapter starts with a discussion of constraints and how ADO.NET constraint objects maintain data integrity. The second part of this chapter discusses data relations.



Chapter 9: "ADO.NET Exception Handling"

Exception and error handling is one of the most important parts of writing reliable and error-prone applications. If you come from a C++ background, you're probably familiar with different exceptional handling methods such as C++ exceptional handling, structured exceptional handling, and Microsoft Foundation Classes (MFC) exceptions. If you come from a Visual Basic background, you're probably familiar with the On Error statement. Besides the exception handling in previous versions of VC++ and Visual Basic, .NET implements exceptions in a different way, and all .NET-supported languages (C# and VB .NET) share the same mechanism. Now Visual Basic developers can enjoy the same rich exception handling C++ developers have enjoyed. Discussing .NET exception handling is beyond the scope of this book; this chapter concentrates on ADO.NET exception handling classes.



Chapter 10: "Working with the ODBC .NET Data Provider"

This chapter discusses the ODBC .NET data provider and how to work with various data sources such as Access, MySQL, Excel, and text using the ODBC data provider.



Chapter 11: "Stored Procedures and Views"

Stored procedures and views are another important aspect of database programming. This chapter discusses how you can take advantage of VS .NET tools to work with these objects.