protected void Button3_Click(object sender, EventArgs e)
    {
 
 
        DataSet dsExport = dataSet;
        DataGrid dgExport = new DataGrid();
        dgExport.DataSource = dsExport;
 
        //ExportToExcel();
 
        DataGridToExcel(dgExport, Response);
    }
 
    protected void DataGridToExcel(DataGrid dGridExport, HttpResponse httpResp)
    {
        httpResp.Clear();
        httpResp.Charset = "";
        httpResp.ContentType = "application/vnd.ms-excel";
        StringWriter stringWrite = new StringWriter();
        HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        DataGrid dGrid = new DataGrid();
        dGrid = dGridExport;
        dGrid.HeaderStyle.Font.Bold = true;
        dGrid.DataBind();
        dGrid.RenderControl(htmlWrite);
        httpResp.Write(stringWrite.ToString());
        httpResp.End();
    }

    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        exportToExcel();
    }
 
    protected void exportToExcel()
    {
        VerifyRenderingInServerForm(GridView1);
 
        /* This is a limit in Excel prior to Office 2007 */
        if (GridView1.Rows.Count > 65536)
        {
            Page.Response.Clear();
            Page.Response.Write("Too many lines to export.");
            Page.Response.End();
        }
        GridView1.AllowPaging = false;
        GridView1.AllowSorting = false;
        GridView1.DataBind();
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment; filename=FileName.xls");
        Response.Charset = "";
        // If you want the option to open the Excel file without saving than
        // comment out the line below
        // Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        GridView1.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
    }
 
    public override void VerifyRenderingInServerForm(Control control)
    {
        /* Confirms that an HtmlForm control is rendered for the specified ASP.NET
           server control at run time. */
    }

using System.IO.Compression;
using System.Text;
 
protected string Compress(string text)
{
    byte[] buffer = Encoding.UTF8.GetBytes(text);
    MemoryStream ms = new MemoryStream();
    using (GZipStream zip = new GZipStream(ms, CompressionMode.Compress, true))
    {
        zip.Write(buffer, 0, buffer.Length);
    }
 
    ms.Position = 0;
    MemoryStream outStream = new MemoryStream();
 
    byte[] compressed = new byte[ms.Length];
    ms.Read(compressed, 0, compressed.Length);
 
    byte[] gzBuffer = new byte[compressed.Length + 4];
    System.Buffer.BlockCopy(compressed, 0, gzBuffer, 4, compressed.Length);
    System.Buffer.BlockCopy(BitConverter.GetBytes(buffer.Length), 0, gzBuffer, 0, 4);
    return Convert.ToBase64String(gzBuffer);
}
 
 
protected string Decompress(string compressedText)
{
    byte[] gzBuffer = Convert.FromBase64String(compressedText);
    using (MemoryStream ms = new MemoryStream())
    {
        int msgLength = BitConverter.ToInt32(gzBuffer, 0);
        ms.Write(gzBuffer, 4, gzBuffer.Length - 4);
 
        byte[] buffer = new byte[msgLength];
 
        ms.Position = 0;
        using (GZipStream zip = new GZipStream(ms, CompressionMode.Decompress))
        {
            zip.Read(buffer, 0, buffer.Length);
        }
 
        return Encoding.UTF8.GetString(buffer);
    }
}

