Saturday, January 31, 2015

How to reset or clear all web form controls in asp.net

Introduction: In this article today I am going to explain how we can reset or clear all form controls in asp.net code behind.

Description:

HTML Markup:

<fieldset style="width:450px">
    <legend>Reset All controls Example</legend>
        <table>
        <tr><td></td><td></td></tr>
        <tr><td>First Name:</td><td>
            <asp:TextBox ID="frstname" runat="server"></asp:TextBox></td></tr>
            <tr><td></td><td></td></tr>
         <tr><td>Last Name:</td><td>
             <asp:TextBox ID="lastname" runat="server"></asp:TextBox></td></tr>           
                <tr><td></td><td></td></tr>
                   <tr><td>Gender:</td><td>          
                       <asp:CheckBoxList ID="CheckBoxList1" runat="server"
                           RepeatDirection="Horizontal" >
                           <asp:ListItem>Male</asp:ListItem>
                           <asp:ListItem>Female</asp:ListItem>
                       </asp:CheckBoxList>         
        </td></tr>
        <tr><td></td><td></td></tr>   
        <tr><td>Technology:</td><td>         

Wednesday, January 7, 2015

Date format in Sql Server

Introduction: In this article today I will explain Date format available in Sql server database.

                                                                         Output
SELECT CONVERT(VARCHAR,GETDATE(),100) -- Jan  7 2015 11:12AM
SELECT CONVERT(VARCHAR,GETDATE(),101) -- 01/07/2015
SELECT CONVERT(VARCHAR,GETDATE(),102) -- 2015.01.07
SELECT CONVERT(VARCHAR,GETDATE(),103) -- 07/01/2015
SELECT CONVERT(VARCHAR,GETDATE(),104) -- 07.01.2015
SELECT CONVERT(VARCHAR,GETDATE(),105) -- 07-01-2015
SELECT CONVERT(VARCHAR,GETDATE(),106) -- 07 Jan 2015
SELECT CONVERT(VARCHAR,GETDATE(),107) -- Jan 07, 2015
SELECT CONVERT(VARCHAR,GETDATE(),108) -- 11:23:08
SELECT CONVERT(VARCHAR,GETDATE(),109) -- Jan  7 2015 11:23:51:077AM
SELECT CONVERT(VARCHAR,GETDATE(),110) -- 01-07-2015
SELECT CONVERT(VARCHAR,GETDATE(),111) -- 2015/01/07
SELECT CONVERT(VARCHAR,GETDATE(),112) -- 20150107
SELECT CONVERT(VARCHAR,GETDATE(),113) -- 07 Jan 2015 11:25:17:203
SELECT CONVERT(VARCHAR,GETDATE(),114) -- 11:25:28:643
SELECT CONVERT(VARCHAR,GETDATE(),120) -- 2015-01-07 11:25:56
SELECT CONVERT(VARCHAR,GETDATE(),121) -- 2015-01-07 11:26:37.750
SELECT CONVERT(VARCHAR,GETDATE(),126) -- 2015-01-07T11:27:06.793
SELECT CONVERT(VARCHAR,GETDATE(),127) -- 2015-01-07T11:27:25.113
SELECT CONVERT(VARCHAR,GETDATE(),130) -- 17 ???? ????? 1436 11:27:50:19
SELECT CONVERT(VARCHAR,GETDATE(),131) -- 17/03/1436 11:28:15:207AM