How To Find What Are All The Tables Available In Particular Schema In SQL SEREVER

Query To List All The Tables In a Particular Schema

Query

SELECT * FROM INFORMATION_SCHEMA.TABLES

Description
This Query List All The Tables In a Particular Schema(Database).

For Example
If You Are in the Pubs Schema(Database) In SQL SERVER,This Query List All The Tables available within the particular Schema including systable and user table

Query To List All The Columns Available In A Particular Schema

Query
SELECT * FROM INFORMATION_SCHEMA.COLUMNS

Description
This Query List All The Columns Available In A Particular Schema(Database)

For Example
If You Are in the Pubs Schema(Database) In SQL SERVER, This Query List All The Columns available within the particular Schema

Query To List All The Users Tables In a Particular Schema

Query
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME

Description
This Query List All The Users Tables In a Particular Schema(Database).

For Example
If You Are in the Pubs Schema(Database) In SQL SERVER, This Query List All The Users Tables available within the particular Schema

Query To List All The Columns Available In A Particular Schema

Query
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'AUTHORS'

Description
This Query List All The Columns Available In A Particular Schema(Database) for the Particular Table Authors

To Find The Primary Key Of The Table.

Syntax:

SP_PKEYS YourTableName

Description
This System Procedure Returns the Primary Key Reference Of The Particular Table In That Schema(Database).

Example: SP_PKEYS AUTHORS

Note:Giving the tablename within the single quotes is not mandatory

To Find The Foreign Key Of The Table.

Syntax:

SP_FKEYS YourTableName

Description
This System Procedure Returns the Foreign Key Reference Of The Particular Table In That Schema(Database).

Example: SP_FKEYS AUTHORS
Note: Giving the tablename within the single quotes is not mandatory

Oracle Find or Counts Number Of Row(s) And Column(s) In A Table

select count(*) from TableName // To Count The Number of Row(s) in a Particular table

Ex: Select Count(*) from emp;

select count(*) from user_tab_columns where table_name='TABLENAME';

// To Count The Number of Column(s) in a Particular table,

Note :TABLENAME Should be UPPERCASE Letter

Ex: Select  count(*) from user_tab_columns where table_name = 'EMP'

Dynamically Writing into Web.config File

Inline

    XmlDocument xDoc = new XmlDocument(); // Gobal Declaration
    string Path; // Gobal Declaration
    int i; // Gobal Declaration
    protected void Page_Load(object sender, EventArgs e)
    {
        i = Convert.ToInt32(ConfigurationManager.AppSettings["Test"].ToString());
    }
    protected void bt1_Click(object sender, EventArgs e)
    {
        Path = Server.MapPath("~/web.config");
        xDoc.Load(Path);
        XmlNodeList NodeList = xDoc.GetElementsByTagName("appSettings");
        XmlNodeList tNodeList = NodeList[0].ChildNodes;
        XmlAttributeCollection xAttColl = tNodeList[0].Attributes;
        xAttColl[0].InnerXml = "Test";
        xAttColl[1].InnerXml = Convert.ToString(i + 1);
        xDoc.Save(Path);
        Response.Write(ConfigurationManager.AppSettings["Test"].ToString());
    }

Web.Config

<configuration>

<appSettings>

<add key="Test" value="0" /> <!-- Add This In Your WebConfig File -->

</appSettings>

</configuration>

Solution For Sys.WebForms.PageRequestManagerTimeoutException

< asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeOut="300" >

</asp:ScriptManager>

By Default AsyncPostBackTimeOut Property Value's 90 sec

Ajax UpdatePanal Custom Error Handling

Put This Code Within Inline Form Tag,
Note:Dont Put This JavaScript As a Seperate js File in your project,
use within a form tag

<form id="form1" runat="server">
<script language="javascript" type="text/javascript">


function pageLoad(sender, args)
{

Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(beginRequest);
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(endRequest);

}

function beginRequest(sender, args)
{

.
.
.


}

function endRequest(sender, args)
{

var e = args.get_error();

if (e != null)
{
args.set_errorHandled(true);
alert('Custom Error');
}

}
</script>
</form>

set session timeout in webconfig

<configuration>

<system.web>

<sessionState mode="Off|InProc|StateServer|SQLServer"
<!--
Mode : Specifies where to store the session state.
Off : Indicates that session state is not enabled.
InProc : Indicates that session state is stored locally.
StateServer : Indicates that session state is stored on a remote server.
SQLServer : Indicates that session state is stored on the SQL Server.
-->
cookieless="true|false"
<!--
cookieless : Specifies whether sessions without cookies should be used to identify client sessions.
true : Indicates that sessions without cookies should be used.
false : Indicates that sessions without cookies should not be used. The default is false.
-->
timeout="number of minutes"
<!--
timeout : Specifies the number of minutes a session can be idle before it is abandoned. The default is 20.
-->

stateConnectionString="tcpip=server:port"