<?php
        //////////////////////////////////////////////////////////////////////////////////////
        ///////////////  Maxmind/Google Maps Mashup by Kevin Cornwell ///////////////
        ///////////////                       Version 1.0                             ///////////////
        ///////////////          http://www.kevincornwell.com                ///////////////
        /////////////////////////////////////////////////////////////////////////////////////
 
 
 
	// EDIT THE NEXT 2 KEYS
 
	$maxmind_license_key  = "foo";    // Replace [foo] with your key.
	$google_maps_key      = "bar";    // Replace [bar] with your key.
 
 
	$zoom                 = 4;          // Default zoom level.
	$lat                  = 39.232;     // Center on this location by default when no IP is passed.
	$long                 = -95.800;    // Center on this location by default when no IP is passed.
	$ip                   = "";
	$message              = "Hello World";   // Default message when no IP is passed.
 
 
	if (isset($_REQUEST['ip']))
	{
		$ip = $_REQUEST['ip'];
 
		$r = maxmind_lookup($ip);
 
		$message = "<table cellspacing=0><tr><td align='right'><b>IP:</b> &nbsp;</td><td><a href='http://whois.domaintools.com/{$ip}'>{$ip}</a></td></tr><tr><td align='right'><b>Country:</b> &nbsp;</td><td>{$r['country']}</td></tr><tr><td align='right'><b>Region:</b> &nbsp;</td><td>{$r['region']}</td></tr><tr><td align='right'><b>City:</b> &nbsp;</td><td>{$r['city']}</td></tr><tr><td align='right'><b>Zip:</b> &nbsp;</td><td>{$r['zip']}</td></tr><tr><td align='right'><b>Lat:</b> &nbsp;</td><td>{$r['lat']}</td></tr><tr><td align='right'><b>Long:</b> &nbsp;</td><td>{$r['long']}</td></tr><tr><td align='right'><b>Metro:</b> &nbsp;</td><td>{$r['metro_code']}</td></tr><tr><td align='right'><b>Area Code:</b> &nbsp;</td><td>{$r['area_code']}</td></tr><tr><td align='right'><b>ISP:</b> &nbsp;</td><td>{$r['isp']}</td></tr><tr><td align='right'><b>Org:</b> &nbsp;</td><td>{$r['org']}</td></tr></table>";
 
		$lat = $r['lat'];
		$long = $r['long'];
	}
 
 
	function maxmind_lookup($ipaddress){
 
		global $maxmind_license_key;
 
		// Returns:ISO 3166 Two-letter Country Code, Region Code, City, Postal Code, 
		// Latitude, Longitude, Metropolitan Code, Area Code, ISP, Organization.
 
 
		$query = "http://maxmind.com:8010/f?l=" . $maxmind_license_key . "&i=" . $ipaddress;
		$url = parse_url($query);
		$host = $url["host"];
		$path = $url["path"] . "?" . $url["query"];
		$timeout = 1;
		$fp = fsockopen ($host, 8010, $errno, $errstr, $timeout)
		or die('Can not open connection to maxmind server.');
		$buf = "";
 
 
		if ($fp) {
			fputs ($fp, "GET $path HTTP/1.0\nHost: " . $host . "\n\n");
			while (!feof($fp)) {
				$buf .= fgets($fp, 128);
			}
			$lines = split("\n", $buf);
			$data = $lines[count($lines)-1];
			fclose($fp);
 
			$arrMaxmind = split(",", $data);
			$arrMaxmind = str_replace("\"", "", $arrMaxmind);
			$arrMaxmind = str_replace(",", " ", $arrMaxmind);
 
			$r['country'] 		= $arrMaxmind[0];
			$r['region'] 		= $arrMaxmind[1];
			$r['city'] 		= $arrMaxmind[2];
			$r['zip'] 		= $arrMaxmind[3];
			$r['lat'] 		= $arrMaxmind[4];
			$r['long'] 		= $arrMaxmind[5];
			$r['metro_code'] 	= $arrMaxmind[6];
			$r['area_code'] 	= $arrMaxmind[7];
			$r['isp'] 		= $arrMaxmind[8];
			$r['org'] 		= $arrMaxmind[9];
 
		} else {
			return false;
		}
		return $r;
	}		
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title><?php echo $ip ?></title>
    <script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=<?php echo $google_maps_key ?>"
      type="text/javascript"></script>
    <script type="text/javascript">
 
    //<![CDATA[
 
	function load() 
	{
		if (GBrowserIsCompatible()) 
		{
			var map = new GMap2(document.getElementById("map"));
			map.addControl(new GLargeMapControl());
			map.addControl(new GMapTypeControl());
			map.setCenter(new GLatLng(<?php echo $lat ?>, <?php echo $long ?>), <?php echo $zoom ?>);
			var marker = new GMarker(new GLatLng(<?php echo $lat ?>, <?php echo $long ?>));
			marker.html = "<?php echo $message ?>";
			GEvent.addListener(marker, 'click', function() {marker.openInfoWindowHtml(marker.html); });
			map.addOverlay(marker);
			marker.openInfoWindowHtml(marker.html);
		}
	}
 
    //]]>
    </script>
  </head>
  <body onload="load()" onunload="GUnload()">
    <div id="map" style="width:800px;height:600px"></div>
  </body>
</html>