Student Academic blog

If you have one or more then one form in HTML page. You can reset  the form by calling jquery reset function.

Example

$(document).ready(function() {
// you can reset more then one form by using this function
   $("#reset").click(function() {
     $("form").each(function() {
       this.reset();
     });
   });
 });

ALL, asp.net, JQuery jquery, mysql & asp.net, asp.net 4, asp.net, form, reset

Below is the Query to fetch Random record in Oracle.

SELECT ROWNUM
	FROM DUAL
	CONNECT BY LEVEL < 9000;

ALL, Oracle oracle

good news for developer's. Print can be done in Silverlight 4 through  PrintDocument class.

Example

PrintDocument doct = new PrintDocument();

    doct.PrintPage += (s, args)
    {   
        args.PageVisual = LayoutRoot;
    };

    doct.Print(docName);// print dialog box

By using this PrintDocument Class you can print entrie page or to print a specfic part of page.

ALL, SilverLight asp.net, silverlight,

You can get all database name by using below Query.

SELECT NAME FROM SYS.DATABASES

You can also use Store Procedure given below.

EXEC sp_databases

ALL, SQL 2005 & 2008 sql server 2008, sql

If you want to import huge amount of data in a table from another database , then first delete indexes becasue it will import fastly.

ALL, SQL 2005 & 2008 sql server 2008, sql, tips & tricks