C#实用教程：Visual C# .NET数据库编程详解

需积分: 1 162 浏览量更新于2024-07-23 收藏 16.41MB PDF 举报

"《实用C#数据库编程》是一本专为Visual C# .NET开发者编写的实践指南，由IEEE Press出版，旨在帮助读者掌握在.NET平台上进行高效数据库操作和管理的技术。该书由Lajos Hanzo担任编辑主任，包括R.Abari、T.G.Croda等多位专家共同编撰，确保了内容的专业性和深度。书中涵盖了C#语言与各种数据库系统的交互，如SQL Server、Oracle、MySQL等，提供了丰富的示例和实践经验，帮助读者理解和应用ADO.NET、Entity Framework等.NET框架下的数据库编程技术。对于初学者，它可能从基本的连接、查询、事务处理和数据持久化开始讲解，逐步引导读者步入高级主题，如复杂查询、存储过程调用、分页和数据绑定等。此外，作者 Ying Bai，来自约翰逊·史密斯大学计算机科学与工程系，以其深厚的教学背景，确保了内容的实用性与教学性。书中不仅包含理论知识，还着重强调了实际项目中的应用场景和问题解决策略，使读者能够快速提升在C#环境中进行数据库开发的能力。版权方面，本书受到IEEE和John Wiley & Sons, Inc.的保护，所有内容未经许可不得复制、存储或通过任何形式传播。这表明其权威性和对知识产权的尊重。通过阅读这本书，读者不仅能掌握C#数据库编程的基础，还能了解到最新的最佳实践和行业标准，从而在IT领域保持竞争力。"

xiv Contents

6 Data Inserting with Visual C#.NET 439

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

6.1 Insert New Data into a Database 440

6.1.1 Insert New Records into a Database Using TableAdapter.Insert

Method

441

6.1.2 Insert New Records into a Database Using TableAdapter.Update

Method

442

6.2 Insert Data into Microsoft Access Database Using Sample Project

InsertWizard

442

6.2.1 Create New Project Based on SampleWizards Project 443

6.2.2 Application User Interfaces 443

6.2.3 Create Insert Faculty Form Window 443

6.2.4 Duplicate Visual C#.NET Projects with Installed DataSet 445

6.2.5 Validate Data Before Data Insertion 446

6.2.5.1 The .NET Framework Collection Classes 447

6.2.5.2 Validate Data Using Generic Collection 447

6.2.6 Initialization and Termination Coding for Data Insertion 451

6.2.7 Build Insert Query 453

6.2.7.1 Conﬁ gure TableAdapter and Build Data Inserting

Query

453

6.2.8 Develop Codes to Insert Data Using TableAdapter.Insert

Method

455

6.2.9 Develop Codes to Insert Data Using TableAdapter.Update

Method

457

6.2.10 Validate Data After Data Insertion 462

6.2.10.1 Modiﬁ cations to Faculty Form Window 462

6.2.10.2 Modiﬁ cations to Insert Faculty Form Window 465

6.3 Insert Data into SQL Server Database Using Sample Project

SQLInsertWizard

468

6.3.1 Modify Existing Project to Get New Data Insertion

Project

469

6.3.2 Create New Form Window to Insert Data for Course

Form

470

6.3.3 Trigger and Connect to Visual Studio Design Tools 472

6.3.4 Project Initialization and Validate Data Before Data

Insertion

473

6.3.5 Conﬁ gure TableAdapter and Build Data Insertion Query 476

6.3.6 Develop Codes to Insert Data Using TableAdapter.Insert

Method

477

6.3.7 Develop Codes to Insert Data Using TableAdapter.Update

Method

481

6.3.8 Use Select Button in Course Form to Perform Data

Validation

484

6.3.9 Insert Data into Database Using Stored Procedures 485

6.3.9.1 Create Stored Procedure Using TableAdapter Query

Conﬁ guration Wizard

485

ftoc.indd xivftoc.indd xiv 2/11/2010 2:43:34 PM2/11/2010 2:43:34 PM

