Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

Practical Database Programming With Visual C#.NET [Pehme köide]

3.33/5 (6 hinnangut Goodreads-ist)

Ying Bai

Formaat: Paperback / softback, 936 pages, kõrgus x laius x paksus: 234x188x53 mm, kaal: 1610 g, Screen captures: 600 B&W, 0 Color
Ilmumisaeg: 16-Apr-2010
Kirjastus: Wiley-IEEE Press
ISBN-10: 0470467274
ISBN-13: 9780470467275

Teised raamatud teemal:

Database programming

Pehme köide
Hind: 145,83 €
Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
Kogus:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Lisa ostukorvi
Tasuta tarne
Tellimisaeg 2-4 nädalat
Lisa soovinimekirja
Raamatukogudele

Formaat: Paperback / softback, 936 pages, kõrgus x laius x paksus: 234x188x53 mm, kaal: 1610 g, Screen captures: 600 B&W, 0 Color
Ilmumisaeg: 16-Apr-2010
Kirjastus: Wiley-IEEE Press
ISBN-10: 0470467274
ISBN-13: 9780470467275

Teised raamatud teemal:

Database programming

Püsilink: https://www.kriso.ee/db/9780470467275.html

Märksõnad:

A novel approach to developing and applying databases with Visual C#.NET Practical Database Programming with Visual C#.NET clearly explains the considerations and applications in database programming with Visual C#.NET 2008 and in developing relational databases such as Microsoft Access, SQL Server, and Oracle Database. Sidestepping the traditional approach of using large blocks of code, Ying Bai utilizes both Design Tools and Wizards provided by Visual Studio.NET and real-time object methods to incorporate over sixty real sample database programming projects along with detailed illustrations and explanations to help readers understand the key techniques and programming technologies in database programming. This invaluable resource features:

Fundamental and advanced database programming techniques for beginning and experienced students as well as programmers

A real completed sample database CSE_DEPT with three versions (Microsoft Access 2007, SQL Server 2005 SP2, and Oracle Database 10g XE Release 2) used throughout the entire book

Step-by-step details on designing and building a practical relational database

Discussion and analysis of the new database query technique, LINQ APIwhich includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities, and LINQ to XMLand implementation in actual projects with line-by-line explanation

Homework and selected solutions for each chapter to strengthen and improve learning and understanding

An Instructor's Manual (MS PPT), example codes and exercise questions, homework/exercise solutions, and database projects available for free download

E-mail assistance from the author

Readers who will benefit highly from this reference are undergraduate or graduate students majoring in computer science and engineering, graduate students in all engineering departments, and software engineers and researchers in academic and industrial fields.

To obtain instructor materials please send an email to pressbooks@ieee.org

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Preface

xxiii

Acknowledgment

xxv

Introduction

(10)

Outstanding Features of the Book

(1)

Target Audience

(1)

Topics Covered

(2)

Organization of the Book and How to Use It

(1)

How to Use the Source Code and Sample Databases

(1)

Instructor and Customer Support

(1)

Homework Solutions

(3)

Introduction to Databases

(136)

What Are Databases and Database Programs?

(2)

File Processing System

(1)

Integrated Databases

(1)

Develop a Database

(1)

Sample Database

(4)

Relational Data Model

(1)

Entity-Relationship Model (ER)

(1)

Identifying Keys

(1)

Primary Key and Entity Integrity

(1)

Candidate Key

(1)

Foreign Keys and Referential Integrity

(1)

Define Relationships

(3)

Connectivity

(3)

ER Notation

(1)

Data Normalization

(4)

First Normal Form (1NF)

(1)

Second Normal Form (2NF)

(1)

Third Normal Form (3NF)

(2)

Database Components in Some Popular Databases

(8)

Microsoft Access Databases

(1)

Database File

(1)

Tables

(1)

Queries

(1)

SQL Server Databases

(1)

Data Files

(1)

Tables

(1)

Views

(1)

Stored Procedures

(1)

Keys and Relationships

(1)

Indexes

(1)

Transaction Log Files

(1)

Oracle Databases

(1)

Data Files

(1)

Tables

(1)

Views

(1)

Stored Procedures

(1)

Indexes

(1)

Initialization Parameter Files

(1)

Control Files

(1)

Redo Log Files

(1)

Password Files

(1)

Create Microsoft Access Sample Database

(10)

Create Login Table

(2)

