SQL

Nov27

Integrate Multiselect plugin with ASP.NET MVC 5 and jquery

The Select2 javascript plugin gives you a customizable select box with support for searching, tagging, remote data sets, infinite scrolling, and many other. It gives a wonderful user experience when you integrate with a web application. In this example,...
Read More
Oct12

Google Map in ASP.NET MVC 5 and AJAX

Integrating Google map with dynamic markers using AJAX is a very handy feature to have when you want to increase the user experience. Visualising is paramount when it comes to location, address, distance etc in this modern technology. In particularly...
Read More
Jan09

Extend asp.net membership schema to store additional user information

In ASP.NET you can use default membership provider and use the aspnet_Profile table to store additional information of a user at the time of registration. If you don’t know how to install Membership Schema then read my previous article Installing...
Read More
Mar26

Create trigger to set column value depending on another table column value in Oracle database

You can create a trigger in Oracle database to set column value dynamically depending on another table column value. Recently some asked this question in Oracle Apex Forum and here was my suggestion for creating trigger to check if the new value exists...
Read More
Mar25

Create dynamic URL in Oracle SQL

Creating a dynamic field or formatting any column is quite easy using case statement in SQL query. In the recent forum post in Oracle Apex forum I have provided an example how to create dynamic URL based on the value of another field. In this example...
Read More