User Defined Table Standard Module

With the User Defined Table we are able to create a table.  However, the need to know how to connect to a table with asp.net and the sql code required is removed from us.  The image below shows an example of what can be acheived.  Here we arre providing a list of different fruits. 

We are able to define each of the coumns in the table, defining what type it is, perhaps an integer or text type.  As can be seen the order in which the columns appears can be configured using up and down arrows.

Having established the columns and defined the related parameters, we are able to add, update and delete the entries for each row.  In the example below we are adding a plum to our table. If you know some HTML why not use it to set the colour or style of the text in the column.  In this way a row may be highlighted, perhaps a product is on promotion.  If you do this, don't forget that all of the characters in the text box are used when sorting.

Additionally the table may be sorted  either ascending or descending by a given column name