{"product_id":"practical-database-programming-with-visual-c-net-isbn-9780470467275","title":"Practical Database Programming With Visual C#.NET","description":"\u003cb\u003eA novel approach to developing and applying databases with Visual C#.NET\u003c\/b\u003e  \u003cp\u003e\u003ci\u003ePractical Database Programming with Visual C#.NET\u003c\/i\u003e clearly explains the considerations and applications in database programming with Visual C#.NET 2008 and in developing relational databases such as Microsoft Access, SQL Server, and Oracle Database. Sidestepping the traditional approach of using large blocks of code, Ying Bai utilizes both Design Tools and Wizards provided by Visual Studio.NET and real-time object methods to incorporate over sixty real sample database programming projects along with detailed illustrations and explanations to help readers understand the key techniques and programming technologies in database programming. This invaluable resource features:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eFundamental and advanced database programming techniques for beginning and experienced students as well as programmers\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eA real completed sample database CSE_DEPT with three versions (Microsoft Access 2007, SQL Server 2005 SP2, and Oracle Database 10g XE Release 2) used throughout the entire book\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eStep-by-step details on designing and building a practical relational database\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eDiscussion and analysis of the new database query technique, LINQ API—which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities, and LINQ to XML—and implementation in actual projects with line-by-line explanation\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eHomework and selected solutions for each chapter to strengthen and improve learning and understanding\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eAn Instructor's Manual (MS PPT), example codes and exercise questions, homework\/exercise solutions, and database projects available for free download\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eE-mail assistance from the author\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eReaders who will benefit highly from this reference are undergraduate or graduate students majoring in computer science and engineering, graduate students in all engineering departments, and software engineers and researchers in academic and industrial fields.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eTo obtain instructor materials please send an email to \u003ca href=\"https:\/\/naemail.wiley.com\/owa\/corrections@wiley.com\/redir.aspx?C=7ed94fc0d3e3434ca3829e14e1ffe731\u0026amp;URL=mailto%3apressbooks%40ieee.org\"\u003epressbooks@ieee.org\u003c\/a\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e  \u003cb\u003ePreface.\u003c\/b\u003e  \u003cp\u003e\u003cb\u003eAcknowledgment.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Introduction.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOutstanding Features of the Book.\u003c\/p\u003e \u003cp\u003eTarget Audience.\u003c\/p\u003e \u003cp\u003eTopics Covered.\u003c\/p\u003e \u003cp\u003eOrganization of the Book and How to Use It.\u003c\/p\u003e \u003cp\u003eHow to Use the Source Code and Sample Databases.\u003c\/p\u003e \u003cp\u003eInstructor and Customer Support.\u003c\/p\u003e \u003cp\u003eHomework Solutions.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Introduction to Databases.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 What Are Databases and Database Programs?\u003c\/p\u003e \u003cp\u003e2.2 Develop a Database.\u003c\/p\u003e \u003cp\u003e2.3 Sample Database.\u003c\/p\u003e \u003cp\u003e2.4 Identifying Keys.\u003c\/p\u003e \u003cp\u003e2.5 Defi ne Relationships.\u003c\/p\u003e \u003cp\u003e2.6 ER Notation.\u003c\/p\u003e \u003cp\u003e2.7 Data Normalization.\u003c\/p\u003e \u003cp\u003e2.8 Database Components in Some Popular Databases.\u003c\/p\u003e \u003cp\u003e2.9 Create Microsoft Access Sample Database.\u003c\/p\u003e \u003cp\u003e2.10 Create Microsoft SQL Server 2005 Sample Database.\u003c\/p\u003e \u003cp\u003e2.11 Create Oracle 10g XE Sample Database.\u003c\/p\u003e \u003cp\u003e2.12 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Introduction to ADO.NET.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 ADO and ADO.NET.\u003c\/p\u003e \u003cp\u003e3.2 Overview of ADO.NET 2.0.\u003c\/p\u003e \u003cp\u003e3.3 Architecture of ADO.NET 2.0.\u003c\/p\u003e \u003cp\u003e3.4 Components of ADO.NET 2.0.\u003c\/p\u003e \u003cp\u003e3.5 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Introduction to Language-Integrated Query (LINQ).\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Overview of Language-Integrated Query.\u003c\/p\u003e \u003cp\u003e4.2 Introduction to LINQ Query.\u003c\/p\u003e \u003cp\u003e4.3 Architecture and Components of LINQ.\u003c\/p\u003e \u003cp\u003e4.4 LINQ to Objects.\u003c\/p\u003e \u003cp\u003e4.5 LINQ to DataSet.\u003c\/p\u003e \u003cp\u003e4.6 LINQ to SQL.\u003c\/p\u003e \u003cp\u003e4.7 LINQ to Entities.\u003c\/p\u003e \u003cp\u003e4.8 LINQ to XML.\u003c\/p\u003e \u003cp\u003e4.9 C# 3.0 Language Enhancement for LINQ.\u003c\/p\u003e \u003cp\u003e4.10 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Data Selection Query with Visual C\u003c\/b\u003e#\u003cb\u003e.NET.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART I Data Query with Visual Studio Design Tools and Wizards.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Completed Sample Database Application Example.\u003c\/p\u003e \u003cp\u003e5.2 Visual Studio.NET 2008 Design Tools and Wizards.\u003c\/p\u003e \u003cp\u003e5.3 Build a Sample Database Project—SelectWizard with SQL Server Database.\u003c\/p\u003e \u003cp\u003e5.4 Add and Utilize Visual Studio.NET Wizards and Design Tools.\u003c\/p\u003e \u003cp\u003e5.5 Query and Display Data Using the DataGridView Control.\u003c\/p\u003e \u003cp\u003e5.6 Use DataSet Designer to Edit the Structure of DataSet.\u003c\/p\u003e \u003cp\u003e5.7 Bind Data to Associated Controls in LogIn Form.\u003c\/p\u003e \u003cp\u003e5.8 Develop Codes to Query Data Using Fill() Method.\u003c\/p\u003e \u003cp\u003e5.9 Use Return a Single Value to Query Data for LogIn Form.\u003c\/p\u003e \u003cp\u003e5.10 Coding for Selection Form.\u003c\/p\u003e \u003cp\u003e5.11 Bind Data to Associated Controls in Faculty Form.\u003c\/p\u003e \u003cp\u003e5.12 Develop Codes to Query Data from Faculty Table.\u003c\/p\u003e \u003cp\u003e5.13 Display Pictures for Faculty Form.\u003c\/p\u003e \u003cp\u003e5.14 Binding Data to Associated Controls in Course Form.\u003c\/p\u003e \u003cp\u003e5.15 Develop Codes to Query Data for Course Form.\u003c\/p\u003e \u003cp\u003e5.16 Build a Sample Database Project—SelectWizardOracle with Oracle Database.\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART II Data Query with Runtime Objects.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.17 Introduction to Runtime Objects.\u003c\/p\u003e \u003cp\u003e5.18 Query Data Using Runtime Objects to Microsoft Access 2007 Database.\u003c\/p\u003e \u003cp\u003e5.19 Query Data Using Runtime Objects to SQL Server Database.\u003c\/p\u003e \u003cp\u003e5.20 Query Data Using Runtime Objects to Oracle Database.\u003c\/p\u003e \u003cp\u003e5.21 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Data Inserting with Visual C\u003c\/b\u003e#\u003cb\u003e.NET.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART I Data Inserting with Visual Studio.NET Design Tools and Wizards.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Insert New Data into a Database.\u003c\/p\u003e \u003cp\u003e6.2 Insert Data into Microsoft Access Database Using Sample Project InsertWizard.\u003c\/p\u003e \u003cp\u003e6.3 Insert Data into SQL Server Database Using Sample Project SQLInsertWizard.\u003c\/p\u003e \u003cp\u003e6.4 Insert Data into Oracle Database Using Sample Project OracleInsertWizard.\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART II Data Insertion with Runtime Objects.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.5 General Runtime Objects Method.\u003c\/p\u003e \u003cp\u003e6.6 Insert Data into SQL Server Database Using Runtime Objects Method.\u003c\/p\u003e \u003cp\u003e6.7 Insert Data into Microsoft Access Database Using Runtime Objects.\u003c\/p\u003e \u003cp\u003e6.8 Insert Data into Oracle Database Using Runtime Objects.\u003c\/p\u003e \u003cp\u003e6.9 Insert Data into Database Using LINQ Queries.\u003c\/p\u003e \u003cp\u003e6.10 Insert Data into Database Using Stored Procedures.\u003c\/p\u003e \u003cp\u003e6.11 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Data Updating and Deleting with Visual C\u003c\/b\u003e#\u003cb\u003e.NET.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART I Data Updating and Deleting with Visual Studio.NET Design Tools and Wizards.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Update or Delete Data in Databases.\u003c\/p\u003e \u003cp\u003e7.2 Update and Delete Data for Microsoft Access Database.\u003c\/p\u003e \u003cp\u003e7.3 Update and Delete Data for SQL Server Database.\u003c\/p\u003e \u003cp\u003e7.4 Update and Delete Data for Oracle Database.\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART II Data Updating and Deleting with Runtime Objects.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.5 Runtime Objects Method.\u003c\/p\u003e \u003cp\u003e7.6 Update and Delete Data for SQL Server Database Using Runtime Objects.\u003c\/p\u003e \u003cp\u003e7.7 Update and Delete Data for Oracle Databases Using Runtime Objects.\u003c\/p\u003e \u003cp\u003e7.8 Update and Delete Data in Database Using Stored Procedures.\u003c\/p\u003e \u003cp\u003e7.9 Update and Delete Data in Databases Using LINQ to SQL Query.\u003c\/p\u003e \u003cp\u003e7.10 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Accessing Data in ASP.NET.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 What Is .NET Framework?\u003c\/p\u003e \u003cp\u003e8.2 What Is ASP.NET and ASP.NET 3.5?\u003c\/p\u003e \u003cp\u003e8.3 Develop ASP.NET Web Application to Select Data from SQL Server Databases.\u003c\/p\u003e \u003cp\u003e8.4 Develop ASP.NET Web Application to Insert Data into SQL Server Databases.\u003c\/p\u003e \u003cp\u003e8.5 Develop Web Applications to Update and Delete Data in SQL Server Databases.\u003c\/p\u003e \u003cp\u003e8.6 Develop ASP.NET Web Applications with LINQ to SQL Query.\u003c\/p\u003e \u003cp\u003e8.7 Develop ASP.NET Web Application to Select Data from Oracle Databases.\u003c\/p\u003e \u003cp\u003e8.8 Develop ASP.NET Web Application to Insert Data into Oracle Databases.\u003c\/p\u003e \u003cp\u003e8.9 Develop ASP.NET Web Application to Update and Delete Data in Oracle Databases.\u003c\/p\u003e \u003cp\u003e8.10 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 ASP.NET Web Services.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 Web Services and Their Components.\u003c\/p\u003e \u003cp\u003e9.2 Procedures to Build a Web Service.\u003c\/p\u003e \u003cp\u003e9.3 Build ASP.NET Web Service Projects to Access SQL Server Database.\u003c\/p\u003e \u003cp\u003e9.4 Build ASP.NET Web Service Project to Insert Data into SQL Server Database.\u003c\/p\u003e \u003cp\u003e9.5 Build ASP.NET Web Service to Update and Delete Data for SQL Server Database.\u003c\/p\u003e \u003cp\u003e9.6 Build Windows-Based Web Service Clients to Use Web Services.\u003c\/p\u003e \u003cp\u003e9.7 Build Web-Based Web Service Clients to Use Web Services.\u003c\/p\u003e \u003cp\u003e9.8 Build ASP.NET Web Service Project to Access Oracle Database.\u003c\/p\u003e \u003cp\u003e9.9 Build Web Service Clients to Use the Web Service WebServiceOracleSelect.\u003c\/p\u003e \u003cp\u003e9.10 Build ASP.NET Web Service Project to Insert Data into Oracle Database.\u003c\/p\u003e \u003cp\u003e9.11 Build Web Service Clients to Use Web Service WebServiceOracleInsert.\u003c\/p\u003e \u003cp\u003e9.12 Build ASP.NET Web Service to Update and Delete Data for Oracle Database.\u003c\/p\u003e \u003cp\u003e9.13 Build Web Service Clients to Use Web Service.\u003c\/p\u003e \u003cp\u003e9.14 Chapter Summary.\u003c\/p\u003e \u003cp\u003eHomework.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIndex.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAbout the Author.\u003c\/b\u003e\u003c\/p\u003e \u003cb\u003eDr. Ying Bai\u003c\/b\u003e is an Associate Professor in the Department of Computer Science and Engineering at Johnson C. Smith University (JCSU). Before joining JCSU, Dr. Bai worked as a senior software engineer in the field of automatic control and testing equipment in Silicon Valley, California, and Columbus, Ohio. He has a great deal of experience in robotics control, robot calibrations, and related software programming, as well as accurate measurements in industrial and academic fields. Dr. Bai is a Senior Member of IEEE and a member of ACM. In recent years, he has published six books in multi-language interface programming, serial port programming, electronics, fuzzy logic technology, and database programming with Visual Basic.NET.  \u003cb\u003eA novel approach to developing and applying databases with Visual C#.NET\u003c\/b\u003e  \u003cp\u003e\u003ci\u003ePractical Database Programming with Visual C#.NET\u003c\/i\u003e clearly explains the considerations and applications in database programming with Visual C#.NET 2008 and in developing relational databases such as Microsoft Access, SQL Server, and Oracle Database. Sidestepping the traditional approach of using large blocks of code, Ying Bai utilizes both Design Tools and Wizards provided by Visual Studio.NET and real-time object methods to incorporate over sixty real sample database programming projects along with detailed illustrations and explanations to help readers understand the key techniques and programming technologies in database programming. This invaluable resource features:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eFundamental and advanced database programming techniques for beginning and experienced students as well as programmers\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eA real completed sample database CSE_DEPT with three versions (Microsoft Access 2007, SQL Server 2005 SP2, and Oracle Database 10g XE Release 2) used throughout the entire book\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eStep-by-step details on designing and building a practical relational database\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eDiscussion and analysis of the new database query technique, LINQ API—which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities, and LINQ to XML—and implementation in actual projects with line-by-line explanation\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eHomework and selected solutions for each chapter to strengthen and improve learning and understanding\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eAn Instructor's Manual (MS PPT), example codes and exercise questions, homework\/exercise solutions, and database projects available for free download\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eE-mail assistance from the author\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eReaders who will benefit highly from this reference are undergraduate or graduate students majoring in computer science and engineering, graduate students in all engineering departments, and software engineers and researchers in academic and industrial fields.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eTo obtain instructor materials please send an email to \u003ca href=\"https:\/\/naemail.wiley.com\/owa\/corrections@wiley.com\/redir.aspx?C=7ed94fc0d3e3434ca3829e14e1ffe731\u0026amp;URL=mailto%3apressbooks%40ieee.org\"\u003epressbooks@ieee.org\u003c\/a\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e","brand":"Wiley-IEEE Press","offers":[{"title":"Default Title","offer_id":47989829861605,"sku":"NP9780470467275","price":136.95,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470467275.jpg?v=1761785604","url":"https:\/\/k12savings.com\/es\/products\/practical-database-programming-with-visual-c-net-isbn-9780470467275","provider":"K12savings","version":"1.0","type":"link"}