cast(convert(varchar(10),getdate(),1) as datetime)

string fileName = Guid.NewGuid().ToString(“N”).Substring(0, 12);

string attachment = “attachment; filename=” + fileName + “.xls”;

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader(“content-disposition”, attachment);

Response.ContentType = “application/vnd.ms-excel”;

Response.Charset = “ISO-8859-9″;

System.IO.StringWriter sw = new System.IO.StringWriter();

HtmlForm frm = new
HtmlForm();

HtmlTextWriter htw = new
HtmlTextWriter(sw);

DataList1.Parent.Controls.Add(frm);

frm.Attributes["runat"] = “server”;

frm.Controls.Add(DataList1);

frm.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();