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
Sprache
Verlagsort
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Maße
Höhe: 234 mm
Breite: 177 mm
Dicke: 12 mm
Gewicht
ISBN-13
978-1-4493-0998-5 (9781449309985)
Schweitzer Klassifikation
Michael Schmalz has worked for a variety of banks, including MBNA, and teaches Excel and Access at Penn State. He currently spends most of his time as a consultant, focused on improving business analysis with desktop and database tools.
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;
