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 - Debugging Stored Procedures
Visual Studio provides a rich debugging experience. With a few keystrokes or clicks of the mouse, it’s possible to use breakpoints to stop execution of a program and examine its state and control flow. Along with debugging application code, Visual Studio offers support for debugging stored procedures from within SQL Server. Just like breakpoints can be set within the code of an ASP.NET codebehind class or Business Logic Layer class, so too can they be placed within stored procedures.
Read more
C# Solutions for a Face Detection and Recognition System
Key issues on using a new programming language - C# - in implementation of a face detection and recognition (FDR) system are presented. Mainly the following aspects are detailed: how to acquire an image, broadcast a video stream, manipulate a database, and finally, the detection/recognition phase, all in relation with theirs possible C#/.NET solutions. Emphasis was placed on artificial neural network (ANN) methods for face detection/recognition along with C# object oriented implementation proposal.
Read more
VBScript Database Tutorial Part 1 to 4
Probably the most popular use for ASP scripting is connections to databases. It’s incredibly useful and surprisingly easy to do. The first thing you need is the database, of course. A variety of programs can be used to create it, but probably the most popular is Microsoft Access. You can also use FoxPro or create it directly in an SQL Server using whichever utilities are supplied with the server (Enterprise Manager in the case of Microsoft SQL Server), or native SQL commands.
Read more
Structured Query Language (SQL) Tutorial
Many database applications, such as Access LCTA, offer analyses and utilities to summarize data. In order to summarize data beyond these programs and maintain the database, Structured Query Language (SQL) is required. Although many databases allow for generating queries through the use of a point-and-click tool, this is often time consuming. Once the basic SQL statements are understood, summarizing and maintaining the data will become easier and faster.
Read more