Create Faculty Table

(2)

Create Other Tables

(2)

Creat Relationships Among Tables

(4)

Create Microsoft SQL Server 2005 Sample Database

(17)

Create Login Table

(2)

Create Faculty Table

(1)

Create Other Tables

(5)

Create Relationships Among Tables

(1)

Create Relationship Between LogIn and Faculty Tables

(3)

Create Relationship Between LogIn and Student Tables

(1)

Create Relationship Between Faculty and Course Tables

(1)

Create Relationship Between Student and StudentCourse Tables

(2)

Create Relationship Between Course and StudentCourse Tables

(1)

Create Oracle 10g XE Sample Database

(23)

Create Oracle User Database

(1)

Add New Data Tables into Oracle User Database

(1)

Create LogIn Table

(6)

Create Faculty Table

(3)

Create Other Tables

(3)

Create Constraints Between Tables

(2)

Create Constraints Between LogIn and Faculty Tables

(1)

Create Constraints Between LogIn and Student Tables

(2)

Create Constraints Between Course and Faculty Tables

(1)

Create Constraints Between StudentCourse and Student Tables

(1)

Create Constraints Between StudentCourse and Course Tables

(2)

Chapter Summary

(1)

Homework

(4)

Introduction to ADO.NET

ADO and ADO.NET

(1)

Overview of ADO.NET 2.0

(1)

Architecture of ADO.NET 2.0

(2)

Components of ADO.NET 2.0

(47)

Data Provider

(1)

ODBC Data Provider

(1)

OLEDB Data Provider

(1)

SQL Server Data Provider

(1)

Oracle Data Provider

(1)

Connection Class

(2)

Open() Method of Connection Class

100

(1)

Close() Method of Connection Class

101

(1)

Dispose() Method of Connection Class

102

(1)

Command and Parameter Classes

102

(1)

Properties of Command Class

103

(1)

Constructors and Properties of Parameter Class

103

(1)

Parameter Mapping

104

(2)

Methods of ParameterCollection Class

106

(1)

Constructor of Command Class

107

(1)

Methods of Command Class

108

(3)

DataAdapter Class

111

(1)

Constructor of DataAdapter Class

111

(1)

Properties of DataAdapter Class

111

(1)

Methods of DataAdapter Class

112

(1)

Events of DataAdapter Class

113

(1)

DataReader Class

114

(3)

DataSet Component

117

(1)

DataSet Constructor

118

(1)

DataSet Properties

119

(1)

DataSet Methods

119

(1)

DataSet Events

119

(3)

DataTable Component

122

(1)

DataTable Constructor

123

(1)

DataTable Properties

124

(1)

DataTable Methods

125

(1)

DataTable Events

125

(2)

ADO.NET 3.5 Entity Framework

127

(2)

ADO.NET 3.5 Entity Data Model

129

(3)

Using ADO.NET 3.5 Entity Data Model Wizard

132

(10)

Chapter Summary

142

(2)

Homework

144

(3)

Introduction to Language-Integrated Query (LINQ)

147

(88)

Overview of Language-Integrated Query

147

(11)

Some Special Interfaces Used in LINQ

148

(1)

IEnumerable and IEnumerable<T> Interfaces

148

(1)

IQueryable and IQueryable<T> Interfaces

149

(1)

Standard Query Operators

150

(2)

Deferred Standard Query Operators

152

(4)

Nondeferred Standard Query Operators

156

(2)

Introduction to LINQ Query

158

(3)

Architecture and Components of LINQ

161

(4)

Overview of LINQ to Objects

162

(1)

Overview of LINQ to DataSet

163

(1)

Overview of LINQ to SQL

163

(1)

Overview of LINQ to Entities

164

(1)

Overview of LINQ to XML

165

(1)

LINQ to Objects

165

(11)

LINQ and ArrayList

166

(1)

LINQ and Strings

167

(1)

Query a String to Determine Number of Numeric Digits

168

(1)

Sort Lines of Structured Text by Any Field in Line

169

(2)

LINQ and File Directories

171

(1)

Query Contents of Files in a Folder

172

(3)

LINQ and Reflection

175

(1)

LINQ to DataSet

176

(18)

Operations to DataSet Objects

177

(1)

Query Expression Syntax

178

(1)

Method-Based Query Syntax

179

(3)

Query the Single Table

182

(1)

Query the Cross Tables

183

(3)

Query Typed DataSet