<!--
stateConnectionString :Specifies the server name and port where session state is stored remotely.
For example, "tcpip=127.0.0.1:42424". This attribute is required when mode is StateServer.
-->
sqlConnectionString="sql connection string"

<!--
sqlConnectionString : Specifies the connection string for a SQL Server.

For example, "data source=localhost;Integrated Security=SSPI;Initial Catalog=northwind".
This attribute is required when mode is SQLServer.
-->
stateNetworkTimeout="number of seconds"/>

<!--
stateNetworkTimeout : When using StateServer mode to store session state,specifies the number of seconds the TCP/IP network connection between the Web server and the state server can be idle before the session is abandoned. The default is 10.
-->
</system.web>

</configuration>

return values from popup to the parent page(Child To Parent)

This Program Ilustrate a Html Parent Page & Child Page return values from popup to the parent page, when you click a Parent Click Button In A Parent.html, The Child.html page will popped up, Enter any value in the Text Box in the Child.html, then click Child click button, the value entered in the textbox(child.html) will be passed to the textbox(parent.html).

Parent.html
~~~~~~~~~
<html>

<head>

<script language="javascript">

function test()

{

var FrmChild = window.showModalDialog('child.html',null,'status:off;center:yes;scroll:no;');

if(FrmChild != null)

{

document.getElementById('Ptxt').value = FrmChild;

}

else

{

return false;

}

}

</script>

<head>

<body>

<input type="text" id='Ptxt'/> <input type="button" onclick="test();" value="Call Child Window" />

</body>
</html>




Child.html
~~~~~~~

<html>

<head>

<script language="javascript">


function Child()

{

var Str = document.getElementById('ctxt').value; window.returnValue = Str;

window.close();

}
</script>

<head>

<body>

Enter Any Value To Pass To The Parent Window<br />

<input type="text" id='ctxt' />

<input type="button" onclick="Child();" value=" Child Click" /> </body>

</html>


Program Demo

Note : IE Supported

Move Div Vertical ScrollBar Simultaneously

To Make Div To Overflow i had created such Space Between <pre> </pre> tags

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" >
<title>Move Div Vertical ScrollBar Simultaneously</title>
<script language="javascript">
function divScrollR()
{
var Right = document.getElementById('Av');
var Left = document.getElementById('Bv');
Left.scrollTop = Right.scrollTop;
}

function divScrollL()
{
var Right = document.getElementById('Av');
var Left = document.getElementById('Bv');
Right.scrollTop = Left.scrollTop;
}
</script>

</head>
<body>
<form id="form1" runat="server">
<div>
<div id="Av" style="z-index: 102; width: 100px; height: 100px; overflow: auto;
overflow-x: hidden; overflow-y: scroll; left: 10px; position: absolute; top: 16px;" onscroll="divScrollR();">
<pre>













</pre>
</div>
<div id="Bv" style="z-index: 101; top: 16px; width: 100px; height: 100px; overflow: auto;
overflow-x: hidden; overflow-y: scroll; left: 113px; position: absolute;" onscroll="divScrollL();">
<pre>













</pre>
</div>
</div>
</form>
</body>
</html>






Program Demo

Block F5(Refresh) Key In IE and Firefox

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

<title>Block F5 Key In IE & Mozilla</title>

<script language="JavaScript">

var version = navigator.appVersion;

function showKeyCode(e)
{
var keycode =(window.event) ? event.keyCode : e.keyCode;

if ((version.indexOf('MSIE') != -1))
{
if(keycode == 116)
{
event.keyCode = 0;
event.returnValue = false;
return false;
}
}
else
{
if(keycode == 116)
{
return false;
}
}
}

</script>

</head>
<body onload="JavaScript:document.body.focus();" onkeydown="return showKeyCode(event)">

</body>

</html>

Program Demo

Note: Tested In IE 7 & Mozilla Firefox 2.0.0.6

copy to clipboard

<html>
<head>
</head>
<body>
<textarea id='clipText'>Enter Text And Click Button To Copy Text To ClipBoard</textarea><br />
<input type=button id='bt' onclick="clipboardData.setData('Text',document.getElementById('clipText').value);" value="Copy" />
<input type=button onclick="clipboardData.clearData('Text');" value="Clear" />
<input type=button onclick="alert(clipboardData.getData('Text'));" value="Paste" />
</body>

Program Demo

AJAX Control Toolkit 10920 Released

AJAX Control Toolkit 10920 released on 09-20-2007,

More Details and Download,

Restrict Alphabet Input In TextBox Using Regular Expression

<html>
<head>
<script language="javascript">
function blockChar()
{
var str = document.getElementById('txt').value;
str = str.replace(/[^\d]*/g,'');
document.getElementById('txt').value = str;
}
</script>
</head>
<body onload="javascript:document.getElementById('txt').focus();">
<input type="text" id='txt' onkeyup="blockChar();" />
</body>
</html>

Program Demo

Note:IE Supported

Restrict Alphabet Input In TextBox

