Friday, September 5, 2014

Datalist to select items or input elements in the list like Dropdownlist

Place this in the design phase and run the page. Now you can see the page where you can choose an item or input any text inside the datalis...
Read More


Monday, August 11, 2014

How to restrict a Textbox for Copy, Cut, Paste using Asp .Net / Javascript

In your Textbox use the following properties and value to make Textbox Copy Restricted Cut Restricted Paste Restricted oncopy="return false" oncut="return false" onpaste="return fals...
Read More


How to Make a Textbox “No Spaces” using Javascript

Use this code in the  "head" .... section function nospaces(t){ if(t.value.match(/\s/g)){ alert('Sorry, you are not allowed to enter any spaces'); t.value=t.value.replace(/\s/g,''); } } function nospaces(t){ if(t.value.match(/\s/g)){ alert('Sorry, you are...
Read More


Thursday, March 20, 2014

How to find a String/Character/Table/Function used in a Procedure

This is very easy to find any specific string or character you have used in your procedure. You can run the below sql statement and pass the exact string in place of Your_String area. You can find out the list of all the procedures in which that string is implemented....
Read More


Wednesday, March 5, 2014

Limit Number of Characters using JavaScript

Sometimes it becomes a necessity to limit the number of characters in a textbox and to see the number of characters typed in the Textbox. For that we can use JavaScript to perform this task easily....
Read More


Monday, February 3, 2014

Get Details information about Database, Tables, Columns and Stored Procedures in Sql Server

Sometimes it is necessary to get the Creation Date, Modification Date and detailed information about Tables, Stored Procedures, Primary Keys, Foreign Keys and default constraints of a table or in the whole database in SQL Server. The Details information contains columns as:- name,object_id,p...
Read More