186

(3)

Operations to DataRow Objects Using Extension Methods

189

(4)

Operations to DataTable Objects

193

(1)

LINQ to SQL

194

(12)

LINQ to SQL Entity Classes and DataContext Class

195

(4)

LINQ to SQL Database Operations

199

(2)

Data Selection Query

201

(1)

Data Insertion Query

201

(1)

Data Updating Query

202

(2)

Data Deletion Query

204

(2)

LINQ to SQL Implementations

206

(1)

LINQ to Entities

206

(5)

Object Services Component

207

(1)

ObjectContext Component

207

(1)

ObjectQuery Component

208

(1)

LINQ to Entities Flow of Execution

208

(2)

Implementation of LINQ to Entities

210

(1)

LINQ to XML

211

(11)

LINQ to XML Class Hierarchy

211

(1)

Manipulate XML Elements

212

(1)

Creating XML from Scratch

212

(2)

Insert XML

214

(1)

Update XML

215

(1)

Delete XML

216

(1)

Manipulate XML Attributes

216

(1)

Add XML Attributes

217

(1)

Get XML Attributes

217

(1)

Delete XML Attributes

217

(1)

Query XML with LINQ to XML

218

(1)

Standard Query Operators and XML

219

(1)

XML Query Extensions

219

(1)

Using Query Expressions with XML

220

(1)

Using XPath and XSLT with LINQ to XML

221

(1)

Mixing XML and Other Data Models

221

(1)

Language Enhancement for LINQ

222

(6)

Lambda Expressions

223

(2)

Extension Methods

225

(1)

Implicitly Typed Local Variables

226

(1)

Query Expressions

227

(1)

Chapter Summary

228

(2)

Homework

230

(5)

Data Selection Query with Visual C#.NET

235

(1)

PART I Data Query with Visual Studio Design Tools and Wizards

236

(67)

Completed Sample Database Application Example

236

(3)

Visual Studio.NET 2008 Design Tools and Wizards

239

(12)

Data Design Tools in Toolbox Window

239

(1)

DataSet

240

(1)

DataGridView

241

(1)

BindingSource

242

(1)

BindingNavigator

242

(1)

TableAdapter

243

(1)

Data Design Wizards in Data Source Window

243

(1)

Add New Data Source

244

(1)

Data Source Configuration Wizard

244

(5)

DataSet Designer

249

(2)

Build a Sample Database Project---SelectWizard with SQL Server Database

251

(8)

Application User Interfaces

251

(1)

252

(3)

Selection Form

255

(1)

Faculty Form

256

(1)

Course Form

257

(1)

Student Form

257

(2)

Add and Utilize Visual Studio.NET Wizards and Design Tools

259

(4)

Add and Configure a New Data Source

259

(4)

Query and Display Data Using the DataGridView Control

263

(5)

View Entire Table

264

(2)

View Each Record or Specified Columns

266

(2)

Use DataSet Designer to Edit the Structure of DataSet

268

(3)

Bind Data to Associated Controls in LogIn Form

271

(3)

Develop Codes to Query Data Using Fill() Method

274

(2)

Use Return a Single Value to Query Data for Login Form

276

(4)

Coding for Selection Form

280

(2)

Bind Data to Associated Controls in Faculty Form

282

(2)

Develop Codes to Query Data from Faculty Table

284

(4)

Develop Codes to Query Data Using SQL SELECT Method

285

(2)

Develop Codes to Query Data Using LINQ Method

287

(1)

Display Pictures for Faculty Form

288

(3)

Binding Data to Associated Controls in Course Form

291

(4)

Develop Codes to Query Data for Course Form

295

(4)

Query Data from the Course Table Using TableAdapter Method

295

(2)

Query Data from the Course Table Using LINQ Method

297

(2)

Build a Sample Database Project---SelectWizardOracle with Oracle Database

299

(4)

Create a New Visual C# Project---SelectWizardOracle

299

(1)

Select and Add Oracle Database 10g XE as Data Source

300

(3)

PART II Data Query with Runtime Objects

303

(137)

Introduction to Runtime Objects

304

(3)

Procedure of Building a Data-Driven Application Using Runtime Objects

306

(1)

Query Data Using Runtime Objects to Microsoft Access 2007 Database

307

(98)

Query Data Using Runtime Objects for LogIn Form

307

(1)

Declare Runtime Objects

307

(1)