Contents xv

6.3.9.2 Modify Codes to Perform Data Insertion Using Stored

Procedure

487

6.4 Insert Data into Oracle Database Using Sample Project

OracleInsertWizard

489

PART II Data Insertion with Runtime Objects 489

6.5 General Runtime Objects Method 490

6.6 Insert Data into SQL Server Database Using Runtime Objects

Method

491

6.6.1 Add Inserting Data Form Window: Insert Faculty Form 491

6.6.2 Modify Codes to Copied Project 493

6.6.3 Startup Coding and Data Validation Before Data Insertion 494

6.6.4 Insert Data into Faculty Table 498

6.6.5 Validate Data After Data Insertion 502

6.6.5.1 Modiﬁ cations to Faculty Form Window 503

6.6.5.2 Insert New Faculty Photo 505

6.6.5.3 Modiﬁ cations to Insert Faculty Form Window 506

6.7 Insert Data into Microsoft Access Database Using Runtime Objects 510

6.7.1 Modiﬁ cations to Namespaces 510

6.7.2 Remove SP Form and Student Form 511

6.7.3 Modify Database Connection String 512

6.7.4 Modify LogIn Query Strings 514

6.7.5 Modify Faculty Query String 515

6.7.6 Modiﬁ cations to Other Forms 515

6.8 Insert Data into Oracle Database Using Runtime Objects 518

6.8.1 Add Oracle Reference and Oracle Namespace 519

6.8.2 Modify Project Namespaces 520

6.8.3 Modify Database Connection String 521

6.8.4 Modify LogIn Query Strings 522

6.8.5 Modify Faculty Query String 523

6.8.6 Modiﬁ cations to Other Forms 525

6.9 Insert Data into Database Using LINQ Queries 526

6.9.1 Insert Data into SQL Server Database Using LINQ to SQL

Queries

527

6.10 Insert Data into Database Using Stored Procedures 527

6.10.1 Insert Data into SQL Server Database Using Stored

Procedures

527

6.10.1.1 Add an Inserting Data Form Window: Insert Course

Form

528

6.10.1.2 Develop Stored Procedures of SQL Server Database 529

6.10.1.3 Develop Codes to Call Stored Procedures to Insert

Data into Course Table

532

6.10.2 Insert Data into Oracle Database Using Stored Procedures 538

6.10.2.1 Develop Stored Procedures in Oracle Database 539

6.10.2.2 Develop Codes to Call Stored Procedures to Insert

Data into Course Table

543

ftoc.indd xvftoc.indd xv 2/11/2010 2:43:34 PM2/11/2010 2:43:34 PM

Contents xvii

7.6.2 Delete Data from Faculty Table for SQL Server

Database

579

7.6.2.1 Develop Codes to Delete Data 579

7.6.2.2 Validate Data Updating and Deleting 581

7.7 Update and Delete Data for Oracle Databases Using Runtime

Objects

584

7.7.1 Add Oracle Namespace Reference 585

7.7.2 Modify Connection String and Query String for LogIn Form 585

7.7.2.1 Modify Connection String in Constructor of LogIn

Class

585

7.7.2.2 Modify SELECT Query String in TabLogIn Button Click

Method

585

7.7.2.3 Modify SELECT Query String in ReadLogIn Button Click

Method

586

7.7.3 Modify Query Strings in Faculty Form 586

7.7.3.1 Modify SELECT Query String for Select Button Click

Method

586

7.7.3.2 Modify UPDATE Query String for Update Button Click

Method

586

7.7.3.3 Modify DELETE Query String for Delete Button Click

Method

587

7.7.4 Modify Query Strings for Course Form 587

7.7.4.1 Modify SELECT Query String for Select Button Click

Method

587

7.7.4.2 Modify SELECT Query String for CourseList Click

Method

587

7.7.5 Other Modiﬁ cations 588

7.8 Update and Delete Data in Database Using Stored Procedures 589

7.8.1 Update and Delete Data in Access Database Using Stored

