Asp. NET Program Development Example Treasure

In the collation of information found some very useful source of information, especially beginners, most of which is usually used in the knowledge point, can refer to its implementation methods, share to everyone to learn, but please do not use for commercial purposes.

If it works for you, please recommend it to others.

Click on the corresponding chapter title to download all the source code under this section.

Directory:

2nd Chapter HTML Development and Practice 15

2.1 Use of the framework 16

Example 009 using the FRAMESET Framework layout Chat Room 16

Example 010 using the IFRAME Framework Layout Enterprise Management System 17

2.2 Rolling Screen Implementation 18

Example 011 scroll to display blog post 18

Example 012 Scrolling effect and implementing hyperlinks 20

2.3 Common HTML Controls 21

Instance 013 Input (reset) control implements the Reset function 21

Instance 014 Table Control Layout login Page 22

Instance 015 Table Control layout DataList template (Staff information) 23

Instance 016 Select control to achieve linkage effect (select Province, show corresponding city) 25

3rd CSS style and JavaScript script application 27

3.1 Control style 28

Example 017 Normal control style 28

Instance 018 Data Control style 29

3.2 Link Control style 30

Instance 019 mouse click Link Style 30

Instance 020 mouse pointer over link style 31

3.3 Page Style 32

Example 021 page Overall style 32

Instance 022 scroll bar style 33

3.4 Menu Design 34

Example 023 drop-down menu 35

Example 024 interpreted menu 36

Example 025 Auto-Hide Menu 38

3.5 Text Effects 41

Instance 026 text flashes one by one 41

Example 027 text scrolling display 43

3.6 Window Control 45

Example 028 opening a new window displaying AD information 45

Example 029 Auto-closed AD window 47

Example 030 Center shows pop-up Windows 48

Instance 031 open a new window display details 50

Instance 032 cookie control for pop-up Windows 51

Example 033 Adding a close button to a popup window 52

Instance 034 closing a pop-up window refreshes the parent window 54

Instance 035 close IE main window, do not pop up the inquiry dialog box 55

3.7 Popup Page dialog box 56

Instance 036 popup Page Mode dialog box 56

Instance 037 Pop-up full screen display on page 58

Instance 038 Web page Color Picker 60

Instance 039 date Selector 62

3.8 Other 63

Instance 040 set to home 64

Example 041 favorite Site 65

Instance 042 starting Favorites 66 when you leave

4th common Web Server Controls 67

4.1 Using controls to display text 68

Example 043 displaying password format text 68

Example 044 shows the long date format time 69

Instance 045 Display amount Format Text 71

4.2 Using controls to display pictures 72

Example 046 display Captcha Picture 72

Example 047 dynamic display of user picture 73

Example 048 using the Web Page dialog box to display the picture 75

Example 049 Implementation upload Image 77

Instance 050 GridView control display Employee Photos 79

4.3 hyperlink to a control 80

Instance 051 ImageButton Button View Product Details 81

Instance 052 gridview using the Hyperlink template column to view more information 82

Instance 053 using LinkButton in DataList control templates View more information 84

4.4 Application of drop-down list box 86

Instance 054 DropDownList control dynamically displaying the GridView Control index page 86

Example 055 linkage between provinces and cities 88

Example 056 adding and removing attachments to a message 90

4.5 Application of radio buttons 92

Example 057 Gender selection 92

Example 058 selection of the answer of single choice in the network examination System 94

4.6 Application of check box 96

Instance 059 Login Identity Selection 96

Example 060 choice of multiple-choice answers in Network examination System 98

4.7 Control connection Data Source 101

Example 061 using the wizard to configure AccessData Source 101

Example 062 using the wizard to configure SqlData Source 103

Example 063 using the wizard to configure XMLData Source 106

4.8 The GridView Control application 108

Instance 064 data binding and paging functionality 108

Example 065 selecting, editing, canceling, and deleting data items 109

Example 066 GridView implementation of two-way sequencing function 111

Instance 067 the binding of the drop Downlist control in the GridView control 113

Instance 068 add a template column dynamically in the GridView control 115

Example 069 Delete selected records by CheckBox 117

Example 070 Implementing cross-page multiple selection in the GridView control 119

