ASP.NET Server-Side Data Acces
Introduction to Server-Side Data
Connections, Commands, and DataSets
Accessing SQL-based Data
Binding SQL Data to a DataGrid
Performing a Parameterized Select
Inserting Data in a SQL Database
Updating Data in a SQL Database
Deleting Data in a SQL Database
Sorting Data from a SQL Database
Working with Master-Detail Relationships
Writing and Using Stored Procedures
Accessing XML-based Data
Section Summary
Read more
Comparative Evaluation and Investigation of MS SQL Server 2000 and Oracle 9i with respect to Integrity and SQL 2003 Standards
Database Management and transaction processing systems occupy a crucial position in our information technology-based world. It is imperative that these systems function correctly and reflect real world actions on the data that they store, manage and manipulate. The constantly evolving nature of RDBMSs has lead to database wars among the various vendors in the market. This is evidenced by each vendor in the market making claims of the superiority of his product, hence making the task of choosing a RDBMS not an easy one for a DBA. Thus, the DBMS selection process requires consideration, knowledge and skills. One of the major drives behind the development of RDBMSs is to ensure data consistency, yet this is one of those things that do not seem like an obvious topic for Database Administrators to address directly. Furthermore this has been totally ignored by database benchmarks. Oracle and SQL Server are well established DBMSs, which are amongst the world’s “Big three” DBMSs and are very strong rivals. This project gives an overview of a comparative evaluation of Oracle 9i and Microsoft SQL Server 2000 with respect to Integrity and conformity to the SQL 2003 standards. The results of testing and evaluating the current Database Management Systems help to highlight the problems found in each, hence allowing for improvements if necessary.
Read more
Interactive SQL Server & XML Online Tutorial
Motorway ramps. City streets. Country roads. Wherever you are in a Mazda2, it’s all about fun. The fun that comes from a car that’s responsive and nimble. A car with a healthy dose of sporty attitude. Standard or Sport, whichever model you choose, the fresh style, insightful engineering and spirited performance of Mazda2 is bound to put a smile on your face. And some Zoom-Zoom in your life.
Read more
INFORMIX-Data Director for Visual Basic Tutorial
Why Use Data Director?
Data Director makes developing database applications easier in many ways:
-You can avoid writing code. Data Director extends the Visual Basic drag-and-drop paradigm of application development to allow rapid application prototyping. This includes letting you create master-detail relationships without writing code.
-You can develop applications without knowing complex SQL. Data Directordynamicallygeneratesoptimized SQL statementsforyou,to access and manage your data, so that no knowledge of SQL or the underlying database is required.
Read more