Chapter 15 slides - Chapter 15 How to work with bound...

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, C15 Slide 1 Chapter 15 How to work with bound controls and parameterized queries
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, C15 Slide 2 Objectives Applied Format the data in a bound text box by setting the properties for the control. Bind a combo box to a data source. Use the properties and methods of the BindingSource class to navigate and modify the rows in a dataset. Create and use a parameterized query with a data source. Customize a ToolStrip control by adding controls to it, deleting controls from it, and formatting the controls that are on it. Then, code the event handlers for making these controls work. Customize the appearance and operation of a DataGridView control. Use a DataGridView control as part of a Master/Detail form.
Background image of page 2
Murach’s Visual Basic 2008, C15 Slide 3 Objectives (continued) Knowledge Explain why you might want to use code to work directly with the binding source object for a data source. Describe the use of a parameterized query and the ToolStrip control that gets generated for the query.
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, C15 Slide 4 The dialog box that you can use to apply formatting to a column
Background image of page 4
Murach’s Visual Basic 2008, C15 Slide 5 A combo box that’s bound to a data source
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, C15 Slide 6 Combo box properties for binding Property Description DataSource The name of the data table that contains the data displayed in the list. DisplayMember The name of the data column whose data is displayed in the list. ValueMember The name of the data column whose value is stored in the list. This value is returned by the SelectedValue property of the control. SelectedValue Gets the value of the currently selected item. You can use this property to bind the ValueMember property to a column in the data source.
Background image of page 6
Murach’s Visual Basic 2008, C15 Slide 7 Common properties of the BindingSource class Property Description Position The index of the current row in the data source. Count The number of rows in the data source.
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, C15 Slide 8 Common methods of the BindingSource class Method Description AddNew() Adds a new, blank row to the data source. EndEdit() Saves changes to the current row. CancelEdit() Cancels changes to the current row. RemoveCurrent() Removes the current row from the data source. MoveFirst() Moves to the first row in the data source. MovePrevious()
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 / 42

Chapter 15 slides - Chapter 15 How to work with bound...

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