Connect to Data Source with Runtime Objects

308

(2)

Coding for Method 1:Using DataSet-DataAdapter to Query Data

310

(2)

Coding for Method 2:Using DataReader to Query Data

312

(2)

Coding for Selection Form

314

(2)

Query Data Using Runtime Objects for Faculty Form

316

(8)

Query Data Using Runtime Objects for Course Form

324

(11)

Query Data Using Runtime Objects for Student Form

335

(1)

Coding for Constructor of Student Form

335

(1)

Coding for Student Select Button Click Method

336

(8)

Query Data Using Runtime Objects to SQL Server Database

344

(1)

Migrating from Access to SQL Server and Oracle Databases

345

(3)

Query Data Using General Runtime Objects

348

(1)

Query Data Using General Runtime Objects for LogIn Form

349

(6)

Coding for Selection Form

355

(3)

Query Data Using General Runtime Objects for Course Form

358

(2)

Retrieve Data from Multiple Tables Using Joined Tables Method

360

(4)

Query Data Using General Runtime Objects for Student Form

364

(2)

Query Data Using Stored Procedures

366

(20)

Query Data Using LINQ to SQL Technique

386

(2)

Create Entity Classes and Connect DataContext to Database

388

(1)

Query Data Using LINQ to SQL for Login Form

388

(3)

Coding for Selection Form

391

(2)

Query Data Using LINQ to SQL for Faculty Form

393

(4)

Query Data Using Joined LINQ to SQL for Course Form

397

(4)

Query Data Using LINQ to SQL Stored Procedures for Student Form

401

(4)

Query Data Using Runtime Objects to Oracle Database

405

(27)

Oracle Database 10g Express Edition Release 2

405

(1)

Configure Oracle Database Connection String

406

(1)

Query Data Using General Runtime Objects

407

(1)

Query Data Using General Runtime Objects for LogIn Form

408

(5)

Coding for Selection Form

413

(1)

Query Data Using Runtime Objects for Faculty Form

414

(3)

Query Data Using Runtime Objects for Course Form

417

(2)

Stored Procedures in Oracle Database Environment

419

(1)

Syntax of Creating a Stored Procedure in Oracle

420

(1)

Syntax of Creating a Package in Oracle

420

(2)

Create Faculty_Course Package for Course Form

422

(4)

Query Data Using Oracle Package for Course Form

426

(6)

Chapter Summary

432

(2)

Homework

434

(5)

Data Inserting with Visual C#.NET

439

(1)

PART I Data Inserting with Visual Studio.NET Design Tools and Wizards

440

(49)

Insert New Data into a Database

440

(2)

Insert New Records into a Database Using Table Adapter.Insert Method

441

(1)

Insert New Records into a Database Using Table Adapter. Update Method

442

(1)

Insert Data into Microsoft Access Database Using Sample Project InsertWizard

442

(26)

Create New Project Based on Sample Wizards Project

443

(1)

Application User Interfaces

443

(1)

Create Insert Faculty Form Window

443

(2)

Duplicate Visual C#.NET Projects with Installed DataSet

445

(1)

Validate Data Before Data Insertion

446

(1)

The .NET Framework Collection Classes

447

(1)

Validate Data Using Generic Collection

447

(4)

Initialization and Termination Coding for Data Insertion

451

(2)

Build Insert Query

453

(1)

Configure TableAdapter and Build Data Inserting Query

453

(2)

Develop Codes to Insert Data Using TableAdapter.Insert Method

455

(2)

Develop Codes to Insert Data Using TableAdapter.Update Method

457

(5)

Validate Data After Data Insertion

462

(1)

Modifications to Faculty Form Window

462

(3)

Modifications to Insert Faculty Form Window

465

(3)

Insert Data into SQL Server Database Using Sample Project SQLInsertWizard

468

(21)

Modify Existing Project to Get New Data Insertion Project

469

(1)

Create New Form Window to Insert Data for Course Form

470

(2)

Trigger and Connect to Visual Studio Design Tools

472

(1)

Project Initialization and Validate Data Before Data Insertion

473

(3)

Configure TableAdapter and Build Data Insertion Query

476

(1)

Develop Codes to Insert Data Using TableAdapter.Insert Method

477

(4)

Develop Codes to Insert Data Using TableAdapter.Update Method

481

(3)

Use Select Button in Course Form to Perform Data Validation

484

(1)

