When query results exceed the display area then you resort to scrolling and wish you had some way to limit the number of results displayed and comfortable to view without scrolling. Paging functionality which provides an answer to this is therefore a much desired feature. The Data Pager Control in Visual Studio 2008 provides this functionality when you create an ASP.NET web form under .NET Framework 3.5. It can be configured automatically using the GUI, or it can be installed manually after installing the ListView. In this article both of them are described. While the number of items displayed in a list can be declaratively coded, it is possible to set it at page load time as well.
This article by Dr. Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved data in a ListView Control on a web page. The ListView Control is the only control in ASP.NET that supports the new ASP.NET control, the Data Pager Control. This article shows how the data from a table in SQL Server 2008 is displayed in the ListView and how the Data Pager is configured to cycle the List View items.Read Using the Data Pager Control in Visual Studio 2008 in full
ExpressionEngine comes with a built-in photo gallery module included as part of the purchase fee. With the prevalence of digital cameras, having a place to upload and share photos on your website is a great feature of ExpressionEngine. In this article by Leonard Murphy we will:
- Install the photo gallery module
- Design our photo gallery to fit in with the design of the rest of our site
- Make it easy to upload new photos, add comments and descriptions, and otherwise create a very functional gallery
On our website, we can have multiple photo galleries independent of each other (the photos are in a different folder; the gallery has a different URL) or we can have one gallery for all our photos, using categories to distinguish groups of related photos.
For the purposes of this article we are going to create only one photo gallery, but if desired the same principles can be followed again to create multiple galleries.
To keep our photo gallery visually interesting, we will be straying just slightly from our toast website theme, and will not be using our photo gallery to display slices of toast.
Let's get started!
A database must always be ACID (Atomicity, Consistency, Isolation, and Durability) compliant. Databases comply with ACID requirements through the concept of transactions. In this article by Jonathan Gardner, we will see the differences in the transaction model of PostgreSQL and Oracle. We will look into the details of how PostgreSQL handles transactions and how it can be advantageous over Oracle's Transaction Model.Read PostgreSQL's Transaction Model in full
A business process is a set of coordinated activities that are performed either by humans or by tools with an objective to realize a certain business result. The order of these activities and the efficiency of those who perform the activities determine the overall performance of a business process. It is very much in the interest of every company to have business processes that are efficient and include only necessary activities, because this will allow them to work faster and more efficiently. In this article by Matjaz B. Juric and Kapil Pant, we will look at business process modeling, the main objective of which is to develop a process model that defines the existing process flow in detail.Read Business Process Modeling in full
The first step in protecting web services is to authenticate and authorize the web service requests. Authentication in web services is the process of verifying that the user has valid credentials to access the web services and authorization is the process of validating that the authenticated user has appropriate privileges to access the web services. Besides restricting access to users with valid credentials and proper privileges, Oracle WSM can track who accessed which service and when—to provide detailed audit trails. In this article, Sitaraman Lakshminarayanan explores how Oracle Web Services Manager can be leveraged to authenticate and authorize the web services requests.Read Oracle Web Services Manager: Authentication and Authorization in full
Tetris is a classic game. In this article by Stefan Björnander, we will develop a version very similar to the original version. Seven figures of different shapes and colors fall down and the player's job is to move and rotate them into positions so that as many rows as possible are completely filled. When a row is filled, it disappears. Every removed row gives one point.Read Application Development in Visual C++ - The Tetris Application in full
Knowing where something isn't can be almost as valuable as knowing where something is. If it isn't there, then the time and resources aren't wasted looking in the wrong place. We need to make sure that we have a broad base of methods to manage our future search capabilities. In this article by John Farrar, we will be discussing about the built-in search engine and the custom search engines (Google) in ColdFusion.Read Search Engines in ColdFusion in full
In general, once the FreeNAS server is configured and running, it doesn't really need much attention, it should just work. However, there are lots of different features which can be configured. In this article by Gary Sims, we will see how user management is done in FreeNAS.Read Local User Management in FreeNAS in full
The thought of creating your first skin may be intimidating. You may believe that there are steps that will have to be done just right or there's no point even getting started. The fact is that once you understand some simple concepts, skinning is relatively easy. Ultimately, you will need to know your HTML and CSS markup and styling, but that is common in any type of web design you would do anywhere. This article by Darren Neese is geared toward those who have never created a skin, and it will get you over any anxiety you thought you had about creating a skin.Read DotNetNuke Skinning: Creating Your First Skin in full
Enterprise Service Bus (ESB) is a standard-based middleware architecture that allows pluggable components to communicate with each other via a messaging system. In this article by David Salter, we will see in brief, the components inside the ESB architecture and how they communicate with each other. We will also look at how NetBeans SOA pack integrates with OpenESB and the various functionalities it offers with regards to the ESB.Read 10 Minute Guide to the Enterprise Service Bus and the NetBeans SOA Pack in full
Twitter helps to keep in touch with friends despite the distance and profession. For some friends you might require instant mobile updates while for others, you can just check your email. YouTube is a service providing website wherein we can upload, view and share various video clips. In this article by Richard Carter, we will learn to integrate Twitter and YouTube with MediaWiki.Read Integrating Twitter and YouTube with MediaWiki in full
In this article by Nirav Mehta,we will learn about Adapting and progressively enhancing POTR application using Wireless Abstraction Library and Evaluating tools that aid in adaption.Read Adapting to User Devices Using Mobile Web Technology in full
In this article by Lee Jordon, we are focusing on Google analytics and search engine optimization techniques that work best for blogs. They are as follows:
- Analyzing Navigation
- Optimizing your Landing Page
- Optimizing On-site
- Optimizing Off-site
MySQL Query Browser, one of the open source MySQL GUI tools from MySQL AB, is used for building MySQL database queries visually. In MySQL Query Browser, you build database queries using just your mouse—click, drag and drop!
When you’re creating a query for non-technical users and you don’t want them to see the complexity of the query, you can create a view from the query. Your users can then use the view as a table; for example, they can double-click the view, which will effectively execute its complex query behind the scene.
In MySQL Query Browser, you have two ways to create a view, which Djoni Darmawikarta will demonstrate in this article:
- From an existing query
- Writing from scratch manually