Procedures

590

7.8.1.1 Modify Existing Project 590

7.8.1.2 Create Stored Procedures in Microsoft Access

Database

592

7.8.1.3 Call Stored Procedure to Update Faculty Information 594

7.8.1.4 Call Stored Procedure to Delete Faculty Information 595

7.8.2 Update and Delete Data in SQL Server Database Using

Stored Procedures

598

7.8.2.1 Modify Existing Project to Create New Project 598

7.8.2.2 Develop Stored Procedure in SQL Server Database 601

7.8.2.3 Call Stored Procedure to Perform Data Updating and

Deleting

605

7.8.3 Update and Delete Data in Oracle Database Using Stored

Procedures

606

7.8.3.1 Modify Existing Project to Create New Project 607

7.8.3.2 Develop Stored Procedure in Oracle Database 610

7.8.3.3 Call Stored Procedures to Perform Data Updating and

Deleting

614

ftoc.indd xviiftoc.indd xvii 2/11/2010 2:43:34 PM2/11/2010 2:43:34 PM

xviii Contents

7.9 Update and Delete Data in Databases Using LINQ to SQL Query 615

7.9.1 Create New Object of DataContext Class 616

7.9.2 Develop Codes for Select Button Click Method 617

7.9.3 Develop Codes for Update Button Click Method 618

7.9.4 Develop Codes for Delete Button Click Method 620

7.10 Chapter Summary 621

Homework 621

8 Accessing Data in ASP.NET 625

8.1 What Is .NET Framework? 626

8.2 What Is ASP.NET and ASP.NET 3.5? 627

8.2.1 ASP.NET Web Application File Structure 629

8.2.2 ASP.NET Execution Model 630

8.2.3 What Really Happens When a Web Application Is

Executed?

630

8.2.4 Requirements to Test and Run a Web Project 631

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

Databases

633

8.3.1 Create the User Interface—LogIn Form 634

8.3.2 Develop Codes to Access and Select Data from Database 635

8.3.3 Validate Data on Client Side 639

8.3.4 Create Second User Interface—Selection Page 640

8.3.5 Develop Codes to Open Other Page 641

8.3.6 Create Third User Interface—Faculty Page 643

8.3.7 Develop Codes to Select Desired Faculty Information 645

8.3.7.1 Develop Codes for Page_Load Method 645

8.3.7.2 Develop Codes for Select Button Method 646

8.3.7.3 Develop Codes for Other Methods 648

8.3.8 Create Fourth User Interface—Course Page 651

8.3.8.1 AutoPostBack Property of Listbox Control 653

8.3.9 Develop Codes to Select Desired Course Information 654

8.3.9.1 Coding for Course Page Loading and Ending

Methods

655

8.3.9.2 Coding for Select Button Click Method 656

8.3.9.3 Coding for SelectedIndexChanged Method of Listbox

Control

658

8.3.9.4 Coding for Other User-Deﬁ ned Methods 659

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

Databases

661

8.4.1 Create New Web Page Insert.aspx 662

8.4.2 Develop Codes to Perform Data Insertion Function 663

8.4.3 Develop Codes for Page_Load and Back Button Click

Methods

664

8.4.4 Develop Codes for Insert Button Click Method 664

8.4.5 Develop Codes for Other Methods 666

8.4.6 Validate Data Insertion 668

ftoc.indd xviiiftoc.indd xviii 2/11/2010 2:43:34 PM2/11/2010 2:43:34 PM

剩余930页未读，继续阅读

txp914

粉丝: 22
资源: 709

C#实用教程：Visual C# .NET数据库编程详解

C#数据库编程实战经典

精通C#数据库编程

c#数据库编程阅览室管理系统

一个完整的C#数据库编程实例

C#数据库编程入门指南

C#源码\实用C#数据库访问包

C#数据库编程从入门到精通（pdg格式）

c#2005数据库编程

C#下数据库编程（2）.doc

基于C#的sqlce 数据库编程

最新资源