Insert Data into Database Using Stored Procedures

485

(1)

Create Stored Procedure Using TableAdapter Query Configuration Wizard

485

(2)

Modify Codes to Perform Data Insertion Using Stored Procedure

487

(2)

Insert Data into Oracle Database Using Sample Project OracleInsertWizard

489

(1)

PART II Data Insertion with Runtime Objects

489

(63)

General Runtime Objects Method

490

(1)

Insert Data into SQL Server Database Using Runtime Objects Method

491

(19)

Add Inserting Data Form Window: Insert Faculty Form

491

(2)

Modify Codes to Copied Project

493

(1)

Startup Coding and Data Validation Before Data Insertion

494

(4)

Insert Data into Faculty Table

498

(4)

Validate Data After Data Insertion

502

(1)

Modifications to Faculty Form Window

503

(2)

Insert New Faculty Photo

505

(1)

Modifications to Insert Faculty Form Window

506

(4)

Insert Data into Microsoft Access Database Using Runtime Objects

510

(8)

Modifications to Namespaces

510

(1)

Remove SP Form and Student Form

511

(1)

Modify Database Connection String

512

(2)

Modify LogIn Query Strings

514

(1)

Modify Faculty Query String

515

(1)

Modifications to Other Forms

515

(3)

Insert Data into Oracle Database Using Runtime Objects

518

(8)

Add Oracle Reference and Oracle Namespace

519

(1)

Modify Project Namespaces

520

(1)

Modify Database Connection String

521

(1)

Modify LogIn Query Strings

522

(1)

Modify Faculty Query String

523

(2)

Modifications to Other Forms

525

(1)

Insert Data into Database Using LINQ Queries

526

(1)

Insert Data into SQL Server Database Using LINQ to SQL Queries

527

(1)

Insert Data into Database Using Stored Procedures

527

(20)

Insert Data into SQL Server Database Using Stored Procedures

527

(1)

Add an Inserting Data Form Window: Insert Course Form

528

(1)

Develop Stored Procedures of SQL Server Database

529

(3)

Develop Codes to Call Stored Procedures to Insert Data into Course Table

532

(6)

Insert Data into Oracle Database Using Stored Procedures

538

(1)

Develop Stored Procedures in Oracle Database

539

(4)

Develop Codes to Call Stored Procedures to Insert Data into Course Table

543

(4)

Chapter Summary

547

(1)

Homework

548

(3)

Data Updating and Deleting with Visual C#.NET

551

(1)

PART I Data Updating and Deleting with Visual Studio.NET Design Tools and Wizards

552

(20)

Update or Delete Data in Databases

553

(2)

Update or Delete Data in Database Using Table Adapter DBDirect Methods---Table Adapter. Update and Table Adapter. Delete

554

(1)

Update or Delete Data in Database Using Table Adapter. Update Method

554

(1)

Update and Delete Data for Microsoft Access Database

555

(13)

Create New Project Based on Insert Wizard Project

556

(1)

Application User Interfaces

556

(1)

Modify Faculty Form Window

557

(1)

Bind Data for All Textboxes of Faculty Form Window

557

(1)

Validate Data Before Data Updating and Deleting

558

(1)

Build Update and Delete Queries

558

(1)

Build Data Updating Query Function

559

(1)

Develop Codes to Update Data Using TableAdapter DBDirect Method

560

(1)

Modifications of Coding

561

(1)

Updating Coding

561

(1)

Develop Codes to Update Data Using Table Adapter. Update Method

562

(2)

Develop Codes to Delete Data Using Table Adapter DBDirect Method

564

(1)

Develop Codes to Delete Data Using Table Adapter. Update Method

565

(1)

Validate Data After Data Updating and Deleting

566

(2)

Update and Delete Data for SQL Server Database

568

(4)

Update and Delete Data for Oracle Database

572

(1)

PART II Data Updating and Deleting with Runtime Objects

572

(323)

Runtime Objects Method

572

(2)

Update and Delete Data for SQL Server Database Using Runtime Objects

574

(10)

Update Data in Faculty Table for SQL Server Database

574

(1)

Modify Faculty Form Window

575

(1)

Modify Original Coding in Faculty Form

576

(1)

Develop Codes to Update Data

577

(2)

Validate Data Updating

579

(1)

Delete Data from Faculty Table for SQL Server Database

579

(1)

Develop Codes to Delete Data

579

(2)

