protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.GetData();
}
}
private void GetData()
{
string connnection = Convert.ToString(ConfigurationManager.ConnectionStrings["Connection"]);
SqlConnection con = new SqlConnection(connnection);
SqlCommand cmd = new SqlCommand("Select * from Users", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
gvUserInfo.DataSource = dt;
gvUserInfo.DataBind();
con.Close();
}
protected void Submit(object sender, EventArgs e)
{
this.Excel();
}
private void Excel()
{
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
using (StringWriter strwritter = new StringWriter())
{
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=AspSolution.xls");
gvUserInfo.GridLines = GridLines.Both;
gvUserInfo.HeaderStyle.Font.Bold = true;
gvUserInfo.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}
}
public override void VerifyRenderingInServerForm(Control control)
{
}