Instance 071 Delete GridView control row Information Popup confirmation prompt box 121

Instance 072 implementation of AutoNumber 123 in the GridView control

Instance 073 GridView control implementation main fine table 124

Example 074 view current row details 125

Instance 075 using "..." in cell to replace extra long characters 128

Instance 076 controlling the wrapping of content in the GridView control 129

4.9 GridView control Data conversion with Excel 131

Instance 077 importing data from the GridView into Excel 131

Instance 078 reads data from Excel into the GridView control 133

Example 079 Export data from the GridView to Excel and format it for processing 134

4.10 GridView Control Advanced Application 135

Example 080 draggable column, sortable, width-adjustable GridView 135

Instance 081 the GridView control automatically sums, merges cells, and sorts 138

Example 082 Supply and demand Information Network audit release information 140

Example 083 Student score unqualified cell appears in red 142

4.11 Use of the DataList control 143

Example 084 binding data and implementing paging 143

Instance 085 edit DataList control template display employee Information 146

Example 086 DataList control implementation main fine table 147

Instance 087 DataList control implementation Removal function 149

4.12 Use of the Repeater control 151

Instance 088 Repeater Control Data binding 151

Instance 089 Repeater Control Paging 153

Instance 090 edit Repeater control identification Product information 155

Example 091 Repeater control implementation main fine table 157

5th Chapter Validation Controls 161

5.1 Communication Class Verification 162

Example 092 verifying the e-mail address and ZIP code 162

Example 093 verifying URLs 165

Example 094 verifying phone number 166

5.2 Date and Time class validation 168

Example 095 verifying date input format 168

Example 096 verifying time input Format 170

Example 097 verifying date and time input format 172

5.3 Text and numerical validation 174

Instance 098 verifies whether the textbox is empty 174

Instance 099 verifies that the value entered is within the specified range of 176

Example 100 comparison of two textbox text 178

Example 101 verifying the ID number 180

Example 102 verifying that the input text is Kanji 182

Example 103 Verifying Passport 183

5.4 Custom Validation 185

Example 104 verifying a valid data table name 185

Example 105 Verifying currency type 187

6th Chapter Advanced Web Server Controls 189

6.1 Making an ad strip 190

Example 106 making banner ad strips 190

Example 107 floating AD 192

6.2 Site Navigation 194

Example 108 hyperlink for simple site navigation 194

Example 109 SiteMapPath control implementation supply and demand site navigation 195

Example 110 using the TreeView control to design the navigation for OA office Systems 197

Example 111 using the menu control to implement BBS navigation bar 199

6.3 Login Control using 200

Example 112 using Login control to login 200

Example 113 Creating a new user login with the CreateUserWizard control 202

6.4 Date and Time 203

Example 114 viewing news of a specified date through the Calenda control 203

Example 115 Calendar Memo 205

6.5 personalizing a Web site with the WebParts control 207

Example 116 creating a simple webparts page 207

Example 117 Adding a user control to a WebPart control 209

Instance 118 modifying the appearance and behavior of WebPart controls 209

Instance 119 user dynamically adding WebPart controls 211

6.6 User Control 213

Example 120 site query, search 213

Instance 121 navigation bar control 215

Example 122 Links 216

6.7 Other Controls 217

Example 123 displaying or hiding a group of controls with a Panel control 217

Example 124-à-la-carte function via ListBox control 219

The 7th chapter is ADO. NET Technology 223

7.1 Database Connections 224

Example 125 establishing an Access database connection 224

Instance 126 establishing a connection to an encrypted Access database 225

Instance 127 establishing a SQL Server database connection 226

Example 128 establishing an Oracle database connection 228

Example 129 establishing an ODBC data source connection 229

7.2 Data Add 232

Example 130 adding a single data 232

Example 131 adding more than one item information 234

Instance 132 adding a file to the database 237

7.3 Data Update 239

Instance 133 update specified record 239

Example 134 batch Update data 240

7.4 Data Deletion 242

Instance 135 delete the specified record 242

Instance 136 deleting records in bulk 243

Instance 137 Delete all records 245

7.5 Image Access Technology 247

Instance 138 storing the uploaded image name in the database 247

Example 139 storing a picture in a binary format in a database 248

