Introduction to ADO.NET and Databases
A DATABASE is an organized collection of information that is divided into tables. Each table is further divided into rows and columns; these columns store the actual information. You access a database using Structured Query Language (SQL), which is a standard language supported by most database software including SQL Server, Access, and Oracle.
Read more
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
SQL Anywhere Integration with Visual Studio 2005
SQL Anywhere 10 contains a number of integration features with Microsoft Visual Studio .NET (both 2003 and 2005). These features are designed to make it easier to work with a SQL Anywhere database while developing an application using Visual Studio. This whitepaper outlines the integration features that are present with Visual Studio 2005, and contains tutorials demonstrating how the integration features can be used to ease application development while working with a database.
Read more
Working with Data in ASP.NET 2.0 - Querying Data with the SqlDataSource Control
All of the tutorials we’ve examined so far have used a tiered architecture consisting of presentation, Business Logic, and Data Access layers. The Data Access Layer (DAL) was crafted in the first tutorial (Creating a Data Access Layer) and the Business Logic Layer in the second (Creating a Business Logic Layer). Starting with the Displaying Data With the ObjectDataSource tutorial, we saw how to use ASP.NET 2.0’s new ObjectDataSource control to declaratively interface with the architecture from the presentation layer. While all of the tutorials so far have used the architecture to work with data, it is also possible to access, insert, update, and delete database data directly from an ASP.NET page, bypassing the architecture. Doing so places the specific database queries and business logic directly in the web page. For sufficiently large or complex applications, designing, implementing, and using a tiered architecture is vitally important for the success, updatability, and maintainability of the application. Developing a robust architecture, however, can be overkill when creating exceedingly simple, oneoff applications.
Read more
Flex Data Management Services Tutorial for Java Developers
The Flex Data Management Services automate the process of synchronizing data between the client application and the middle-tier. The changes made to the data at the client-side are automatically sent to a service running in your application server. This service then passes the changes to your business layer or directly to your persistence layer, whatever your persistence solution is: DAOs with straight JDBC calls, Hibernate, EJBs, JPA, iBatis, or any other solution.
Read more