Developer Tutorials

Cross domain access policy in Silverlight applications

In this article, Sergey examines the role of cross domain access policy in Silverlight. After a short introduction, he examines the interaction between client and server as well as a list of threats which may occur in rich internet applications. He also provides steps to take in order to prevent attacks and operation of Crossdomain Client Access Policy with the help of relevant screenshots and source code.

LINQ the Bridge between the world of Objects & the world of Data

In this article, I will illustrate how LINQ makes the relation between objects and data easy to deal with. I will also use code samples to make a comparison between regular code and LINQ code.

Dynamically creating DeepZoom composition

Explore the process of creating the files to support DeepZoom composition (image pyramids and dz xml files). Assumes a basic understanding of deepzoom. The foundation for the article can be seen on my blog: problog.jamespritz.com.

DoubleAnimation Basics with Silverlight Application

This article describes the basics of developing an animation application using the Silverlight Application project found in Visual Studio 2008 SP1.

Display Paged Recordset Data

A popular way to display data from a recordset, especially a large one, is in a paged fashion. For example, when you ask for all the data from a table in your database, you can see about 20 records neatly arranged in a grid fashion, with the ability to go to the next page, previous page, and so on. This 10-Minute Solution is the first of a series of three articles covering how to incorporate this common interface in your pages. The three articles are separated in terms of ease of understanding and use, from the simplest to the most complex. This first article shows how to display data, hitting the server and database once for each page requested.

GetRows VBScript Class - Part III: Paging the results

In Part I of this series, we saw how to create a VBScript class to query our database using the very fast GetRows() method, and return a recordset as a local array. In Part II, we extended the class to allow ADDing and UPDATEing a row in the database. In this Part III, we will expand the class further to allow pagination of the returned recordset.

ASP & MySQL Record Paging

In un precedente articolo abbiamo visto la tecnica per impostare la paginazione su query molto lunghe in termini di mole di dati ed abbiamo analizzato il sistema per affidare all'oggetto Recordset l'intero compito gestire la paginazione, ma questo sistema, attraverso ASP, funziona solo con database di casa Microsoft come Access ed SQL Server, ma non col database oggetto di questo articolo: MySQL.

Ways to get Alphabetical Paging for your ASP scripts

First, I created a field in the RECORDS table named ALPHA. Then using Access and Word, I copied the first letters of each horse's name into the ALPHA field from the NAMES field. By using ALT-click-drag I was able to copy only the first letters and paste them as a group back into the ALPHA field.

I created a new table called "LETTERS" with a field called "ABC" with a record for each letter of the alphabet. When this table is displayed, each letter is hyperlinked to the list of records that have the matching letter in their ALPHA field.

Sorting Database Records

Ordering the recordset returned from your Access database is very easy - simply specify the columns you wish to order using an ORDER BY clause. When using the ORDER BY clause, ordering will happen by default in Ascending order (lowest to highest value). To order from highest to lowest value all you do is simply add the DESC keyword.

Some examples of ordering using the ORDER BY clause can be seen below.

Recordset Paging Script

The code below pages the records returned from our database 'myLinks.mdb'. The table is called 'tblLinks' and has 3 fields, an 'ID' (autonumber field), a textfield called 'SiteName' and a memo field called 'URL'. This script can be easily modified to suit your requirements.