Instance 140 read the name of the uploaded image in the database and display the picture 250

Instance 141 reads and displays the picture stored in the database in binary mode 251

7.6 Data backup and restore 253

Instance 142 backing up SQL Server database 253

Instance 143 restoring SQL Server database 256

7.7 Transaction Processing 259

Example 144 application of transaction in forum registration 259

Example 145 the application of transaction in inserting multi-table data 261

The 8th Chapter data binding Technology 263

8.1 Data Source Binding 264

Instance 146 format time and bind 264

Instance 147 DataBinder.Eval The image path in the binding database 265

Instance 148 using the Eval method or the Bind method to bind the DataList control to display employee letter 267

Instance 149 binding Variable 268

Instance 150 Binding collection 270

Instance 151 binding Expression 271

Instance 152 Binding method return value 272

Instance 153 binding DataTable Object 273

8.2 Control binding Data 275

Example 154 querying the details of a product and binding to a server control 275

Example 155 binding recipe data in a database to a ListBox control 277

Example 156 binding a news type to a Dropdowenlist control 278

Instance 157 binds an array to the drop down list control 280

8.3 XML Data Binding 281

Instance 158 binding the data in the XML file to the TreeView control 281

Instance 159 binding the data in the XML file to the GridView control 283

Example 160 binding the data in an XML file to a menu control 285

9th. SQL query Related Technologies 289

9.1 SELECT clause 290

Instance 161 querying specific column data 290

Example 162 using column aliases 292

Example 163 adding a calculation on a column 294

Example 164 using a function to set a condition 296

9.2 Query Constants 297

Example 165 querying the number 297

Instance 166 query String 299

Example 167 querying Date data 301

Example 168 querying logical Data 302

Example 169 querying NULL data 304

9.3 Query Variables 306

Example 170 using variables to query string data 306

Example 171 using variables to query numeric data 308

Example 172 using variables to query date-based data 309

9.4 Mode Query 310

Example 173 using _ wildcard character Query 311

Example 174 using the% wildcard to query 312

Example 175 using [] wildcard characters for querying 314

Example 176 querying using the [^] wildcard character 315

Example 177 complex pattern query 316

9.5 Top and Percent limit query results 318

Example 178 query Top 10 Data 318

Example 179 taking out data statistics 10 First Data 320

Example 180 query sales accounted for the top 50% of the book Information 322

Example 181 Query 20% of the book information 323 of the inventory quantity

9.6-period, date query 324

Example 182 querying data for a specified date 324

Instance 183 querying data for a specified time period 326

Example 184 querying data by month 328

9.7 Comparison, logic, duplicate query 330

Instance 185 querying data greater than the specified criteria 330

Instance 186 a query that does not combine conditions with predicates 332

Instance 187 does not display duplicate records when querying 334

Example 188 lists the number of duplicate records and records in the data 336

9.8 using the OR and and operators in queries 338

Example 189 querying with or 338

Example 190 using and for querying 340

Example 191 querying with or, and at the same time 341

9.9 Sorting, grouping statistics 343

Example 192 data grouping statistics (single row) 344

Example 193 using the ALL keyword in a grouped query 346

Example 194 using the CUBE operator in a grouped query 349

Example 195 using rollup in a group query 351

Example 196 Descending query of data 354

Example 197 multi-conditional sorting of data 355

Example 198 sorting the results of a statistic 357

Example 199 inventory by warehouse Group (multi-column) 358

Example 201 using COMPUTE 361

Example 202 using COMPUTE by 363

9.10 Aggregation Functions 365

Example 203 Summary of sales by using aggregate function sum 365

Example 204 using the aggregation function avg to find the average age of a class of students 368

Example 205 using aggregate function min to seek sales, the least profitable goods 369

Example 206 using aggregate function Max to find the most employees with monthly sales 371

Example 207 using the aggregate function count to calculate the number of items with a daily sales greater than a value 373 instance 208 use an aggregate function first or last to find a data table in a record 375

9.11 Multi-table query (connection query) 377

Example 209 querying a multiple-table query using the FROM clause 377

Example 210 using table aliases 379

Instance 211 merging multiple result sets 380

9.12 Nested queries 382

Example 212 simple nested query 383

Example 213 Complex nested query 384

