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 datalist.

Read More

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 false"

Read More

How to Make a Textbox “No Spaces” using Javascript

Use this code in the  "head" .... section

The following Textbox is used to call the nospaces() function.

Read More

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

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

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,principal_id,schema_id,parent_object_id,type,type_desc,create_date,modify_date,is_ms_shipped,is_published,is_schema_published

Read More

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