I experienced a bug, "Control GridView1 of type GridView myst be placed
inside a form tag with runat=server". But I did so. I do not why, please
advise. my code as below. Thanks.
Peter
<%@ Page language="C#" %>
<script runat="server">
protected void Page_Load(objec t sender, EventArgs e)
{
// Response.Write( "");
TheLabel.Text = " ";
}
void doExport(object sender, EventArgs e) {
string connectionStrin g
= "server=myServe r;database=myDa tabase;uid=John Doe;pwd=xyz";
System.Data.Sql Client.SqlConne ction con
= new System.Data.Sql Client.SqlConne ction(connectio nString);
using (con)
{
con.Open();
TheLabel.Text = "<b>table tblGeoMA</b> ";
string sql = "select * from tblGeoMA";
System.Data.Sql Client.SqlDataA dapter da
= new System.Data.Sql Client.SqlDataA dapter(sql, con);
System.Data.Dat aSet ds = new System.Data.Dat aSet();
da.Fill(ds,"dsT able1");
GridView1.DataS ource = ds;
GridView1.DataM ember = "dsTable1";
TheLabel.Text = " export the data in GridView to excel ";
Response.Clear( );
Response.AddHea der("content-disposition",
"attachment;fil ename=peter1.xl s");
Response.Charse t = "";
Response.Cache. SetCacheability (HttpCacheabili ty.NoCache);
Response.Conten tType = "applicatio n/vnd.xls";
System.IO.Strin gWriter stringWrite = new System.IO.Strin gWriter();
System.Web.UI.H tmlTextWriter htmlWrite
= new System.Web.UI.H tmlTextWriter(s tringWrite);
GridView1.DataB ind();
GridView1.Rende rControl(htmlWr ite);
//Response.Write( stringWrite.ToS tring());
Response.Write( "hello");
Response.End();
}
}
</script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>GridView 2Excel - test 5</title>
</head>
<body>
<form id="form1" runat="server">
<asp:button runat="server" text="export to excel" onclick="doExpo rt"
/><br />
<asp:label runat="server" text="" id="TheLabel" />
<asp:GridView runat="server" id="GridView1" />
</form>
</body>
</html>