<html>
<head>
<script language="javascript">
function blockChar(e)
{
var keyVal =(window.event) ? event.keyCode : e.keyCode;
if (window.event) keyVal = window.event.keyCode;
if((keyVal > 64 && keyVal < 93))
{
return false;
}
}
</script>
</head>
<body onload="javascript:document.getElementById('txt').focus();">
<input type="text" id='txt' onkeydown="return blockChar(this);" />
</body>
</html>

Program Demo

Restrict Numberic Input In TextBox

<html>
<head>
<script language="javascript">
function blockNum(e)
{
var keyVal =(window.event) ? event.keyCode : e.keyCode;
if (window.event) keyVal = window.event.keyCode;
if((keyVal > 47 && keyVal < 58) || (keyVal > 95 && keyVal < 107))
{
return false;
}
}
</script>
</head>
<body onload="javascript:document.getElementById('txt').focus();">
<input type="text" id='txt' onkeydown="return blockNum(this);" />
</body>
</html>

Program Demo

Visual Studio 2005 Keyboard Shortcuts(KeyBinding) VII

Navigation

Edit.FindAllReferences             SHIFT+F12 or CTRL+K, R
Edit.GoToBrace                     CTRL+CTRL + ]
Edit.GoToDefi nition               F12
Edit.GoToNextLocation              F8
Edit.IncrementalSearch             CTRL+I
View.ClassViewGo-ToSearch, Combo   CTRL+K,CTRL+V
View.Forward-BrowseContext         CTRL+SHIFT+7
View.PopBrowse-Context             CTRL+SHIFT+8
View.Navigate-Backward             CTRL+MINUS+SIGN (-)
View.Navigate-Forward              CTRL+SHIFT+MINUS SIGN (-)
Edit.FindInFiles                   CTRL +SHIFT  + F
Edit.FindSymbol                    ALT+F12
View.ViewCode                      F7
View.ViewDesigner                  SHIFT+F7
Note: Switches to Design to Source (Available only in Source view.)
View.ViewMarkup                    SHIFT+F7
Note:Switches to Source to Design (Available only in Design view.)
Window.MoveTo-NavigationBar        CTRL+F2
Edit.Find                          CTRL+F
Edit.GoTo                          CTRL+G
Edit.GoToFindCombo                 CTRL+/

Visual Studio 2005 Keyboard Shortcuts(KeyBinding) VI

Debugging

Debug.Autos                      CTRL+D, A
Debug.CallStack                  CTRL+D, C
Debug.Immediate                  CTRL+D, I
Debug.Locals                     CTRL+D, L
Debug.QuickWatch                 CTRL+D, Q
Debug.Start                      CTRL+F5
Debug.StartWithoutDebugging      CTRL+F5
Debug.StepInto                   F11
Debug.StepOut                    SHIFT+F11
Debug.StepOver                   F10
Debug.Stop-Debugging             SHIFT+F5
Debug.Toggle-Breakpoint          F9
Debug.Watch                      CTRL+D, W
Debug.Enable-Breakpoint          CTRL+F9 
Make Datatip Transparent         [CTRL]

Visual Studio 2005 Keyboard Shortcuts(KeyBinding) Part V

Window

View.ClassView                       CTRL+W, C
View.CodeDefi nition-Window          CTRL+W, D
View.Command-Window                  CTRL+W, A
View.ErrorList                       CTRL+W, E
View.ObjectBrowser                   CTRL+W, J
View.Output                          CTRL+W, O
View.PropertiesWindow                CTRL+W, P
View.SolutionExplorer                CTRL+W, S
View.TaskList                        CTRL+W, T
View.Toolbox                         CTRL+W, X
View.ServerExplorer                  CTRL+W, L
Window.Close-ToolWindow              SHIFT +ESC
Data.ShowDataSources                 SHIFT+ALT+D
Window.Close-Document,
Window                               CTRL+F4
Window.Next-Document,
Window Nav                           CTRL+TAB

return values from popup to the parent page(Child To Parent)

This Program Ilustrate a Html Parent Page & Child Page return values from popup to the parent page, when you click a Parent Click Button In A Parent.html, The Child.html page will popped up, Enter any value in the Text Box in the Child.html, then click Child click button, the value entered in the textbox(child.html) will be passed to the textbox(parent.html).

Parent.html
~~~~~~~~~
<html>

<head>

<script language="javascript">

function test()

{

var FrmChild = window.showModalDialog('child.html',null,'status:off;center:yes;scroll:no;');

if(FrmChild != null)

{

document.getElementById('Ptxt').value = FrmChild;

}

else

{

return false;

}

}

</script>

<head>

<body>

<input type="text" id='Ptxt'/> <input type="button" onclick="test();" value="Call Child Window" />

</body>
</html>




Child.html
~~~~~~~

<html>

<head>

<script language="javascript">


function Child()

{

var Str = document.getElementById('ctxt').value; window.returnValue = Str;

window.close();

}
</script>

<head>

<body>

Enter Any Value To Pass To The Parent Window<br />

