Database programming with visual basic .NET and ADO.NET : tips, tutorials, and code

Select an Action

Place Hold(s)
Add to My Lists
Email
Print

Title:

Personal Author:

Barker, F. Scott

Publication Information:

Indianapolis, IN : Sams, 2003

ISBN:

9780672322471

Subject Term:

Database management

Microsoft .NET.

Available:*

Library	Item Barcode	Call Number	Material Type	Item Category 1	Status
Searching... PSZ KL	30000010069461	QA76.9.D3 B374 2003	Open Access Book	Book	Searching... Unknown

The topic combination of VB .NET and ADO.NET is unbeatable. VB .NET is the most popular language in which to code. And, every developer needs to understand ADO.NET to allow data to be accessed from a Web site. In this book Developers will be shown numerouse code examples that will illustrate how to program database driven applications within the .NET Framework. The book is aimed at both established and new VB Developers. Important topics covered include: Visual Studio development environment, ASP.NET applications, Windows Forms application, using VB .NET with ADO.NET, complex queries, security, COM interop., and application deployment.

Author Notes

F. Scott Barker has worked as a database developer for more than 15 years

Introduction	p. 1
Who Is This Book For?	p. 1
What's Covered in Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code?	p. 2
Chapter 1 Developing Windows Forms Using Bound Controls	p. 5
1.1 Create a Bound List Box	p. 6
1.2 Limit the Data Displayed in a Bound List Box	p. 12
1.3 Bind and View Individual Text Boxes Based Off a Selected List Box Item	p. 15
1.4 Edit and Update Data Using Bound Controls	p. 20
1.5 Add and Delete Records Using Bound Controls	p. 26
1.6 Take Care of Error Handling with Bound Controls	p. 30
1.7 Put the Finishing Touches on a Data Bound Form	p. 35
1.8 Bind Data to ComboBox and DataGrid Controls	p. 40
1.9 Drill Down to Data in the DataGrid Control	p. 43
Chapter 2 Creating SQL Server Database Objects from Visual Studio .NET	p. 49
Working with Tables, Columns, and Rows	p. 49
Utilizing Properties for Tables and Columns	p. 50
2.1 Create a New SQL Server Database from Within Visual Studio .NET	p. 51
2.2 Define Tables and Fields	p. 53
2.3 Define a Primary Key and Other Indexes	p. 57
2.4 Define Relations Between Tables	p. 60
2.5 Define Defaults and Constraints	p. 64
2.6 Create Views	p. 66
2.7 Create Stored Procedures	p. 70
Chapter 3 Viewing Data with ADO.NET	p. 73
Differences Between ADO and ADO.NET	p. 73
Objects That Are Found in ADO.NET	p. 74
3.1 Retrieve Data by Using the DataReader Object	p. 77
3.2 Retrieve Results from SQL Server by Using the DataTable Object	p. 81
3.3 Locate Records with the DataTable Object	p. 83
3.4 Filter and Sort Records Using the DataView Object	p. 87
Chapter 4 Manipulating Data with ADO.NET	p. 95
4.1 Edit Data and Update Changes That Are Made to an ADO.NET DataSet Object	p. 95
4.2 Add and Delete Rows in a Dataset with ADO.NET	p. 104
4.3 Execute Parameterized Stored Procedures in ADO.NET	p. 108
4.4 Create and Execute On-the-Fly Batch Updates by Using ADO.NET	p. 111
Chapter 5 Working with Data in Web Forms	p. 115
Dealing with Stateless Programming	p. 115
5.1 Use Bound Controls with Web Form	p. 117
5.2 Validate Data Using Validation Controls	p. 123
5.3 Populate DropDown and ListBox Controls	p. 128
5.4 Display Data Using the Table Control	p. 133
5.5 Display Data Using the Repeater Control	p. 138
5.6 Display, Sort, and Page Data in the DataGrid Control	p. 145
5.7 Add, Edit, and Delete Data Using the DataGrid Control	p. 150
5.8 Hyperlink from a Row in the Data Grid to a Detail Page	p. 160
Chapter 6 Creating Transact-SQL Commands	p. 165
6.1 Retrieve Unique Records Using Only a Select Query	p. 166
6.2 Use Variables and Functions in T-SQL	p. 169
6.3 Use Wildcards and Ranges of Values in a SQL Query	p. 172
6.4 Find Records in a Table Without Corresponding Entries in a Related Table?	p. 176
6.5 Take Advantage of Using Subqueries	p. 179
6.6 Create, Modify, and Delete Tables	p. 182
6.7 Create a New Table with Data from Existing Tables?	p. 188
6.8 Create and Call SQL Server 2000 User-Defined Functions	p. 191
Chapter 7 Performing Common Database Tasks Using SQL-DMO	p. 197
Looking at the SQL Server DMF APIs	p. 199
Setting References in .NET for the SQL APIs	p. 200
7.1 Create a Dialog Box to Connect to a New Database, Including Listing Available SQL Servers and Databases	p. 200
7.2 Back Up and Verify a SQL Server Database	p. 208
7.3 Restore a SQL Server Database	p. 216
7.4 Transfer Tables Between SQL Server Databases	p. 220
7.5 Create a Detach/Attach SQL Server Database Dialog Box	p. 227
Chapter 8 Taking Advantage of Data-Driven Techniques	p. 235
8.1 Work with Data-Bound Multi-Select List Boxes Using Windows Forms	p. 237
8.2 Use a Single Windows Form to Update Multiple Lookup Tables	p. 245
8.3 Create a Point-and-Click SQL Server Query Tool for Users Using a Windows Form	p. 250
8.4 Make a Generic Search Form in a Visual Basic .NET Desktop Application	p. 257
8.5 Work with Data-Bound Multi-Select List Boxes Using Web Forms	p. 267
8.6 Use a Single Web Form to Update Multiple Lookup Tables	p. 276
8.7 Create a Point-and-Click Query Tool for Users Using a Web Form	p. 291
8.8 Make a Generic Search Form in an ASP.NET Web Application	p. 299
Chapter 9 Using Classes with Databases to Make Life Easier	p. 309
9.1 Define a Class in Visual Basic .NET	p. 310
9.2 Create a Class That Implements the Interface You Defined	p. 316
9.3 Use Visual Studio .NET Tools to Speed Up Writing ADO.NET Code	p. 322
9.4 Control the Creation and Behavior of Classes	p. 333
9.5 Implement the Methods That Update the Database	p. 338
9.6 Validate Data Passed to Properties and Communicate Errors to Developers	p. 347
9.7 Write Data Validation Code That Can Be Reused in Other Classes	p. 353
Chapter 10 Creating Reports Using Crystal Reports	p. 367
10.1 Create a Report Using Crystal Reports Report Expert	p. 368
10.2 Display a Report That Was Created	p. 374
10.3 Add Calculated Fields to the Crystal Reports Report	p. 378
10.4 Select Whether the Report Will Be Displayed, Printed, or Exported Using Visual Basic .NET Code	p. 381
10.5 Determine Which Records Will Be Printed at Runtime	p. 385
10.6 Print Labels and Control the Order in Which Records Will Be Printed	p. 389
10.7 Create an Onscreen Report That Contains Hyperlinks	p. 394
Chapter 11 Managing SQL Server Security	p. 397
11.1 Create Windows NT/2000 Users	p. 398
11.2 Create Windows NT/2000 Groups	p. 401
11.3 Establish a Windows NT/2000 Authentication Mode	p. 403
11.4 Establish Mixed-Mode Authentication	p. 406
11.5 Create a Standard Login	p. 408
11.6 Create a Windows NT/2000 Login	p. 410
11.7 Use a Fixed Server Role	p. 412
11.8 Create a Database User Account	p. 415
11.9 Use Statement Permissions	p. 417
11.10 Use Object Permissions	p. 419
11.11 Use Fixed Database Roles	p. 421
11.12 Create Custom Database Roles	p. 424
11.13 Create Application Roles	p. 427
Chapter 12 Utilizing XML Data in Your Visual Basic .NET Applications	p. 429
Ways of Utilizing XML in .NET	p. 429
XML Namespaces in .NET	p. 430
12.1 Use XMLWriter to Create an XML Document	p. 430
12.2 Use XMLReader to Read an XML Document	p. 436
12.3 Work with the XML Document Object Model	p. 439
12.4 Retrieve XML from SQL Server 2000	p. 445
12.5 Work with Datasets and XML	p. 448
Chapter 13 Creating XML Web Services	p. 453
Overview of the XML Web Services Infrastructure	p. 454
13.1 Get Started with XML Web Services	p. 455
13.2 Create a Simple XML Web Service Using Parameters	p. 462
13.3 Consume XML Web Services	p. 466
13.4 Pass a Dataset Back from an XML Web Service	p. 470
Appendix A Desktop Development with ADO	p. 475
When to Use ADO (Local Database/Single Tier Applications)	p. 475
Looking At the ADO Object Models	p. 476
Referencing the Type Libraries	p. 477
Using the Connection Object	p. 478
Working with the ADO Recordset Object	p. 481
Executing a SQL Server Stored Procedure By Using ActiveX Data Objects	p. 485
Executing Batch Updates with ADO and SQL Server	p. 486
Creating SQL Server Objects with ActiveX Data Objects	p. 488
Conclusion	p. 490
Index	p. 491

Available:*

On Order

Summary

Summary

Author Notes

Table of Contents