Murach's C# 2008
How to work with data sources and datasets

Visual Studio 2008 has some powerful tools for rapid application development and prototyping of database applications. So in this chapter, you'll get started with database programming by learning how to use the data sources feature to create applications that let you view and maintain the database data.

Chapter 18 How to work with data sources and datasets
How to create a data source 532
How to use the Data Sources window 532
How to start the Data Source Configuration Wizard 534
How to choose a data source type 534
How to choose the connection for a data source 536
How to create a connection to a database 538
How to save a connection string in the app.config file 540
How to choose database objects for a data source 542
The schema file created by the Data Source Configuration Wizard 544
How to use a data source 546
How to generate a DataGridView control from a data source 546
A Product Maintenance application that uses a DataGridView control 548
How to change the controls associated with a data source 550
How to generate detail controls from a data source 552
A Customer Maintenance application that uses TextBox controls 554
How to handle data errors 556
How to handle data provider errors 556
How to handle ADO.NET errors 558
How to handle data errors for a DataGridView control 560
How to use the Dataset Designer 562
How to view the schema for a dataset 562
How to use the Query Builder 564
How to preview the data for a query 566
How to interpret the generated SQL statements 568




Murach's C# 2008

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.