protected void btnGetDs_Click(object sender, EventArgs e) { DataSet ds = MaintenanceBiz.ExecuteReturnDs(txtSql.Text); gvResult.DataSource = ds; gvResult.DataBind(); }
protected void btnExecute_Click(object sender, EventArgs e) { Boolean bResult = MaintenanceBiz.ExecuteCommand(txtSql.Text); lbResult.Text = bResult ? "Success" : "Fail"; Console.WriteLine(); }
protected void ExportToExcel(object sender, EventArgs e) { String filePath = MaintenanceBiz.GenScript(); string yyyy = DateTime.Now.ToString("yyyy"); string MM = DateTime.Now.ToString("MM"); string dd = DateTime.Now.ToString("dd"); String downloadUrl = Configurations.HOST + "" + String.Format(ALS.ALSI.Biz.Constant.Configurations.PATH_URL, yyyy, MM, dd, "Script", Path.GetFileName(filePath)); LinkButton1.PostBackUrl = downloadUrl; Console.WriteLine(); //Response.Clear(); //Response.Buffer = true; //Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls"); //Response.Charset = ""; //Response.ContentType = "application/vnd.ms-excel"; //using (StringWriter sw = new StringWriter()) //{ // HtmlTextWriter hw = new HtmlTextWriter(sw); // //To Export all pages // gvResult.AllowPaging = false; // gvResult.HeaderRow.BackColor = Color.White; // foreach (TableCell cell in gvResult.HeaderRow.Cells) // { // cell.BackColor = gvResult.HeaderStyle.BackColor; // } // foreach (GridViewRow row in gvResult.Rows) // { // row.BackColor = Color.White; // foreach (TableCell cell in row.Cells) // { // if (row.RowIndex % 2 == 0) // { // cell.BackColor = gvResult.AlternatingRowStyle.BackColor; // } // else // { // cell.BackColor = gvResult.RowStyle.BackColor; // } // cell.CssClass = "textmode"; // } // } // gvResult.RenderControl(hw); // //style to format numbers to string // string style = @"<style> .textmode { } </style>"; // Response.Write(style); // Response.Output.Write(sw.ToString()); // Response.Flush(); // Response.End(); //} }