Chapter 14 slides - Chapter 14 How to work with data...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Murach’s Visual Basic 2008, C14 Slide 1 Chapter 14 How to work with data sources and datasets
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Murach’s Visual Basic 2008, C14 Slide 2 Objectives Applied Use a data source to get the data that an application requires. Use a DataGridView control to present the data that’s retrieved by a data source. Use other controls like text boxes to present the data that’s retrieved by a data source. Write the Visual Basic code for handling any data errors that result from the use of the data source or the controls that are bound to it. Use the Dataset Designer to (1) view the schema for the dataset of a data source, (2) modify a query using the Query Builder, (3) preview the data for a query, or (4) review the SQL statements that are generated for a data source.
Background image of page 2
Murach’s Visual Basic 2008, C14 Slide 3 Objectives (continued) Knowledge Describe the use of a connection string in an app.config file. Describe the use of the Fill and UpdateAll methods of the TableAdapter object. Describe the use of the EndEdit method of the BindingSource object. Describe the two categories of data errors that can occur when you run an application that uses a data source. Describe the use of the DataError event for a DataGridView control. In general terms, describe the way the SQL statements that are generated for a data source (1) prevent concurrency errors, and (2) refresh a dataset when the database generates the keys for new rows.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Murach’s Visual Basic 2008, C14 Slide 4 An empty Data Sources window
Background image of page 4
Murach’s Visual Basic 2008, C14 Slide 5 A Data Sources window after a data source has been added
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Murach’s Visual Basic 2008, C14 Slide 6 The first step of the Data Source Configuration Wizard
Background image of page 6
Murach’s Visual Basic 2008, C14 Slide 7 How to start the Data Source Configuration Wizard Click on the Add New Data Source link that’s available from the Data Sources window when a project doesn’t contain any data sources. Click on the Add New Data Source button at the top of the Data Sources window. Select the Add New Data Source command from Visual Studio’s Data menu. Add a SQL Server (.mdf) or Access (.mdb) data file to the project using the Project Add Existing Item command. Then, the wizard will let you choose the database objects you want to include.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Murach’s Visual Basic 2008, C14 Slide 8 How to choose a data source type To get your data from a database, select the Database option. This option lets you create applications like the ones described in this chapter. To get your data from a web service, select the Web Service
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/14/2010 for the course BS computer p taught by Professor Smith during the Spring '10 term at Virtual University of Pakistan.

Page1 / 41

Chapter 14 slides - Chapter 14 How to work with data...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online