Information

IP Adress - Regular expression - (\[0-9]{1,3})\.(\[0-9]{1,3})\.(\[0-9]{1,3})\.(\[0-9]{1,3})

1. To add serial No in Repeater:              <%#  DataBinder.Eval(Container,"ItemIndex") %>

Set the values of Dropdown list of a date:- There are three dropdown lists for each Day, Month And Year.  we fill through javascript with following way:         var date =" 11/23/2010 "; // Format- MM/DD/YYYY         var mm = date.substring(0,2);         var dd = date.substring(3,5);         var yy = date.substring(6,10);                 document.getElementById(" ddlDay ").value=dd;         document.getElementById(" ddlMonth ").value=mm;         document.getElementById(" ddlYear ").value=yy;

Select recodrs from a datatable:- DataTable dtLog = Funtion(); DataRow[] drs = dtLog.Select(" UpdatedDate  = '" + dtDate.Rows[i]["Date"].ToString() + "'");  DataTable dts = dtLog.Clone();   dts = drs.CopyToDataTable ();

Default Button for a page:                   <form id="form1" runat="server" defaultbutton="buttonName"> < /form > Default Button for a panel:                    < asp:Panel runat = "server" DefaultButton = "lbHello" > < /asp:Panel > Default in a div:-                    < div onkeypress="javascript:return WebForm_FireDefaultButton(event, 'buttonID')" > < /div > For Linkbutton to make a default page, add below javascript at the end of the page <script type="text/javascript">     var __defaultFired = false; function WebForm_FireDefaultButton(event, target) {     var element = event.target || event.srcElement;     if (!__defaultFired && event.keyCode == 13 ...

Use Javascirpt in code behind like this  string Scriptup = "javascript: alert('Munesh Sunda');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "Scriptup", Scriptup, true); This works fine.

Query to remove duplicate records, in this query please add all the columns in GROUP BY clause that are duplicate, it is based on primary key DELETE from TableName WHERE CoumnName1 + CoumnName2 + CoumnName3 IN (select CoumnName1 + CoumnName2 + CoumnName3         FROM TableName         group by CoumnName1 , CoumnName2 ,CoumnName3         having Count(ID)>1) AND ID NOT IN (select MAX(ID) from TableName         WHERE CoumnName1 + CoumnName2 + CoumnName3         IN (select CoumnName1 + CoumnName2 + CoumnName3                 FROM TableName                 group by CoumnName1 , CoumnName2 ,CoumnName3                 having Count(ID)>1)  ...