<input type="text" id='ctxt' />

<input type="button" onclick="Child();" value=" Child Click" /> </body>

</html>


Program Demo

Note : IE Supported

Visual Studio 2005 Keyboard Shortcuts(KeyBinding) Part IV

Refactoring

Refactor.-EncapsulateField                  CTRL+R, E
Refactor.Extract-Interface                  CTRL+R, I
Refactor.ExtractMethod                      CTRL+R, M
Refactor.Promote-LocalVariableto-Parameter  CTRL+R, P
Refactor.Remove-Parameters                  CTRL+R, V
Refactor.Rename                             CTRL+R, R OR F2
Refactor.Reorder-Parameters                 CTRL+R, O

Visual Studio 2005 Keyboard Shortcuts(KeyBinding) Part III

IntelliSense

Edit.CompleteWord        CTRL+SPACEORCTRL+ K, W
Edit.ListMembers         CTRL+JORCTRL+K, L
Edit.QuickInfo           CTRL+K, I
Edit.ParameterInfo       CTRL+SHIFT+SPACEORCTRL+K, P

Build

Build.BuildSolution      F6 OR CTRL+SHIFT+B
Build.BuildSelection     SHIFT+F6

Visual Studio 2005 Keyboard Shortcuts(KeyBinding) Part II

Editing

Edit.CollapseTo-Definitions      CTRL+M, O
Edit.ToggleAllOutlining          CTRL+M, L
Edit.Toggle-OutliningExpansion   CTRL+M, M
Edit.StopOutlining               CTRL+M, P
Edit.CommentSelection            CTRL+K, C
Edit.Uncomment-Selection         CTRL+K, U
Edit.FormatDocument              CTRL+K, D
Edit.FormatSelection             CTRL+K, F
Edit.InsertSnippet               CTRL+K, X
Edit.SurroundWith                CTRL+K, S
Edit. Invoke Snippet From Shortcut TAB
Edit.CycleClipboardRing          CTRL+SHIFT+V
Edit.Replace                     CTRL+H
Edit.ReplaceInFiles              CTRL+SHIFT+H
View.ShowSmartTag                CTRL+. or SHIFT +ALT+F10

Visual Studio 2005 Keyboard Shortcuts(KeyBinding) Part I

File

File.NewProject                        CTRL+SHIFT+N

File.OpenProject                     CTRL+ SHIFT+O

File.OpenFile                            CTRL+O

Project.AddClass                     SHIFT+ALT+C

Project.AddExisting-Item SHIFT+ALT+A

Project.AddNewItem           CTRL+SHIFT+A

Sleep Function Using JavaScript

<html>
<head>
<script language='javascript'>
function sleep()
{

var Sleep = setTimeout("alert('Hi Have A Nice Time And Day ')",2000);    
             // 2000 Millisecond(2 sec)

}
</script>
<body onload='sleep()'>
Alert Box Will Be Displayed After 2 Seconds the Body is Loaded
</body>
</html>

Note: Tested In IE 7

Program Demo

Move More Than one Div Scroll Bar At a time

This Program describe how to move both the scroll bar of the div at a time using Javascript;

Div Element Temp and Temp1 in this program to make the Div divTop and divBot to get Overflow,

<html>

<head>

<script language="">

function divScroll()

{

var Top = document.getElementById('divTop');

var Bot = document.getElementById('divBot');

Top.scrollLeft = Bot.scrollLeft;

}

</script>

</head>

<body >

Top

<div id='divTop' style="Top:100px; left:0px; width:100px; overflow:auto; overflow-y:hidden; " >

<div id='Temp' style="width:400px;">Test</div></div><br />

Bottom

<div id='divBot' style="width:100px; overflow:auto; overflow-y:hidden;" onscroll="divScroll();">

<div id='Temp1' style="width:400px;">Test1</div></div></body>

</html>

Program Demo

Note IE Supported

Download Visual Studio 2008 Beta 2

Welcome To Visual Studio Arena

Visual Studio 2005 Downloads

Visual Studio 2005Service Pack 1 (SP1)

.Net Framework

Feature Specifications for Visual Studio 2008 and .NET Framework 3.5

Microsoft Pre-Release Software Microsoft .NET Framework 3.5 – Beta 1

Microsoft .NET Framework 3.5 Beta 2
 
Visual Studio 2008 Downloads

Visual Studio 2008 Beta 2 Express Editions

Visual Studio 2008 Beta 2 Standard Edition

Visual Studio 2008 Beta 2 Professional Edition

Visual Studio Team System 2008 Beta 2 Team Suite

Visual Studio Team System 2008 Beta 2 Team Foundation Server

Visual Studio Team System 2008 Beta 2 Test Load Agent

MSDN

MSDN Library for Visual Studio 2008 Beta 2

Expression Studio

Microsoft Expression Studio Free Trial

                                                                                                                                                          

courtesy

Remove Space At Beginning Of The String Using Regular Expression (Left Trim)

