By default PHPRunner/ASPRunner.NET provide “Delete selected” functionality. In some cases you need to be able to delete records individually. In this tutorial we will show how to add a delete button to each record. We will also show how to make it look as a regular edit/copy/view buttons.

1. Proceed to the List page in Page Designer and insert a button. Move it to one of grid columns. Set button style to “link-button” and choose icon “glyphicon-remove” as appears on a screenshot below.

Continue Reading "How to add a “Delete” button to each row in grid"

Page Designer is one of the most amazing new features in version 10 but as any new functionality it also introduces a learning curve. In this article we are answering the most common questions people ask us about Page Designer usage.

If you have Page Designer questions that are not answered in this article feel free to ask here in comments or via helpdesk.

How to work with additional pages?

In version 10 you can add extra pages of the same type. For instance, besides the main edit page you can have extra edit pages named edit1, edit2 etc. The big question is how to use these additional pages in your application.

Changing button properties

Since we created multiple edit pages lets see how we can use those. On the List page select Edit button. On the right side using ‘Page’ dropdown select the page this button will open.

Continue Reading "Page Designer: Frequently Asked Questions Answered"

If you purchased or upgraded PHPRunner, ASPRunner.NET or ASPRunnerPro recently you may have noticed that we are using a new checkout solution based on Invoice template. In this article we will show you steps required to add this kind of functionality to your project.

To see how it works live proceed to PHPRunner purchase page, select Edition, enter your email address, add more options on the next screen and click Continue.

Continue Reading "Using Invoice template as a checkout solution"

Lets say you run a mini-hotel and need to build a very simple reservation system. In this article we will show how avoid double-booking only showing the rooms that are available for selected date range. Similar approach can be applied to any other reservation system i.e. if you need to build conference rooms reservation app.

In our database we need two tables, Rooms and Reservations.

Continue Reading "Building a hotel reservation system"

Version 10 makes creating multi-column forms easier. In previous versions you needed to select layout on Style Editor page. In version 10 you can do this right in Page Designer and you can change it at any time without resetting the page. Changes you made to your page will no be lost.

In this article we use Customers table from Northwind database. In Page Designer select Edit page. Here is how it looks by default (all images are clickable):

Continue Reading "Using multi-column design in version 10"

The code base for the MS SQL server of version 7 was initially sold by the original company Sybase SQL server to the software giant of the cyber space Microsoft. It was the first entry of the Microsoft Company to the database market at the enterprise level. The objective was to compete against other companies like IBM and ORACLE. It was actually Microsoft, Sybase and the Adaptive that originally formed a team to create and launch the very first version of the SQL server 1.0…Continue Reading “All about the History of SQL Server”