Check if connected to internet

Once I stuck with a problem that "How to check if connected to internet or not using JavaScript"
There could be different reasons for this kind of need.

1. Suppose one need to call an online script from JavaScript code
2. Start downloading a file etc

if(there is NO internet connectivity){
    window.close();
}
else{
    Call a script OR download a file etc
} 

Solution is very simple. Simply Put an image tag in your HTML file and write code like this:

<img src="online-site-url/image.gif"  onError="alert('Image missing or no internet connection')"> 

I hope it will help you guys.

Delete Duplicate records

The scenario is:

The table has 3 columns, A, B, and C. Column A is unique for all rows
but the columns B and C can be duplicate across rows.
And it needs to remove the rows where B and C are duplicated.

DELETE FROM tbl_name
WHERE a NOT IN
( 
 SELECT MIN(a)
  FROM daTable
  GROUP BY b,c
) 

Return Selected checkbox values

public Hashtable returnGridSelectedIds(GridView gv1, string chkBoxField)
{
    string Id = "";
    Hashtable ht = new Hashtable();
    if (gv1.Rows.Count > 0)
    {
        foreach (GridViewRow gvr in gv1.Rows)
        {
            HtmlInputCheckBox htmChkBox = (HtmlInputCheckBox)gvr.FindControl(chkBoxField);
            if (htmChkBox.Checked)
                Id += htmChkBox.Value + ",";
        }
    }
 
    if (Id.ToString() != "")
        Id = Id.Substring(0, Id.Length - 1);
      ht["Ids"] = Id;
    return ht;
}