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


Thursday, November 28, 2013

Restoring Database by Query and Management Studio in SQL Server

Database Restoring is a frequently used approach that developers use to return data to its original condition from which the backup file created. Restoring Database is very easy and simple process. Here are two ways by which you can restore your backup file. ...
Read More