Example 214 application of nested query in query statistics 386

9.13 Sub-query 389

Example 215 using a subquery as a derived table 389

Example 216 using a subquery as an expression 390

Example 217 applying a subquery in an UPDATE statement 392

9.14 Union Statement Union 393

Example 218 using a federated query 393

Example 219 multi-table Union query 395

Example 220 sorting results after a union query 397

9.15 INNER JOIN query 398

Example 221 simple inner JOIN query 398

Example 222 complex INNER JOIN query 400

Example 223 using an INNER JOIN selects all rows related to a row in another table 401

9.16 External Connection Query 403

Instance 224 left OUTER JOIN query 403

Instance 225 right outer join query 405

Example 226 multi-table union query using an OUTER JOIN 406

9.17 querying using in 407

Example 227 using in to introduce a subquery to limit the scope of a query 407

Example 228 using in to query the record information in a table 409

9.18 Cross-table query 410

Example 229 analyzing data using Trasform 410

Example 230 dynamic analysis of data using Trasform 412

Example 231 static cross-table (SQL Server 2000) 414

Example 232 dynamic cross-table (SQL Server 2000) 416

9.19 function Queries 419

Example 233 using a Format function in a query statement 419

Example 234 using a string function in a query statement 420

Example 235 using the DATE function in a query 422

9.20 Having a statement application 423

Example 236 using a having statement to filter grouped data 423

Instance 237 Having a statement applied in a multi-table query 425

Chapter 10th application of views, stored procedures and triggers 427

10.1 Application of Views 428

Example 238 applying views in ASP. 428

Instance 239 getting all the user views in the database 429

Example 240 modifying data through a view 430

10.2 Application of stored procedures 431

Instance 241 ASP. NET application Stored Procedure 431

Example 242 applying a stored procedure to add data 433

Example 243 applying a stored procedure to modify data 434

Example 244 applying a stored procedure to delete data 436

Instance 245 ASP. NET application query stored procedure 437

Instance 246 getting all the stored procedures in the database 438

Example 247 Encrypting stored Procedure 439

10.3 Application of Triggers 441

Example 248 application of INSERT trigger 441

Instance 249 Update trigger application in the system log 443

Example 250 nested use of triggers 444

Instance 251 getting triggers in the database 445

The 11th Chapter ASP. NET built-in objects 447

11.1 Page Pass Value 448

Example 252 page Pass value using Response.Redirect () method 448

Example 253 passing a page address by session object 449

11.2 Getting information 452

Instance 254 Gets the value of the transfer between pages 452

Instance 255 getting the type of client browser 454

Instance 256 get client and server IP address 455

11.3 Online Statistics 456

Example 257 statistics online people 456

Example 258 count IP address logins 458

Example 259 statistical users online dwell time 460

Example 260 Statistics website Total visits 461

Example 261 statistics Day visits 464

11.4 Chat Room 466

Example 262 using the Application object to implement message sending 466

Example 263 using Application object to realize private chat function 469

11.5 Online votes 473

Example 264 using cookie objects to prevent duplicate votes 473

Example 265 can vote only once a month 475

11.6 Shopping Cart 477

Example 266 View Shopping cart 477

Example 267 remove a specified item from the shopping cart 480

Example 268 empty cart 481

12th. Document Processing 485

12.1 Operations on a file 486

Instance 269 creation, movement, copying, and deletion of files 486

Example 270 modifying a file name 489

Example 271 simple reading and writing of files 490

Example 272 Modifying a text file 492

Instance 273 to see if a file exists 494

12.2 Working with Folders 495

Example 274 creating, moving, and deleting a folder 495

Instance 275 modifying the folder name 497

Example 276 to see if a folder exists 498

12.3 File upload and download 499

Example 277 Single File upload 500

Example 278 multi-File upload 501

Example 279 uploading a picture file and displaying 503

Example 280 file Download 505

12.4 traversing a file 506

Instance 281 times all files and directories in the specified directory 507

Instance 282 times the specified drive 508

12.5 on-line compression and decompression files 510

Example 283 compressing files online 510

Example 284 extracting a file online 513

12.6 Other 515

Instance 285 Read registry information 515

Instance 286 Read Drive information 517

Example 287 getting basic information for a specified file 518