Validate Data Updating and Deleting

581

(3)

Update and Delete Data for Oracle Databases Using Runtime Objects

584

(5)

Add Oracle Namespace Reference

585

(1)

Modify Connection String and Query String for LogIn Form

585

(1)

Modify Connection String in Constructor of LogIn Class

585

(1)

Modify SELECT Query String in TabLogIn Button Click Method

586

(1)

Modify SELECT Query String in ReadLogIn Button Click Method

586

(1)

Modify Query Strings in Faculty Form

586

(1)

Modify SELECT Query String for Select Button Click Method

586

(1)

Modify UPDATE Query String for Update Button Click Method

586

(1)

Modify DELETE Query String for Delete Button Click Method

587

(1)

Modify Query Strings for Course Form

587

(1)

Modify SELECT Query String for Select Button Click Method

587

(1)

Modify SELECT Query String for CourseList Click Method

587

(1)

Other Modifications

588

(1)

Update and Delete Data in Database Using Stored Procedures

589

(26)

Update and Delete Data in Access Database Using Stored Procedures

590

(1)

Modify Existing Project

590

(2)

Create Stored Procedures in Microsoft Access Database

592

(2)

Call Stored Procedure to Update Faculty Information

594

(1)

Call Stored Procedure to Delete Faculty Information

595

(3)

Update and Delete Data in SQL Server Database Using Stored Procedures

598

(1)

Modify Existing Project to Create New Project

598

(3)

Develop Stored Procedure in SQL Server Database

601

(4)

Call Stored Procedure to Perform Data Updating and Deleting

605

(1)

Update and Delete Data in Oracle Database Using Stored Procedures

606

(1)

Modify Existing Project to Create New Project

607

(3)

Develop Stored Procedure in Oracle Database

610

(4)

Call Stored Procedures to Perform Data Updating and Deleting

614

(1)

Update and Delete Data in Databases Using LINQ to SQL Query

615

(6)

Create New Object of DataContext Class

616

(1)

Develop Codes for Select Button Click Method

617

(1)

Develop Codes for Update Button Click Method

618

(2)

Develop Codes for Delete Button Click Method

620

(1)

Chapter Summary

621

(1)

Homework

621

(4)

Accessing Data in ASP.NET

625

(96)

What Is .Net Framework?

626

(1)

What is ASP.NET and ASP.NET 3.5?

627

(6)

ASP.NET Web Application File Structure

629

(1)

ASP.NET Execution Model

630

(1)

What Really Happens When a Web Application Is Executed?

630

(1)

Requirements to Test and Run a Web Project

631

(2)

Develop ASP.NET Web Application to Select Data from SQL Server Databases

633

(28)

Create the User Interface---LogIn Form

634

(1)

Develop Codes to Access and Select Data from Database

635

(4)

Validate Data on Client Side

639

(1)

Create Second User Interface---Selection Page

640

(1)

Develop Codes to Open Other Page

641

(2)

Create Third User Interface---Faculty Page

643

(2)

Develop Codes to Select Desired Faculty Information

645

(1)

Develop Codes for Page_Load Method

645

(1)

Develop Codes for Select Button Method

646

(2)

Develop Codes for Other Methods

648

(3)

Create Fourth User Interface---Course Page

651

(2)

AutoPostBack Property of Listbox Control

653

(1)

Develop Codes to Select Desired Course Information

654

(1)

Coding for Course Page Loading and Ending Methods

655

(1)

Coding for Select Button Click Method

656

(2)

Coding for SelectedIndexChanged Method of Listbox Control

658

(1)

Coding for Other User-Defined Methods

659

(2)

Develop ASP.NET Web Application to Insert Data into SQL Server Databases

661

(10)

Create New Web Page Insert.aspx

662

(1)

Develop Codes to Perform Data Insertion Function

663

(1)

Develop Codes for Page_Load and Back Button Click Methods

664

(1)

Develop Codes for Insert Button Click Method

664

(2)

Develop Codes for Other Methods

666

(2)

Validate Data Insertion

668

(3)

Develop Web Applications to Update and Delete Data in SQL Server Databases

671

(12)

Application User Interfaces

672

(1)

Modify Coding for Faculty Page

672

(2)

Develop Codes for Update Button Click Method

674

(4)

Develop Codes for Delete Button Click Method

678

(1)

Relationships Between Five Tables in Our Sample Database

678

(1)

