Index_V

V

validation controls, 482–483

Video Store Application, basic design, 640–665

Check In/Check Out component, 663–665

Data Access Component (DAC), 648–652

data object, 643–644

database design, 641–643

dependencies, managing, 661–662

mapped object, 644–648

User component, 654–659

User test case, 659–661

video tape test case, building, 652–654

VideoCategory and Related Objects (code listing), 686–691

VideoCategory table, 685

VideoCategoryIndexer (code listing), 701–703

VideoCategoryIndexer Test Case (code listing), 703–704

VideoCheckInCheckOut Component, Test Case for (code listing), 671–673

VideoCheckInCheckOut Object (code listing), 667–670

Videos() Array, Adding to VideoCategory Object (code listing), 695–696

VideoTape Component, Test Case for (code listing), 653–654

VideoTape Object (code listing), 645–648

VideoTapeData Object (code listing), 643–644

VideoTapeDataAccess Object (code listing), 648–652

View Source option, 48

View Wizard Results, 44

ViewGuestBook.aspx, Opening (code listing), 511

Viewing Data From SQL Server Database (code listing), 30–31

views, 406–411

creating, 406–408

executing from VS .NET, 409

Filling DataSets from multiple, 411

programmatically retrieving data from, 410

understanding, 807–809

virtual table, 393

VisibleMonthChanged Event (code listing), 545

Visio, 84

Visual Basic .NET (VB .NET), 209, 637

Visual Basic (VB) exception handling, 359

visual data components, 11

Visual Studio .NET

accessing COM Library with, 710

to add server controls, 486

creating XML Web services in, 518–521

executing stored procedures from, 397–399

executing views from, 409

Integrated Development Environment (IDE). See IDE

managing queues with, 731–732

ODBC .NET data provider and, 375

version 2003, 414

XML designer, 277

Visual Studio .NET data components, 33–71

code listings

Calling DataForm1 From Button Click, 65

Calling DataForm2 From Button Click, 66

Cancel All Button Click Event Handler (code listing), 71

DataAdapter Connection Through TableMapping, 49

FillDataSet Method Generated by Data Form Wizard, 69

Form's Load Event Handler, 50–51

LoadDataSet Method Generated by Data Form Wizard, 68–69

Sql Server Provider Components, Added, 48–49

UpdateDataSource and UpdateDataSet Methods Generated by Data Form Wizard, 70–71

connection strings, 40

creating ADO.NET project, 33

data connections, 38–40

Data Form Wizard, 57–71

adding items, 58

calling form from application, 65–66

creating relationship between tables, 60–61

Data Connection, choosing, 59

DataForm1 .vb, 67–71

DataSet, choosing, 59

display style, choosing, 62–65

displaying tables and columns, 62

MyDS.xsd, 67

project template, 58

tables or views, choosing, 59–60

viewing output, 66

DataSet and DataView components, 51–57

typed DataSets in VS .NET, 51–54

understanding DataView, 54–57

fundamentals, 37–38

Server Explorer, 34–36

adding new connection, 35

managing and viewing data, 36

SQL DataAdapters, 40–51

Data Adapter Configuration Wizard. See Data Adapter Configuration Wizard

Server Explorer, creating DataAdapters with, 41