<html>
<head>
<script language="javascript">
function Right_Trim()
{
var str = document.getElementById('txt1').value;
str = str.replace(/^\s+/g,'');
document.getElementById('txt1').value = str;
document.getElementById('txt1').focus();
}
</script>
</head>
<body>
<input type='text' id='txt1' value='                 Click To Check' />
<input type='button' id='bt1' value='Remove Space At Beginning Of The String' onclick='Right_Trim();' />
</body>
</html>

Removing The White Space In The String At The End Using Regular Expression (Right Trim)

<html>
<head>
<script language="javascript">
function Left_Trim()
{
var str = document.getElementById('txt1').value;
alert(str.length);// Alert To Show The Length Of The String Before Removing White Space
str = str.replace(/\s+$/g,'');
alert(str.length); // Alert To Show The Length Of The String After Removing White Space
document.getElementById('txt1').value = str;
document.getElementById('txt1').focus();
}
</script>
</head>
<body>
<input type='text' id='txt1' value='Click To Check ' /> <input type='button' id='bt1' value='Remove Space At End Of The String' onclick='Left_Trim();' />
</body>
</html>

Trap F1 key in IE, ByPass Showing Help Window

Blocking F1 keys using javascript,

<html>
<head>
<script>
function ByPass()
{
var kCode = window.event.keyCode;
       if(kCode == 112)
      {
             alert('F1 Clicked'); // Alter Code As Your Wish
       }
}
</script>
</head>
<body onhelp="return false;" onkeydown="ByPass()">
</body>
</html>

Note: Tested In IE 7

60 years of Freedom - Happy Indian Independence Day

Here I Wishing everyone a very Happy Indian Independence Day. 15th August, 1947 was the day India got her Independence from the British. And here we are 60 years hence, making good progress on the long winding road to success.

Listen Vande Mataram Online

Decide Which Certification Is Right for You

If You are decided to Write Exam, Then Choose Which Certification Is Suit For Your Career

Setting Up | Changing the default browser used in VS 2005

Step 1: Open a WebForm .aspx file in .NET IDE.

Setp 2: Select the "Browse With..." option from the File menu.

Or

1) Right click on a .aspx page in your solution explorer

2) Select the "browse with" context menu option


Step 2.1:Browser Dialog Will displayed in screen.

Step 2.2:Click Add Button From the Browser Dialog.

Step 3:In the Add Dialog, Two think have to mention,Program name and friendly name.

Step 3.1: In Program name, have to give the Full Path Of the Browser.

For Example:

Opera :"C:\Program Files\Opera\Opera.exe".

FireFox:"C:\Program Files\Firefox\firefox.exe".

Step 3.2:Friendly Name, You can give any name as your wish.

Step 4:Select your preferred browser from the list and click the "Set as Default" button.

JavaScript Program To Display Date and Current Time

<html>
<head>
<script type="text/javascript">
function TickTick()
{
var today=new Date()
var dd = today.getDate();
var mm = today.getMonth();
var yy = today.getFullYear();
var h=today.getHours()
var m=today.getMinutes()
var s=today.getSeconds()
m=secTicker(m)
s=secTicker(s)

document.getElementById('Clock').innerHTML="<strong>"+dd+"-"+mm+"-"+yy+" (dd/mm/yyyy)<br/>"+h+":"+m+":"+s+"</strong>";
t=setTimeout('TickTick()',1000)

}

function secTicker(i)// This Function is to add zero before minutes and second value which is less than 10
{
if (i < 10){i = "0" + i}return i; }
</script>
</head>

<body onload="TickTick()">
<div id="Clock"></div>

</body>
</html>

OutPut

Date() Object In JavaScript

Dates and times creates a series of special problems to the computer programming particularly Web programmer who has to supply web Content to a global audience. For Example:Some countries present the date as dd/mm/yy while others use mm/dd/yy.

In JavaScript Date Object is a part of the overall specification of JavaScript and is available to any page that can include JavaScript,you create a new date object instance by creating a variable as follows: dtObj = new Date( );

The Date( ) object doesn't have properties that can be directly read and written. Instead it has methods that are used to work with the data value in the object.

Program:

<html>
<head>
<title>Date Object In JavaScript</title>
</head>
<body>
<script language="javascript">
dtObj = new Date();

document.write
("Return the day of the month "+"("+dtObj.getDate( )+")"+".<br/><br/>");

// O/P Will Be == > Return the day of the month 9

document.write
("Return the day of the week "+"("+dtObj.getDay( )+")"+ ".<br/><br/>");

// O/P Will Be == > Return the day of the week 4.

document.write
("Return the four digit year "+"("+dtObj.getFullYear( )+")"+ ".<br/><br/>");

// O/P Will Be == > Return the four digit year 2007.

document.write
("Return the hours "+"("+dtObj.getHours( )+")"+ ".<br/><br/>");

// O/P Will Be == > Return the hours 18.

document.write
("Return the milliseconds "+"("+dtObj.getMilliseconds( )+")"+ ".<br/><br/>");