Data Deleting Order Sequence

679

(1)

Use Cascade Deleting Option to Simplify Data Deleting

679

(2)

Develop Codes to Perform Data Deleting

681

(2)

Develop ASP.NET Web Applications with LINQ to SQL Query

683

(9)

Create New Web Form Page

684

(1)

Create New Object of DataContext Class

685

(2)

Coding for Data Selection Query

687

(1)

Coding for Data Insertion Query

688

(1)

Coding for Data Updating and Deleting Queries

689

(3)

Develop ASP.NET Web Application to Select Data from Oracle Databases

692

(8)

Modify Connection String and Connection Object on LogIn Page

693

(1)

Modify Query String in LogIn Page

694

(1)

Modify Query String in Faculty Page

695

(1)

Modify Query Strings in Course Page

696

(4)

Develop ASP.NET Web Application to Insert Data into Oracle Databases

700

(8)

Add Two Controls to Faculty Page

701

(1)

Modify Codes to Some Methods on Faculty Page

701

(3)

Create Codes to Insert New Faculty on Faculty Page

704

(4)

Develop ASP.NET Web Application to Update and Delete Data in Oracle Databases

708

(9)

Modify Project to Perform Data Updating

708

(1)

Create Codes to Update Button Click Method

708

(2)

Develop Stored Procedures to Perform Data Deleting

710

(1)

Delete Existing Record from Faculty Table

711

(1)

Develop Codes for Delete Button Click Method

712

(1)

Validate Data Deleting Action

713

(2)

Constraint Property---On Delete Cascade in Data Table

715

(2)

Chapter Summary

717

(1)

Homework

718

(3)

ASP.NET Web Services

721

(174)

Web Services and Their Components

722

(1)

Procedures to Build a Web Service

723

(3)

Structure of a Typical Web Service Project

724

(1)

Real Considerations When Building a Web Service Project

724

(1)

Procedures to Build an ASP.NET Web Service

725

(1)

Build ASP.NET Web Service Projects to Access SQL Server Database

726

(46)

Files and Items Created in the New Web Service Project

726

(3)

Feeling of Hello World Web Service Project as It Runs

729

(3)

Modify Default Web Service Project

732

(2)

Create a Base Class to Handle Error Checking for Our Web Service

734

(1)

Create Real Web Service Class

735

(1)

Add Web Methods into Our Web Service Class

736

(1)

Develop the Codes for Web Methods to Perform the Web Services

737

(1)

Web Service Connection Strings

737

(3)

Modify Existing Web Method

740

(1)

Develop Codes to Perform Database Queries

741

(2)

Develop Codes for User-Defined Methods

743

(3)

Develop Stored Procedures to Perform the Data Query

746

(1)

Develop Stored Procedure WebSelectFacultySP

746

(1)

Add Another Web Method to Call the Stored Procedure

747

(1)

Use DataSet as Returning Object for Web Method

748

(3)

Build Windows-Based Web Service Clients to Use the Web Services

751

(1)

Create a Web Service Proxy Class

752

(2)

Develop Graphic User Interface for Windows-Based Client Project

754

(1)

Develop Code to Use the Web Service

755

(7)

Build Web-Based Web Service Clients to Use the Web Service

762

(1)

Create a New Website Project and Add an Existing Web Page

763

(1)

Add a Web Service Reference and Modify the Web Form Window

763

(1)

Modify Codes for Related Methods

764

(5)

Deploy the Completed Web Service to Production Servers

769

(1)

Copy Web Service Files to Virtual Directory

770

(1)

Publish Precompiled Web Service

771

(1)

Build ASP.NET Web Service Project to Insert Data into SQL Server Database

772

(20)

Modify Existing Web Service Project

773

(1)

Web Service Project Development Procedure

774

(1)

Develop and Modify Codes for Code-Behind Page

774

(1)

Develop and Modify First Web Method SetSQLInsertSP

775

(4)

Develop Second Web Method GetSQLInsert

779

(3)

Develop and Modify Third Web Method SQLInsertDataSet

782

(6)

Develop Fourth Web Method GetSQLInsertCourse

788

(4)

Build Windows-Based Web Service Clients to Use Web Services

792

(1)

Build Web-Based Web Service Clients to Use Web Services

793

(12)

Create a New Website Project and Add Existing Web Page

793

(1)

Add Web Service Reference and Modify Web Form Window

794

(1)

