Buy Database Programming with Visual Basic .NET and ADO.NET
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Computer programming / software engineering > Programming and scripting languages: general > Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code
Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code

Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

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.

Table of Contents:
Introduction. 1. Developing Windows Forms Using Bound Controls. Create a Bound List Box. Limit the Data Displayed in a Bound List Box. Bind and View Individual Text Boxes Based Off a Selected List Box Item. Edit and Update Data Using Bound Controls. Add and Delete Records Using Bound Controls. Take Care of Error Handling with Bound Controls. Put the Finishing Touches on a Data Bound Form. Bind Data to ComboBox and DataGrid Controls. Drill Down to Data in the DataGrid Control. 2. Creating SQL Server Database Objects from Visual Studio .NET. Create a New SQL Server Database from Within Visual Studio .NET. Define Tables and Fields. Define a Primary Key and Other Indexes. Define Relations Between Tables. Define Defaults and Constraints. Create Views. Create Stored Procedures. 3. Viewing Data with ADO.NET. Retrieve Data by Using the DataReader Object. Retrieve Results from SQL Server by Using the DataTable Object. Locate Records with the DataTable Object. Filter and Sort Records Using the DataView Object. 4. Manipulating Data with ADO.NET. Edit Data and Update Changes That Are Made to an ADO.NET DataSet Object. Add and Delete Rows in a Dataset with ADO.NET. Execute Parameterized Stored Procedures in ADO.NET. Create and Execute On-the-Fly Batch Updates by Using ADO.NET. 5. Working with Data in Web Forms. Use Bound Controls with Web Form. Validate Data Using Validation Controls. Populate DropDown and ListBox Controls. Display Data Using the Table Control. Display Data Using the Repeater Control. Display, Sort, and Page Data in the DataGrid Control. Add, Edit, and Delete Data Using the DataGrid Control. Hyperlink from a Row in the Data Grid to a Detail Page. 6. Creating Transact-SQL Commands. Retrieve Unique Records Using Only a Select Query. Use Variables and Functions in T-SQL. Use Wildcards and Ranges of Values in a SQL Query. Find Records in a Table Without Corresponding Entries in a Related Table? Take Advantage of Using Subqueries. Create, Modify, and Delete Tables. Create a New Table with Data from Existing Tables? Create and Call SQL Server 2000 User-Defined Functions. 7. Performing Common Database Tasks Using SQL-DMO. Create a Dialog Box to Connect to a New Database, Including Listing Available SQL Servers and Databases. Back Up and Verify a SQL Server Database. Restore a SQL Server Database. Transfer Tables Between SQL Server Databases. Create a Detach/Attach SQL Server Database Dialog Box. 8. Taking Advantage of Data-Driven Techniques. Work with Data-Bound Multi-Select List Boxes Using Windows Forms. Use a Single Windows Form to Update Multiple Lookup Tables. Create a Point-and-Click SQL Server Query Tool for Users Using a Windows Form. Make a Generic Search Form in a Visual Basic .NET Desktop Application. Work with Data-Bound Multi-Select List Boxes Using Web Forms. Use a Single Web Form to Update Multiple Lookup Tables. Create a Point-and-Click Query Tool for Users Using a Web Form. Make a Generic Search Form in an ASP.NET Web Application. 9. Using Classes with Databases to Make Life Easier. Define a Class in Visual Basic .NET. Create a Class That Implements the Interface You Defined. Use Visual Studio .NET Tools to Speed Up Writing ADO.NET Code. Control the Creation and Behavior of Classes. Implement the Methods That Update the Database. Validate Data Passed to Properties and Communicate Errors to Developers. Write Data Validation Code That Can Be Reused in Other Classes. 10. Creating Reports Using Crystal Reports. Create a Report Using Crystal Reports Report Expert. Display a Report That Was Created. Add Calculated Fields to the Crystal Reports Report. Select Whether the Report Will Be Displayed, Printed, or Exported Using Visual Basic .NET Code. Determine Which Records Will Be Printed at Runtime. Print Labels and Control the Order in Which Records Will Be Printed. Create an Onscreen Report That Contains Hyperlinks. 11. Managing SQL Server Security. Create Windows NT/2000 Users. Create Windows NT/2000 Groups. Establish a Windows NT/2000 Authentication Mode. Establish Mixed-Mode Authentication. Create a Standard Login. Create a Windows NT/2000 Login. Use a Fixed Server Role. Create a Database User Account. Use Statement Permissions. Use Object Permissions. Use Fixed Database Roles. Create Custom Database Roles. Create Application Roles. 12. Utilizing XML Data in Your Visual Basic .NET Applications. Use XMLWriter to Create an XML Document. Use XMLReader to Read an XML Document. Work with the XML Document Object Model. Retrieve XML from SQL Server 2000. Work with Datasets and XML. 13. Creating XML Web Services. Get Started with XML Web Services. Create a Simple XML Web Service Using Parameters. Consume XML Web Services. Pass a Dataset Back from an XML Web Service. Appendix A. Desktop Development with ADO. When to Use ADO (Local Database/Single Tier Applications). Looking At the ADO Object Models. Referencing the Type Libraries. Using the Connection Object. Working with the ADO Recordset Object. Executing a SQL Server Stored Procedure By Using ActiveX Data Objects. Executing Batch Updates with ADO and SQL Server. Creating SQL Server Objects with ActiveX Data Objects. Conclusion. Index.

About the Author :
F. Scott Barker holds a bachelor of science in computer science and has worked as a developer in the database field for more than 16 years, first with Clipper, and then with Visual Basic, SQL Server, and Microsoft Access for the past 10 years. Scott has already created and deployed a number of ASP.NET Web sites for his clients. Working at Microsoft for two years, Scott was a member of the Microsoft Access and FoxPro teams. Since leaving, he has been a contractor with Microsoft developing in-house tools used throughout Microsoft. With his company, Applications Plus, Scott has also been doing contract development for many Fortune 500 companies, developing in ASP.NET, Visual Basic .NET, C#, Visual Basic/Access/Office, and SQL Server. Scott has trained for Application Developers Training Company and others all around the U.S. and is a frequent speaker at Microsoft conferences throughout the U.S., Canada, South Asia, and Europe. Through his classes and conferences, Scott has trained thousands of developers. Scott is a writer for a number of development magazines and is the author of F. Scott Barker's Microsoft Access 2002 Power Programming, published by Sams, and Access 97 Power Programming, published by Que. Scott can be reached at his Web site at www.appsplus.com, or via e-mail at FSBarker@AppsPlus.com.


Best Sellers


Product Details
  • ISBN-13: 9780672322471
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Height: 186 mm
  • No of Pages: 544
  • Sub Title: Tips, Tutorials, and Code
  • Width: 230 mm
  • ISBN-10: 0672322471
  • Publisher Date: 20 Sep 2002
  • Binding: Paperback
  • Language: English
  • Spine Width: 30 mm
  • Weight: 916 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code
Pearson Education (US) -
Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!