A novel approach to developing and applying databases with Visual C#.NET

"Practical Database Programming with Visual C#.NET" 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:

Fundamental and advanced database programming techniques for beginning and experienced students as well as programmers

A 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

Step-by-step details on designing and building a practical relational database

Discussion 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

Homework and selected solutions for each chapter to strengthen and improve learning and understanding

An Instructor's Manual (MS PPT), example codes and exercise questions, homework/exercise solutions, and database projects available for free download

E-mail assistance from the author

Readers 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.

To obtain instructor materials please send an email to [email protected]

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

A guide to the practical issues and applications in database programming with updated Visual Basic.NET SQL Server Database Programming with Visual Basic.NET offers a guide to the fundamental knowledge and practical techniques for the design and creation of professional database programs that can be used for real-world commercial and industrial applications. The author--a noted expert on the topic--uses the most current version of Visual Basic.NET, Visual Basic.NET 2017 with Visual Studio.NET 2017. In addition, he introduces the updated SQL Server database and Microsoft SQL Server 2017 Express. All sample program projects can be run in the most updated version, Visual Basic.NET 2019 with Visual Studio.NET 2019. Written in an accessible, down-to-earth style, the author explains how to build a sample database using the SQL Server management system and Microsoft SQL Server Management Studio 2018. The latest version of ASP.NET, ASP.NET 4.7, is also discussed to provide the most up-to-date Web database programming technologies. This important book: Offers illustrative practical examples and detailed descriptions to aid in comprehension of the material presented Includes both fundamental and advanced database programming techniques Integrates images into associated database tables using a DevExpress UI tools -WindowsUI Written for graduate and senior undergraduate students studying database implementations and programming courses, SQL Server Database Programming with Visual Basic.NET shows how to develop professional and practical database programs in Visual Basic.NET 2017/Visual Basic.NET 2019.

Oracle Database Programming with Visual Basic.NET Discover a detailed treatment of the practical considerations and applications of Oracle database programming with Visual Basic 2019 Oracle Database Programming with Visual Basic.NET: Concepts, Designs, and Implementations delivers a comprehensive exploration of the foundations of Oracle database programming using Visual Basic.NET. Using Visual Basic.NET 2019, Visual Studio.NET 2019, and Oracle 18c XE, the book introduces the Oracle database development system, Oracle SQL Developer and Modeler, and teaches readers how to implement a sample database solution. The distinguished author also demonstrates the use of dotConnect for Oracle to show readers how to create an effective connection to an Oracle 18c XE database. The current versions of the .NET framework, ASP.NET, and ASP.NET 4.7 are also explored and used to offer readers the most up to date web database programming techniques available today. The book provides practical example projects and detailed, line-by-line descriptions throughout to assist readers in the development of their database programming skill. Students will also benefit from the inclusion of: A thorough introduction to databases, including definitions, examples, descriptions of keys and relationships, and some database components in popular databases, like Access, SQL, and Oracle An exploration of ADO.NET, including its architecture and components, like the DataReader class, DataSet component, DataTable component, and the command and parameter classes A discussion of Language Integrated Query (LINQ), including its architecture and components, its relationship to objects, DataSet, Oracle, and Entities An explanation of how to access data in ASP.NET and ASP.NET Web Services with multiple real project examples. Perfect for college and university students taking courses related to database programming and applications, Oracle Database Programming with Visual Basic.NET will also earn a place in the libraries of programmers and software engineers seeking a comprehensive reference for database coding in Visual Basic.NET.

Written by two experts across multiple disciplines, this is the perfect reference on structural dynamics for veteran engineers and introduction to the field for engineering students. Across many disciplines of engineering, dynamic problems of structures are a primary concern. Civil engineers, mechanical engineers, aircraft engineers, ocean engineers, and engineering students encounter these problems every day, and it is up to them systematically to grasp the basic concepts, calculation principles and calculation methods of structural dynamics. This book focuses on the basic theories and concepts, as well as the application and background of theories and concepts in engineering. Since the basic principles and methods of dynamics are applied to other various engineering fields, this book can also be used as a reference for practicing engineers in the field across many multiple disciplines and for undergraduate and graduate students in other majors as well. The main contents include basic theory of dynamics, establishment of equation of motion, single degree of freedom systems, multi-degree of freedom systems, distributed-parameter systems, stochastic structural vibrations, research projects of structural dynamics, and structural dynamics of marine pipeline and risers. Whether for the veteran engineer or student, this is a must-have for any scientific or engineering library. Useful for students and veteran engineers and scientists alike, this is the only book covering these important issues facing anyone working with coastal models and ocean, coastal, and civil engineering in this area.