// O/P Will Be == > Return the milliseconds 125.

document.write
("Return the minutes "+"("+dtObj.getMinutes( )+")"+ ".<br/><br/>");

// O/P Will Be == > Return the minutes 29.

document.write
("Return the month "+"("+dtObj.getMonth( )+")" + ".<br/><br/>");

// O/P Will Be == > Return the month 7.

document.write
("Return the seconds "+"("+dtObj.getSeconds( )+")" + ".<br/><br/>");

// O/P Will Be == > Return the seconds 17

document.write
("Return the internal representation of the time "+"("+dtObj.getTime( )
+")"+ ".<br/><br/>");

// O/P Will Be == > Return the internal representation of the time 1186664357125.

document.write
("Return the offset from GMT "+"("+dtObj.getTimezoneOffset( ) +")"+ ".<br/><br/>");

// O/P Will Be == > Return the offset from GMT -330.

document.write
("Return the Universal Time day of the month "+"("+dtObj.getUTCDate( )+")" + ".<br/><br/>");

// O/P Will Be == > Return the Universal Time day of the month 9.

document.write
("Return the Universal Time day of the week "+"("+dtObj.getUTCDay( )+")"+ ".<br/><br/>");

// O/P Will Be == > Return the Universal Time day of the week 4.

document.write
("Return the Universal Time four digit year "+"("+dtObj.getUTCFullYear( )+")" + ".<br/><br/>");

// O/P Will Be == > Return the Universal Time four digit year 2007.

document.write
("Return the Universal Time hours "+"("+dtObj.getUTCHours( )+")" + ".<br/><br/>");

// O/P Will Be == > Return the Universal Time hours 12.

document.write
("Return the Universal Time milliseconds "+"("+dtObj.getUTCMilliseconds( )+")" + ".<br/><br/>");

// O/P Will Be == > Return the Universal Time milliseconds 125.

document.write
("Return the Universal Time minutes "+"("+dtObj.getUTCMinutes( ) +")"+ ".<br/><br/>");

// O/P Will Be == > Return the Universal Time minutes 59.

document.write
("Return the Universal Time month "+"("+dtObj.getUTCMonth( )+")"+ ".<br/><br/>");

// O/P Will Be == > Return the Universal Time month 7.

document.write
("Return the Universal Time seconds "+"("+dtObj.getUTCSeconds( )+")"+".<br/><br/>");

// O/P Will Be == > Return the Universal Time seconds 17.

document.write
("The time and date at Your computer's location "+"("+dtObj.toLocaleString()+")" + ".<br/><br/>");

//The time and date at Your computer's location Thursday, August 09, 2007 6:29:17 PM.

document.write
("The time zone offset B/W local time and GMT is "+"("+dtObj.getTimezoneOffset()+")" + " minutes.<br/><br/>");

//The time zone offset B/W local time and GMT is -330 minutes.

document.write
("The time and date (GMT) is: "+"("+dtObj.toGMTString()+")" + ".<br/><br/>");

//The time and date (GMT) is: Thu, 9 Aug 2007 12:59:17 UTC.

</script>
</body>
</html>

Note: Output In Coment Line are which i got as result when i Compiled in My System, so date and time will change according your system time and day.

Dynamically Increase The Size Of The TextBox Using JavaScript

<html>
<head>
<script>
function incr()
{
var len = document.getElementById('txt').value;
document.getElementById('txt').style.width = 75+len.length*4+'px';
}
</script>
<body>
<input type='text' id='txt' onkeydown='incr()' style='width:75px' />
</body>
</html>

Remove White Space In String Using Regular Expression in JavaScript

<html>
<head>
<script language="javascript">
function rmWhiteSpace()
{

var str = document.getElementById('txt1').value;

str = str.replace(/\s+/g,'');

document.getElementById('txt1').value = str;

// \s+ Description
// + 1 or more of previous expression.
// \s Matches any white-space character.
// Equivalent to the Unicode character categories [\f\n\r\t\v\x85\p{Z}].
// If ECMAScript-compliant behavior is specified with the ECMAScript option,
// \s is equivalent to [ \f\n\r\t\v].
}
</script>
</head>
<body>
<input type='text' id='txt1' value=' Click To Check' /> <input type='button' id='bt1' value='Remove White Space' onclick='rmWhiteSpace();' />
</body>
</html>

Program Demo

OutPut

Software life cycle (Alpha & Beta Version)

              A software release is the distribution, whether public or private, of an initial or new and upgraded version of a computer software product. Each time a software program or system is changed, the programmers and company doing the work decide on how to distribute the program or system, or changes to that program or system.

            The software release life cycle is composed of different stages that describe the stability of a piece of software, such as Pre-alpha,alpha,beta,Release candidate,Gold

