Working with data and databases in C# certainly can be daunting if you’re coming from VB6, VBA, or Access. With this hands-on guide, you’ll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C#—basic skills you need if you intend to program with this language.
No previous knowledge of C# is necessary. By following the examples in this book, you’ll learn how to tackle several database tasks in C#, such as working with SQL Server, building data entry forms, and using data in a web service. The book’s code samples will help you get started on your own projects.
Create a Windows Forms application with a datagrid
Connect to multiple data sources, including Access and SQL Server
Add, edit, and update data in a database you choose and design
Enable users to choose their data source at runtime
Learn the roles of DataTable, DataView, BindingSource, Filters, and other objects
Understand where variables are declared and how they impact the code
Build a simple web service that connects to a database
Chapter 1 First Steps: Form with a Datagrid
Installing Software
Basic Syntax
What’s Next?
Chapter 2 C# Data Access to SQL Server
What’s Next
Chapter 3 Building Data Entry Forms
Binding a TextBox to Data
Simple Data Entry Form
Chapter 4 Creating Data Entry Forms with Built-In Controls
Michael Schmalz works in financial services and performs business and technology consulting in a variety of industries. He has done technical editing for O'Reilly on several Microsoft Office books and authored "Integrating Excel and Access" and "C# Database Basics". Michael has a degree in Finance from Penn State. He lives with his wife and children in Pennsylvania.
Finally a book that explains how to go from Access/VBA to C#. C# has the power I'm looking for but I would get frustrated with the time and complexity to build simple user apps. This book has helped me to understand how to make the jump without giving up what I have now.
