Summary: 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 illustr4ate 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 Stud
io development environment, ASP.NET applications, Windows Forms application, using VB .NET with ADO.NET, complex queries, security, COM interop., and application deployment.
Summary: 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 illustr4ate 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. ...show less
Edition/Copyright:03 Cover: Paperback Publisher:Sams Publishing Year Published: 2003 International: No
View Table of Contents
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.
View eBook Requirements
Adobe Digital Editions Minimum System RequirementsMinimum System Requirements:
Windows 7/8, or Mac OS X 10.6 or above
At least 512 MB RAM, 600 mHZ processor, and 40 MB of hard drive space (75MB for Mac OS)
After purchasing your eBook or eChapter, you will be emailed instructions on where and how to download your free reader.
Due to the size of eBooks, a high-speed Internet connection (cable modem, DSL, LAN) is required for download stability and speed. Your connection can be wired or wireless.
Being online is not required for reading an eBook after successfully downloading it. You must only be connected to the Internet during the download process.
Click here to access the Adobe Digital Editions FAQ
View Digital Rights
Adobe Digital Edition Copying: Allowed, 30 selections may be copied every 30 days Printing: Allowed with no limits Expires: No Expiration Reading Aloud: Allowed Sharing: Not Allowed Min. Software Version: Adobe Digital Editions eBook Reader Suitable Devices: PCs, Tablet PCs, Macs, Laptops
Digital Rights Management (DRM) Key
Copying - Books that cannot be copied will show "Not Allowed." Otherwise, this will detail the number of times it can be copied, or "Allowed with no limits."
Printing - Books that cannot be printed will show "Not Allowed." Otherwise, this will detail the number of times it can be printed, or "Allowed with no limits."
Expires - Books that have no expiration (the date upon which you will no longer be able to access your eBook) will read "No Expiration." Otherwise it will state the number of days from activation (the first time you actually read it).
Reading Aloud - Books enabled with the "text-to-speech" feature so that they can be read aloud will show "Allowed."
Sharing - Books that cannot be shared with other computers will show "Not Allowed."
Min. Software Version - This is the minimum software version needed to read this book.
Suitable Devices - Hardware known to be compatable with this book. Note: Reader software still needs to be installed.
Free Shipping Get Free Shipping on orders over $25 (not including Rental and Marketplace). Order arrives in 5-10 business days.
Need it faster? We offer fast, flat-rate expedited shipping options.
Not the right book for you? We'll gladly take it back within 30 days.
To return an eTextbook:
Your eTextbook is non-returnable once it's been activated. You must contact us about returning your eTextbook before you activate it.
Returns are accepted within 30 days of the purchase date on your order confirmation.
This book qualifies for guaranteed cash back! Buy it now for , then:
Sell it back by:
Guaranteed cash back:
Cost of this book after cash back:
Take advantage of Guaranteed Cash Back. Send your book to us in good condition before the end of the buyback period, we'll send YOU a check, and you'll pay less for your textbooks!
If you find this book for less on Amazon.com (direct from Amazon, not marketplace sellers), we'll match it.
In our warehouse, waiting to ship directly to you.
We hand-inspect every used textbook to make sure it's in good condition.
Buy it now. Sell it later!
Sell this textbook for cash!
When you're done with this book, sell it back to Textbooks.com. In addition to the best possible buyback price, you'll get an extra 10% cash back just for being a customer.
We buy good-condition used textbooks year 'round, 24/7. No matter where you bought it, Textbooks.com will buy your textbooks for the most cash.
We hand-inspect every one of our used textbooks to ensure good condition.
Our used textbooks do NOT have:
Missing or torn pages
Missing or torn cover
Torn or damaged binding
A broken spine
This textbook has never been used.
Due to the size of eTextbooks, a high-speed internet connection (cable modem, DSL, LAN) is required for download stability and speed. Your connection can be wired or wireless.
Being online is not required for reading an eTextbook after successfully downloading it. You must only be connected to the Internet duringthe download process.
XP or Windows 7 (32 or 64 running in 32 bit mode), or Mac OS 10.6 or above
At least 512 MB RAM, 600 mHZ processor, and 40 MB of hard drive space (75MB for Mac OS)
What is the Marketplace? It's another way for you to get the right price on the books you need. We approved every Marketplace vendor to sell their books on Textbooks.com, so you know they're all reliable.
What are Marketplace shipping options? Marketplace items do not qualify for free shipping. When ordering from the Marketplace, please specify whether you want the seller to send your book Standard ($3.99/item) or Express ($6.99/item). To get free shipping over $25, just order directly from Textbooks.com instead of through the Marketplace.
FREE UPS 2nd Day Air Terms
Rental and Marketplace items are excluded. Offer is valid from 1/21/2013 12:00PM to 1/23/2013 11:59AM CST. Your order must be placed by 12 Noon CST to be processed on the same day. Minimum order value is $100.00 excluding Rental and Marketplace items. To redeem this offer, select "FREE UPS 2ND DAY AIR" at checkout. Offer not is not valid on previous orders.