Origin of 'α' and 'ß'

            The term beta test applied to software comes from an early IBM hardware product test convention dating back to punched card tabulating and sorting machines. Hardware first went through an alpha test for preliminary functionality and small scale manufacturing feasibility. Then came a beta test to verify that it actually correctly performed the functions it was supposed to and could be manufactured at scales necessary for the market, and then a c test to verify safety. Beta tests were conducted by people or groups other than the developers. As other companies began developing software for their own use, and for distribution to others, the terminology stuck and now is part of our common vocabulary.

Pre-alpha

            pre-alpha release before alpha or beta, is not "feature complete". It refers to all activities performed during the software project prior to software testing. These activities can include requirements analysis, software design, software development and unit testing.

Alpha

           The alpha version of a product still awaits full testing of all its functionality and is not feature complete, but satisfies all the software requirements. As the first major stage in the release lifecycle, it is named after alpha(the first letter in the Greek alphabet). Alpha level software can be considered approximately 35% complete, and typically includes temporary material and multiple product-breaking issues.

Beta

           A beta version is the first version released outside the organization or community that develops the software, for the purpose of evaluation or real-world black/grey-box testing. The process of delivering a beta version to the users is called beta release. Beta level software is between 60% and 70% complete, generally includes all features, but may also include known issues and bugs of a less serious variety.

Release candidate

          The term release candidate refers to a version with potential to be a final product, ready to release unless fatal bugs emerge. In this stage, the product features all designed functionalities and no known showstopper class bugs. At this phase the product is usually code complete.

Gold or general availability release

          The gold or general availability release version is the final version of a particular product. It is typically almost identical to the final release candidate, with only last-minute bugs fixed. A gold release is considered to be very stable and relatively bug-free with a quality suitable for wide distribution and use by end users. In commercial software releases, this version may also be signed

Courtesy

Inserting Date And Selecting Particular Date From Table Using Oracle

Cearting A Sample Table With The Date Field

create table EMP1_Test(id varchar(5),Fname varchar(10), DOB date)

insert into EMP1_Test(ID,FNAME,DOB) values('1','Test',to_date('19991010','yyyymmdd'))
insert into Emp1_Test(ID,FNAME,DOB) values('2','Test',to_date('11101999','mmddyyyy'))

select * from EMP1_test

select * from EMP1_Test where to_char(dob,'MM/DD/YYYY') = '10/10/1999'

Get Mouse Position Using JavaScript

IE Supported

<html>
<body>
<script language="JavaScript">
<!--
document.onmousemove = getCoordinate;
var mosX = 0 ;
var mosY = 0 ;
function getCoordinate(e)
{
mosX = event.clientX + document.body.scrollLeft ;

//clientX Property Sets or retrieves the x-coordinate of the mouse
//pointer's position relative to the client area of the window,
//excluding window decorations and scroll bars
//scrollLeft Property Sets or retrieves the distance between the
//left edge of the object and the leftmost portion of the content
//currently visible in the window.

mosY = event.clientY + document.body.scrollTop;

//clientY Property Sets or retrieves the y-coordinate of the mouse
//pointer's position relative to the client area of the window,
//excluding window decorations and scroll bars.
//scrollTop Property Sets or retrieves the distance between the top
//of the object and the topmost portion of the content currently
//visible in the window.

document.title = "(X Co-Ordinate » "+ mosX +") ( "+"Y Co-ordinate » " +mosY+")";
document.getElementById('dx').innerHTML = "Mouse X ==» "+mosX+"<br>"+"Mouse Y ==» "+mosY;

return true
}
//-->
</script>
<div id="dX"></div>
</body>
</html>

C# Regular Expressions

some simple regexes for simple string processing

get filename from url (full filename)
([^\\\\]*$)

get extension from url (full filename)
(?<=\\.)([^\\\\]*$)

Parsing XML String To XML Using JavaScript

This Program Convert The XML String To XML
<html>
<body>
<script type="text/javascript">
var x;var xmlObj
var t="<NewDataSet>"
t+="<TestDTag>"
t+="<TestDate>06/07/2007</TestDate>"
t+="</TestDTag>"
t+="<TestDTag>"
t+="<TestDate>06/06/2007</TestDate>"
t+="</TestDTag>"
t+="<TestDTag>"
t+="<TestDate>06/05/2007</TestDate>"
t+="</TestDTag>"
t+="<TestDTag>"
t+="<TestDate>06/04/2007</TestDate>"
t+="</TestDTag>"
t+="<TestDTag>"
t+="<TestDate>06/03/2007</TestDate>"
t+="</TestDTag>"
t+="</NewDataSet>";
if (window.ActiveXObject)
{
xmlObj=new ActiveXObject("Microsoft.XMLDOM");
xmlObj.async="false";
xmlObj.loadXML(t);
}

if(xmlObj.documentElement != null)
{
var data = xmlObj.documentElement;
var Adate = xmlObj.documentElement.getElementsByTagName('TestDate');
for (i=0;i<=Adate.length-1;i++)
{
document.write(i+"th ChildElement -->"+data.childNodes[i].childNodes[0].nodeTypedValue+"<br>");
}
}
</script>
</body>
</html>

