Article Options
Premium Sponsor
Premium Sponsor

 »  Home  »  .NET Newbie  »  ADO.NET for Beginners Part Two  »  Conclusion
 »  Home  »  Data Programming  »  ADO.NET  »  ADO.NET for Beginners Part Two  »  Conclusion
ADO.NET for Beginners Part Two
by David Jeavons | Published  07/18/2006 | .NET Newbie ADO.NET | Rating:
David Jeavons
I have been programming database applications for almost 12 years starting out with VB3 and using every major version since then. I currently work for a retailer analysis company writing ASP.NET code for our ever evolving web site. I also enjoy helping other programmers with Visual Basic and .NET and am a moderator at vbCity. 

View all articles by David Jeavons...
Conclusion

We now have a fully functional AddressBook program that we can use to store, manage and search our contacts. During this tutorial we have learnt what objects are used to retrieve the data using the OleDbDataAdapter and OleDbDataReader objects and the objects used to manage the data via the use of the OleDbCommand object. We have also learnt how we can filter data without having to re-query the database each time, and did this by using the DataView object.

Further Improvements

This project could be improved in numerous ways. The first most obvious improvement is to provide the user with the ability to add and edit all fields in the Contacts table. Another improvement would be to introduce some exception handling routines to the code (which I left out intentionally for space reasons) in order to gracefully handle any exceptions that may occur.

Whether you decide to finish the project to make it more complete or move onto your next killer app, the information in this article will have hopefully given you an introduction to and understanding of working with databases using ADO.NET.

In Part three, which will be published later this year, I will use an SQL Server database and show you how to use Stored Procedures to access and modify the data. The user interface and functionality will remain the same, only the database used will change.

How would you rate the quality of this article?
1 2 3 4 5
Poor Excellent
Tell us why you rated this way (optional):

Article Rating
The average rating is: No-one else has rated this article yet.

Article rating:3.65445026178013 out of 5
 191 people have rated this page
Article Score57984
Sponsored Links