Disable and Enable all the constraints in a SQL database

 Disable all the constraint in database

 EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"  

Enable all the constraint in database

 EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"  

How to set a default button for div

Using this code

 onkeypress="return WebForm_FireDefaultButton(event, '<%=ButtonName.ClientID %>')"  

Example

 <div style="float: left" onkeypress="return WebForm_FireDefaultButton(event, '<%=btnCheckPin.ClientID %>')">  
       <asp:TextBox ID="txtPincode" runat="server" Style="padding: 5px;"></asp:TextBox>  
       <input type="button" class="common_button" onclick="checkDelivery();" value="Check" ID="btnCheckPin" runat="server" />  
  </div>  

Add a column, with a default value, to an existing table in SQL Server

Syntax

 ALTER TABLE {TABLENAME}   
 ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}   
 CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}  
 [WITH VALUES]  

Example

 ALTER TABLE table  
 ADD column BIT   
 CONSTRAINT Constraint_name DEFAULT 0 WITH VALUES  

Note : WITH VALUES handles the NOT NULL part...

Convert 12 Hour format to 24 Hour Format asp.net C#

12 to 24

   private string ConvertTo24HourFormat(string strTime)  //HH:MM AM/PM
   {  
     string FinalTime=string.Empty;  
     if (!string.IsNullOrEmpty(strTime))  
     {  
       try  
       {  
         string[] InTime = strTime.Split(':');  
         int h = Convert.ToInt32(InTime[0].ToString());  
         string[] AMPM = InTime[1].Split(' ');  
         if (AMPM[1].ToString() == "PM")  
         {  
           h += 12;  
         }  
         if (AMPM[1].ToString() == "AM" && h.ToString()=="12")  
         {  
           h = 00;  
         }  
         FinalTime = h + ":" + InTime[1];  
         //if(h>  
       }  
       catch (Exception) { }  
     }  
     return FinalTime;  
   }  

24 to 12

  private string ConvertTo12HourFormat(string strTime)  //HH:MM AM/PM
   {  
     string FinalTime = string.Empty;  
     if (!string.IsNullOrEmpty(strTime))  
     {  
       try  
       {  
         string[] InTime = strTime.Split(':');  
         int h = Convert.ToInt32(InTime[0].ToString());  
         string[] AMPM = InTime[1].Split(' ');  
         if (AMPM[1].ToString() == "PM")  
         {  
           h -= 12;  
         }  
         if (AMPM[1].ToString() == "AM" && h.ToString() == "00")  
         {  
           h = 12;  
         }  
         FinalTime = h + ":" + InTime[1];  
         //if(h>  
       }  
       catch (Exception) { }  
     }  
     return FinalTime;  
   }