skip to content
Database programming with Visual Basic .NET and ADO.NET : tips, tutorials and code Preview this item
ClosePreview this item

Database programming with Visual Basic .NET and ADO.NET : tips, tutorials and code

Author: F Scott Barker
Publisher: Indianapolis, Ind. : Sams, ©2003.
Edition/Format:   eBook : Document : EnglishView all editions and formats

Create professional database applications designed for local, network, or Internet deployment.


(not yet rated) 0 with reviews - Be the first.

More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Genre/Form: Electronic books
Additional Physical Format: Print version:
Barker, F. Scott.
Database programming with Visual Basic .NET and ADO.NET.
Indianapolis, Ind. : Sams, ©2003
(DLC) 2001094459
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: F Scott Barker
ISBN: 0768662281 9780768662283 9780672322471 0672322471
OCLC Number: 59756553
Notes: Includes index.
Description: 1 online resource (xviii, 524 pages) : illustrations
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.
Responsibility: F. Scott Barker.
More information:


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Database programming with Visual Basic .NET and ADO.NET : tips, tutorials and code
    a schema:CreativeWork, schema:MediaObject, schema:Book ;
    library:oclcnum "59756553" ;
    library:placeOfPublication <> ;
    library:placeOfPublication <> ; # Indianapolis, Ind.
    rdfs:comment "Warning: This malformed URI has been treated as a string - '{FDD988C4-92C3-4544-ABFC-B182BE55B90E}Img100.jpg'" ;
    schema:about <> ; # Database management
    schema:about <> ;
    schema:about <> ; # COMPUTERS--System Administration--Storage & Retrieval
    schema:about <> ; # ActiveX.
    schema:about <> ; # COMPUTERS--Database Management--General
    schema:about <> ; # ActiveX.
    schema:about <> ; # Visual Basic (Computer program language)
    schema:about <> ; # Microsoft .NET Framework.
    schema:about <> ; # COMPUTERS--Desktop Applications--Databases
    schema:bookFormat schema:EBook ;
    schema:copyrightYear "2003" ;
    schema:creator <> ; # F Scott Barker
    schema:datePublished "2003" ;
    schema:exampleOfWork <> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <> ;
    schema:name "Database programming with Visual Basic .NET and ADO.NET : tips, tutorials and code"@en ;
    schema:productID "59756553" ;
    schema:publication <> ;
    schema:publisher <> ; # Sams
    schema:url "{FDD988C4-92C3-4544-ABFC-B182BE55B90E}Img100.jpg" ;
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:workExample <> ;
    schema:workExample <> ;
    wdrs:describedby <> ;

Related Entities

    rdfs:comment "eBook available for Durham College via EBSCOhost. Click link to access" ;

<> # Microsoft .NET Framework.
    a schema:CreativeWork ;
    schema:name "Microsoft .NET Framework." ;

<> # Indianapolis, Ind.
    a schema:Place ;
    schema:name "Indianapolis, Ind." ;

<> # COMPUTERS--Database Management--General
    a schema:Intangible ;
    schema:name "COMPUTERS--Database Management--General"@en ;

<> # COMPUTERS--Desktop Applications--Databases
    a schema:Intangible ;
    schema:name "COMPUTERS--Desktop Applications--Databases"@en ;

<> # COMPUTERS--System Administration--Storage & Retrieval
    a schema:Intangible ;
    schema:name "COMPUTERS--System Administration--Storage & Retrieval"@en ;

<> # Visual Basic (Computer program language)
    a schema:Intangible ;
    schema:name "Visual Basic (Computer program language)"@en ;

<> # ActiveX.
    a schema:CreativeWork ;
    schema:name "ActiveX." ;

<> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;

    rdfs:comment "Access to the Safari Books Online database limited to 7 concurrent users; authentication may be required:" ;

<> # F Scott Barker
    a schema:Person ;
    schema:familyName "Barker" ;
    schema:givenName "F. Scott" ;
    schema:name "F Scott Barker" ;

    a schema:ProductModel ;
    schema:isbn "0672322471" ;
    schema:isbn "9780672322471" ;

    a schema:ProductModel ;
    schema:isbn "0768662281" ;
    schema:isbn "9780768662283" ;

    a schema:CreativeWork ;
    rdfs:label "Database programming with Visual Basic .NET and ADO.NET." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <> ; # Database programming with Visual Basic .NET and ADO.NET : tips, tutorials and code

    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <> ; # Database programming with Visual Basic .NET and ADO.NET : tips, tutorials and code
    schema:dateModified "2018-03-20" ;
    void:inDataset <> ;

    rdfs:comment "Free eBook from the Internet Archive" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.