ADO.NET2 - Database Programming Overview Simple Data...

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

View Full Document Right Arrow Icon
Database Programming Database Programming
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Simple Data Binding Complex Data Binding Binding Various VB.NET Controls Display Member and Value Member Properties Creating Data Forms Using Form Wizard Datasets for Navigation and Data Entry Using BindingContext Class Working with Parameterized SQL Queries Using Parent / Child Relationships Handling ADO.NET Objects in Code Overview Overview
Background image of page 2
3 Data Binding Data Binding Data binding is a process that binds control objects to data sources by associating data from the data source to a control object. A data source is any object that provides (source) the data. The process of data connection links database tables to data sources.
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Data Binding Data Binding Scenarios where Data Binding is useful Data Entry – Alter values in a database using data entry forms. Navigation – Displaying and navigating database information on a form. Data Lookup – Display attributes of a particular record. Parent/Child Relationships – Specify relationships between different related tables.
Background image of page 4
5 Simple Data Binding Simple Data Binding Simple binding displays one data value from a data table on a control. Example Display only the name of the student from the data table in a text box. Hands On # 17.1 – Simple Binding Display the student name from the student table in the Text box control on the form.
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Simple Data Binding Simple Data Binding Hands On # 17.1 Create a new Project, "SimpleBinding," and connect it to the University Database. Create a data adapter ODAStudent. Generate a dataset DsStudent. Clear and Fill the dataset. Add a text box control txtName and set its Advance, Text and Tag properties in DataBindings option. For the Text property under DataBinding, select the DsStudent | tblStudent | Name field.
Background image of page 6
7 Simple Data Binding Simple Data Binding Hands On # 17.1 – Setting the Text Property
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 Simple Data Binding Simple Data Binding Hands On # 17.1 – Setting the Advance option
Background image of page 8
9 Simple Data Binding Simple Data Binding Simple binding using VB.NET code at run time 'Bind txtName.Text to DsStudent | tblStudent | Name 1. txtName .DataBindings.Add ("Text", DsStudent, "tblStudent.Name") 'Bind txtTest.Text to txtName.txt 2. txtTest .DataBindings.Add ("Text", txtName, "Text")
Background image of page 9

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

View Full DocumentRight Arrow Icon
10 Complex Data Binding Complex Data Binding Complex binding displays more than one data value from a data table on a control. Example Display the entire student table on the data grid. Control properties involved in complex binding Data Source Data Member Display Member Value Member
Background image of page 10
11 Complex Data Binding Complex Data Binding Hands On # 17.2 – Complex Binding Display multiple data values on a control using the CheckedListBox control.
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/20/2008 for the course IST 331 taught by Professor Sikder during the Spring '08 term at Cleveland State.

Page1 / 64

ADO.NET2 - Database Programming Overview Simple Data...

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

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