Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: 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. Bookseller Inventory #
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.
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.
Book Condition: New
Book Description Sams, 2003. Book Condition: Good. 1st. Shows some signs of wear, and may have some markings on the inside. Bookseller Inventory # GRP3337464
Book Description Sams, 2003. Book Condition: Good. 1st. Ships from Reno, NV. Shows some signs of wear, and may have some markings on the inside. Bookseller Inventory # GRP93355077
Book Description Sams Publishing. Paperback. Book Condition: GOOD. Gently used may contain ex-library markings, possibly has some minor highlighting, textual notations, and or underlining. Text is still easily readable. Bookseller Inventory # 2749438304
Book Description Sams Publishing. Paperback. Book Condition: GOOD. book was well loved but cared for. Possible ex-library copy with all the usual markings and stickers. Some light textual notes, highlighting and underling. Bookseller Inventory # 2749386545
Book Description Sams Publishing. Paperback. Book Condition: GOOD. Good clean copy with no missing pages might be an ex library copy; Possibly may have minor marginal notes and or highlighting. Bookseller Inventory # 2758651902
Book Description Pearson Education. Paperback. Book Condition: Good. Light shelving wear with minimal damage to cover and bindings. Pages show minor use. Bookseller Inventory # G0672322471I3N00
Book Description Pearson Education. Paperback. Book Condition: Good. Book shows a small amount of wear to cover and binding. Some pages show signs of use. Bookseller Inventory # G0672322471I3N00
Book Description Sams, 2002. Paperback. Book Condition: Used: Good. Bookseller Inventory # SONG0672322471
Book Description Sams Publishing. PAPERBACK. Book Condition: Very Good. 0672322471 Very Good Condition. Five star seller - Buy with confidence!. Bookseller Inventory # Z0672322471Z2
Book Description Book Condition: Good. Book Condition: Good. Bookseller Inventory # 97806723224714.0