IE Supported

Restrict User From Ctrl Key Press

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Restrict Ctrl Key Press</title>
<script>
function Restrict()
{
if((window.event.keyCode ==17))
{
alert("Ctrl Key Press In !"+'\r\n'+ "Add Your Own Code Here"); // Add Your Code Here
}
}
</script>
</head>
<body onload="JavaScript:document.body.focus();" onkeydown="Restrict()">
</body>
</html>

(IE Supported)

JavaScript Get Key Values Or Code On KeyDown

Script
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Find KeyCode</title>
<script language="JavaScript">
function TriggeredKey(e)
{
var keycode;
if (window.event) keycode = window.event.keyCode;
alert("keycode: " + keycode);
}
</script>
</head>
<body onkeydown="TriggeredKey(this)">
</body>
</html>



(IE Supported)

Special Keyboard Key(s) Code

KeyCode
Backspace      8
Tab            9
Enter         13 
Shift         16 
Ctrl          17 
Alt           18 
Pause/Break   19 
Caps Lock     20 
Esc           27 
Page Up       33 
Page Down     34 
End           35 
Home          36 
Left Arrow    37 
Print Screen  44
Delete        46
F1            112
F2            113
F3            114
F4            115
F5            116
F6            117
F7            118
F8            119
F9            120
F10           121
F11           122
F12           123

Google Page Creator

Want to create an online photo tour of your vacation or to share the memorable moments with Your Fiends,Peers and others.....

If you Have Gmail Acount It's Enough Get,Set,Go.................

             Google testing a new product that makes creating your own web pages as easy as creating a document in  a word processor. Google Page Creator is a free tool that lets you create web pages right in your browser and publish them to the web with one click. There's no software to download and no web designer to hire. The pages you create are hosted on Google servers and are available at http://yoursitename.googlepages.com for the world to see.

Courtesy

Hold Back Or Retain Scroll Bar Postion After PostBack Or Roundtrip

Page Directive

<%Page smartNavigation="True" %>

Global setting

<configuration>
        <system.web>
                 <pages smartNavigation="true"/>
       </system.web>
</configuration>


SmartNavigation Property available only in .NET 1.1,In ASP.NET version 2.0, the SmartNavigation property is deprecated.Use the SetFocus method and the MaintainScrollPositionOnPostback property instead.

Note Regarding SmartNavigation

1. Eliminating the Flicker caused by navigation Or Postback.
2. Persisting the scroll position when moving from page to page.
   
3. Persisting element focus between navigations.

Delete File If Exists Else Create

This Porgarm will delete a file with name Test.txt if exists in the Root Dir, else create a new file with name Test.txt with in the Root dir.FileInfo and File both the classes are available in System.IO namespace.

FileInfo Class
Provides instance methods for the creation, copying, deletion, moving, and opening of files, and aids in the creation of FileStream objects. This class cannot be inherited.

File Class
Provides static methods for the creation, copying, deletion, moving, and opening of files, and aids in the creation of FileStream objects.

Program

protected void btCreate_Click(object sender, EventArgs e)
{
try
{
FileInfo TheFile = new FileInfo(MapPath(".") + "\\" + "Test.txt");
if (TheFile.Exists)
{
File.Delete(MapPath(".") + "\\" + "Test.txt");
}
else
{
File.Create(Server.MapPath(".") + "\\" + "Test.txt");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

CSS Compressor

CSS Compressor

    Use this utility to compress your CSS to increase

loading speed and save on bandwidth as well. You can

choose from three levels of compression, depending on

how legible you want the compressed CSS to be versus

degree of compression.The "Normal" mode should work

well in most cases, creating a good balance between

the two.

Try Google Suggest And Feel The Difference

Palindrome

private void btCheck_Click(object sender, System.EventArgs e)
{
char[] Temp = TextBox1.Text.ToCharArray();
Array.Reverse(Temp);
string str = new String(Temp);
if(str == TextBox1.Text)
{
Response.Write(@"<script>alert('Palindrome')</script>");
}
else
{
Response.Write(@"<script>alert('!Palindrome')</script>");
}
}

Silverlight

 Microsoft Silverlight is a cross-browser, cross-platform plug-in for delivering the next generation of .NET-based media experiences and rich interactive applications for the Web. Silverlight offers a flexible and consistent programming model that supports AJAX, Python, Ruby, and .NET languages such as Visual Basic and C#, and integrates with existing Web applications. Silverlight media capabilities include fast, cost-effective delivery of high-quality audio and video to all major browsers including Firefox, Safari, and Internet Explorer running on Mac or Windows. By using Expression Studio and Visual Studio, designers and developers can collaborate more effectively using the skills they have today to light up the Web of tomorrow.
For More Info

Microsoft® Silverlight™ 1.0 Beta Software Development Kit (SDK)  

Microsoft® Silverlight™ 1.1 Alpha Software Development Kit (SDK) 
 

Microsoft® Silverlight™ 1.1 Alpha Developer Reference Poster