Build your expertise as you move beyond the basics—and delve into the essential topics of programming with ADO.NET 2.0. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C# and Visual Basic to help advance your mastery of developing database applications for Microsoft Windows and the Web.
Discover how to:
- Work with design-time data access features in Microsoft Visual Studio 2005
- Use Microsoft .NET Framework 2.0 data providers to connect to databases
- Build connection strings and enable connection pooling
- Execute queries, including parameterized and asynchronous queries, and retrieve their results
- Create DataSet objects to work with offline data and explore common usage scenarios
- Use the new Common Language Runtime features and XML data type in Microsoft SQL Server 2005
- Generate logic and use stored procedures for simple to advanced updating scenarios
- Design Web applications with new data access features in ASP.NET 2.0—including code-free data-binding capabilities
PLUS—Get Visual Basic and C# code samples, and a Microsoft .NET Data Provider on the Web
|Series:||Developer Reference Series|
|Edition description:||2005 ed.|
|Product dimensions:||7.44(w) x 9.36(h) x 1.48(d)|
About the Author
David Sceppa is a program manager on the SQL Server® team at Microsoft and an expert on ADO.NET. As a former technical lead in the Microsoft Developer Support group, he helped customers build database applications with Visual Basic and Microsoft Visual FoxPro®. David is MCSD certified in Microsoft .NET and has a background in teaching.
Most Helpful Customer Reviews
Wow, this is the book I was looking for! David Sceppa did a great job on this book. Programming Microsoft ADO.NET 2.0 is very easy to understand and has a lot of code samples that I can use in my production environment. I learned how to loop through data using ado.net and inserting, updating, and deleting using stored procedures with ado.net. On page four-hundred fifty three came in handy "Submitting Updates Using Parameterized SqlCommands". I love the way it shows you in VB and C Sharp. The book also talks about xml documents which is very helpful too in my case. The book is for reference only I would recomend the book to beginners and advanced users. Most of the samples here use SQL Server Express edition which is free to download at the microsoft site. If you are looking to learn t-sql also this is not the book for you. You will need to buy a t-sql book. Thank you David Sceppa and Microsoft Press I am very impressed with this book.