C# Database Basics: Moving From Visual Basic And Vba To C# by Michael SchmalzC# Database Basics: Moving From Visual Basic And Vba To C# by Michael Schmalz

C# Database Basics: Moving From Visual Basic And Vba To C#

byMichael Schmalz

Paperback | February 10, 2012

Pricing and Purchase Info


Earn 130 plum® points

Prices and offers may vary in store


In stock online

Ships free on orders over $25

Not available in stores


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
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 wif...
Title:C# Database Basics: Moving From Visual Basic And Vba To C#Format:PaperbackDimensions:110 pages, 9.19 × 7 × 0.23 inPublished:February 10, 2012Publisher:O'Reilly MediaLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1449309984

ISBN - 13:9781449309985


Table of Contents

Preface; Objectives; Conventions Used in This Book; Using Code Examples; Safari® Books Online; How to Contact Us; Chapter 1: First Steps: Form with a Datagrid; 1.1 Installing Software; 1.2 Basic Syntax; 1.3 What's Next?; Chapter 2: C# Data Access to SQL Server; 2.1 What's Next; Chapter 3: Building Data Entry Forms; 3.1 Binding a TextBox to Data; 3.2 Simple Data Entry Form; Chapter 4: Creating Data Entry Forms with Built-In Controls; Chapter 5: Data in a Web Service; 5.1 Writing a Web Service; 5.2 What's Next; Chapter 6: Editing Access Data on the Web; 6.1 What's Next?; Chapter 7: Additional C# and Database Topics; 7.1 Referring to Connection Strings; 7.2 Building Strings with Database Data; 7.3 Reporting; 7.4 Exporting Tables to XML; 7.5 Wrap-Up;