13th. Graphic image and Multimedia 521

13.1 Simple Image Drawing 522

Instance 288 GDI + draw lines, rectangles, and polygons 522

Example 289 GDI + draws round, oval, and sector 524

Example 290 drawing a rectangle with a shadow effect 525

13.2 Draw Verification Code 526

Example 291 draw a mixed letter and number code 527

Example 292 drawing Chinese character Verification Code 529

13.3 Bar Chart 531

Example 293 Bar Chart Analysis poll results 532

Example 294 Column Chart analysis website traffic 533

Example 295 Column chart analysis car sales performance 536

Example 296 using the Office build in ASP. Create a Stereoscopic chart 538

134 Percent-Line chart 540

Example 297 percent-line chart analysis population birth rate 540

Example 298 percent-line chart analysis commodity price trends 543

Example 299 percent-Line chart Analysis website popularity index 544

13.5 Pie chart 546

Example 300 pie chart analysis male/female ratio 546

Example 301 Pie chart Analysis product market share 548

Example 302 pie chart Analysis of human Resources 550

13.6 Avatar Selection 552

Example 303 Select the Avatar from the drop-down list 552

Example 304 Selecting the Avatar from the Web Page dialog box 553

13.7 control, display picture effects 555

Example 305 controlling the picture size with the mouse wheel 555

Example 306 displaying random images 556

Example 307 getting the actual size of an image in a page 557

13.8 Flash Animation 558

Example 308 inserting Flash animations 559

Example 309 inserting a background transparent Flash animation 559

13.9 Play and download online 560

Example 310 online on-demand 560

Example 311 MP3 File Download 563

Example 312 homemade video player 565

Example 313 online video with memory appreciation 567

14th Crystal Report and printing 571

14.1 Printing Web Forms 572

Example 314 using JavaScript for printing 572

Example 315 using WebBrowser for printing 573

14.2 Printing Pictures 575

Example 316 printing a picture 575

Example 317 printing resumes 576

14.3 Designing reports with Report Builder 578

Example 318 using report experts to design and display students ' basic information 578

Example 319 Grouping Statistics report 582

Example 320 adding a chart to a Crystal report 584

14.4 operation of data sources and data in Crystal Reports 588

Example 321 using an Access database in a Crystal report 588

Example 322 using SQL Server database in a Crystal Report 590

Example 323 using an Excel workbook in a Crystal report 592

Instance 324 querying across data sources 595

14.5 operation of fields and text objects in a Crystal report 599

Example 325 order Total amount more than 100,000 Yuan show "Congratulations on winning" text 600

Instance 326 salary is greater than or equal to $10,000 using blue font marker 602

14.6 filtering of data in Crystal Reports 604

Example 327 filter items with monthly sales greater than 1 million 605

Example 328 screening of male employees with a salary greater than $2000 607

14.7 grouping and sorting of data in Crystal Reports 609

Example 329 group statistics by warehouse Inventory 609

Example 330 sorted by score score 610

14.8 calculation of the Crystal Report 612

Example 331 Department sales accounted for the company's total volume of performance percentage 612

Example 332 Use cumulative method to add number of digits to each data record 613

14.9 Use of subreports 615

Example 333 inserting a subreport 615

Instance 334 editing and re-importing subreports 617

Example 335 displaying subreports as needed 620

14.10 ASP. NET calls Office to print 622

Example 336 using Word to print employee reports 622

Example 337 using Excel to print student information reports 625

15th. XML Technology 627

15.1 reading and writing XML files 628

Instance 338 Write XML file 628

Instance 339 read XML file 630

Example 340 modifying an XML file 631

Instance 341 reading XML data in SQL Server 632

15.2 XML file Node operations 633

Example 342 inserting an XML node 633

Instance 343 retrieving XML nodes 636

Instance 344 Deleting an XML node 637

15.3 XML File Conversion 639

Example 345 using an XML file in an HTML page 639

Example 346 conversion of a dataset and XML file 641

Instance 347 XSL Transformation XML file 643

15.4 XML file encryption, decryption 645

Instance 348 encrypting XML File 645

Example 349 decrypting an XML file 647

Chapter 16th Web Service 651

16.1 Understanding Web Services 652