Modify Codes for Related Methods

795

(10)

Build ASP.NET Web Service to Update and Delete Data for SQL Server Database

805

(22)

Modify Existing Web Service Project

807

(1)

Modify Related Web Methods

807

(1)

Modify Web Method from SetSQLInsertSP to SQLUpdateSP

808

(2)

Modify Web Method GetSQLInsert to GetSQLCourse

810

(1)

Modify Web Method GetSQLInsertCourse to GetSQLCourseDetail

811

(2)

Add New Web Method SQLDeleteSP

813

(2)

Develop Two Stored Procedures WebUpdateCourseSP and WebDeleteCourseSP

815

(1)

Develop Stored Procedure WebUpdateCourseSP

815

(2)

Develop Stored Procedure WebDeleteCourseSP

817

(10)

Build Windows-Based Web Service Clients to Use Web Services

827

(1)

Build Web-Based Web Service Clients to Use Web Services

827

(8)

Create New Website Project and Add Existing Web Page

828

(1)

Add Web Service Reference and Modify Web Form Window

828

(1)

Modify Codes for Related Methods

829

(1)

Modify Codes in Page_Load Method

830

(1)

Develop Codes for Update Button's Click Method

830

(2)

Develop Codes for Delete Button's Click Method

832

(1)

Modify Codes in Select Button's Click Method and Related Methods

833

(2)

Modify Codes in SelectedIndexChanged Method

835

(19)

Build ASP.NET Web Service Project to Access Oracle Database

838

(1)

Build Web Service Project WebServiceOracleSelect

839

(1)

Modify Connection String

840

(1)

Modify Namespace Directories

840

(1)

Modify Web Method GetSQLSelect and Related Methods

841

(2)

Modify Web Method GetSQLSelectSP and Related Methods

843

(1)

Modifications to Stored Procedure WebSelectFacultySP

843

(4)

Modifications to Codes in Web Method GetSQLSelectSP

847

(1)

Modify Web Method GetSQLSelectDataSet

848

(6)

Build Web Service Clients to Use the Web Service WebServiceOracleSelect

854

(1)

Build ASP.NET Web Service Project to Insert Data into Oracle Database

854

(1)

Build Web Service Project WebServiceOracleInsert

855

(17)

Modify Connection String

855

(1)

Modify Namespace Directories

856

(1)

Modify Web Method SetSQLInsertSP and Related Methods

856

(2)

Modify Web Method GetSQLInsert and Related Methods

858

(2)

Modify Web Method SQLInsertDataSet

860

(2)

Modify Web Method GetSQLInsertCourse and Related Methods

862

(9)

Build Web Service Clients to Use Web Service WebServiceOracleInsert

871

(1)

Build ASP.NET Web Service to Update and Delete Data for Oracle Database

872

(1)

Build Web Service Project WebServiceOracleUpdateDelete

873

(16)

Modify Connection String

873

(1)

Modify Namespace Directories

874

(1)

Modify Web Method SQLUpdateSP and Related Methods

874

(3)

Develop Stored Procedure UpdateCourse_SP

877

(2)

Modify Web Method GetSQLCourse and Related Methods

879

(2)

Modify Web Method GetSQLCourseDetail and Related Methods

881

(2)

Modify Web Method SQLDeleteSP

883

(2)

Develop Stored Procedure WebDeleteCourseSP

885

(2)

Implement and Test Web Service Project

887

(2)

Build Web Service Clients to Use Web Service

889

(1)

Chapter Summary

890

(1)

Homework

891

(4)

Index

895

(8)

About the Author

903

Dr. Ying Bai is an Associate Professor in the Department of Computer Science and Engineering at Johnson C. Smith University (JCSU). Before joining JCSU, Dr. Bai worked as a senior software engineer in the field of automatic control and testing equipment in Silicon Valley, California, and Columbus, Ohio. He has a great deal of experience in robotics control, robot calibrations, and related software programming, as well as accurate measurements in industrial and academic fields. Dr. Bai is a Senior Member of IEEE and a member of ACM. In recent years, he has published six books in multi-language interface programming, serial port programming, electronics, fuzzy logic technology, and database programming with Visual Basic.NET.

Practical Database Programming With Visual C#.NET [Pehme köide]

Konto & seaded

Otsing

Otsingu andmebaas

Filtreeri tulemusi

Teemad Ingliskeelsed raamatud

Vali ostukorv