Example 350 creating a Web service 652

Example 351 invoking a Web service implementation Simple Calculator 654

16.2 Web Services implementing Database Operations 657

Example 352 using Web services to implement data add operations 657

Instance 353 Web Service Call stored procedure implementation data Delete 659

16.3 Web services to implement communication functions 660

Example 354 using Web service to send SMS 660

Example 355 sending e-mail messages using Web service 662

16.4 Other 664

Example 356 uploading and downloading pictures using Web service 664

Example 357 using Web service to implement verification code technology 667

Instance 358 accessing server variables from a Web service 669

Example 359 using a Web service implementation product number 671

The 17th Chapter ASP. NET Advanced Applications 673

17.1 Accessing Office files 674

Example 361 application of the distance education system PowerPoint Teaching 675

17.2 Email 676

Example 362 sending an email using the SMTP service 676

Example 363 using the JMail component to send a message 681

17.3 Site Search 683

Example 3,641-like search 683

Example 365 Advanced Search 686

Example 366 common Search 690

Example 367 add Baidu and Google search to your website 691

17.4 ASP. NET application packaging and publishing 693

Example 368 Publishing an ASP. NET application 693

Example 369 Packaging ASP. NET Application 695

17.5 other 698

Example 370 convert 15-bit ID number to 18-bit 698

Example 371 simple use of the Freetextbox component (text editor) 700

Instance 372 ASP. NET generate static page 701

The 18th Chapter ASP. NET security mechanism 705

18.1 User Login 706

Example 373 Normal Login 706

Instance 374 Session object to determine user login status 707

Example 375 implementing Single Sign-on on the network 708

Example 376 preventing SQL injection attacks 710

Example 377 authentication Code technology Login 712

18.2 Data encryption Technology 713

Instance 378 MD5 Encrypted login user name and password 713

Example 379 encrypting and decrypting a dataset 715

18.3 Access database Security 718

Instance 380 Access database backup and recovery 718

Example 381 preventing Access databases from being downloaded 719

18.4 Filtering Illegal characters 720

Instance 382 prohibits the user from entering illegal characters 720

Example 383 filtering HTML illegal characters 721

The 19th chapter of the comprehensive example 725

19.1 Enterprise Portal Site 726

Example 384 key recommendation software 726

Example 385 site announcement display and management 728

Example 386 the realization of Friendship link 730

Example 387 implementation of a scrolling ad image 732

19.2 Blog 735

Example 388 Blog user picture management function 735

Example 389 Comment Management page feature implementation 738

Example 390 Administrator management process Implementation 742

Example 391 system security Exit 744

19.3 Forum 746

Example 392 View post information 746

Example 393 Post 749

Example 394 replies. Posts 751

Example 395 Deleting a post and its reply message 753

19.4 e-commerce website 755

Example 396 Commodity management 756

Example 397 member Management 760

Example 398 realization of shopping cart 763

Example 399 Product Search 767

19.5 OA Office automation system (Workflow module) 768

Example 400 System Management 768

Example 401 Job Application 772

Example 402 Leadership Approval 775

Example 403 circulation of approval results 778

20th website design and web page matching 783

20.1 Corporate website 784

Example 404 Car Sales 784

Example 405 Medicine chain 785

Example 406 Hardware Products 786

Example 407 software products 788

Example 408 Logistics 789

Example 409 Hotel 790

20.2 e-Commerce 791 instance 410 e-commerce network 791

Example 411 e-Business 793

20.3 Search Engine 794

Example 412 in-site search engine 794

Example 413 Internet search engine 796

20.4 Institutional Sites 797

Example 414 Government affairs 797

Example 415 Bank 798

Example 416 News 799

20.5 Education Websites 800

Example 417 Scientific Research 800

Example 418 Tertiary institutions 802

20.6 Life Information Category 803

Example 419 Home 803

Example 420 Real Estate 804

20.7 Entertainment Sites 805

Example 421 Music Network 805

Example 422 movie net 807

Example 423 Game Portal 808

20.8 Supply and demand information class 809

Example 424 talent Supply and demand 809

Example 4,252 hand goods supply and demand 811

20.9 other 812

Example 426 people home 812

Example 427 Food Network 814

Example 428 blog site (blogs) 815