Data in DataGrid into Word and Excel

xiaoxiao2021-03-06 40

using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls Using system.web.ui.htmlcontrols; using system.id; using system.data.sqlclient; using system.text;

namespace DataGrid_import_WordExcel {///

/// red Maia production 2004-12-12 /// public class WebForm1: System.Web.UI.Page {protected System.Web.UI.WebControls.Button BtnImportWord; protected System.Web.UI.WebControls.Button Btn_Import_Excel; protected System.Web.UI.WebControls.DataGrid DataGrid1; private void Page_Load (object sender, System.EventArgs e) {// user code to initialize the page is placed here CreateDataSet ( }

#Region Web Form Designer Generated Code Override Protected Void OnNit (Eventargs E) {// // Codegen: This call is required for the ASP.NET Web Form Designer. // InitializeComponent (); base.onit (e);} ///

/// Designer Supports the required method - Do not use the code editor to modify the // / this method. /// private void InitializeComponent () {this.BtnImportWord.Click = new System.EventHandler (this.BtnImportWord_Click); this.Btn_Import_Excel.Click = new System.EventHandler (this.Btn_Import_Excel_Click); this.Load = new system.eventhandler (this.page_load);

} #Endregion

Private Void ExportDataGrid (String FileType, String FileName) // Export from DataGrid {response.charset = "GB2312"; response.contentencoding = system.text.Encoding.Getencoding ("GB2312");

Response.AppendHeader ( "Content-Disposition", "attachment; filename =" HttpUtility.UrlEncode (FileName, Encoding.UTF8) .ToString ()); Response.ContentType = FileType; this.EnableViewState = false; StringWriter tw = new StringWriter (); HtmlTextWriter hw = new HtmlTextWriter (tw); DataGrid1.RenderControl (hw); Response.Write (tw.ToString ()); Response.End ();} private void Btn_Import_Excel_Click (object sender, System.EventArgs e) { EXPORTDATAGRID ("Application / MS-Excel", "Index List"); // Guide to Excel} Private Void CreateDataSet () // Established DataSet {Dataset MyDataSet = New Dataset ("ANEWDATASET"); DataTable Table1 = MakeTable "ID", "name"); mydataset.tables.add (table1); dataGrid1.datasource = mydataset; DataGrid1.dataBind ();

private DataTable MakeTable (String c1Name, String c2Name) // build table {int i; DataTable myTable = new DataTable (); DataColumn myColumn; // Add two DataColumns myColumn = new DataColumn (c1Name, typeof (Int32)); // increase Field and Setting Type MyTable.Columns.Add (MyColumn); MyColumn = New Datacolumn (C2Name, TypeOf (String)); MyTable.Columns.Add (MyColumn); DATAROW DR; For (i = 1; i <11; i ) {DR = MyTable.NewRow (); DR [0] = i; DR [1] = "name" i.tot;} return myTable; }

Private void btnimportword_click (object sender, system.eventargs e) // Guide Word {ExportDataGrid ("Application / MS-Word", "Inditament List.doc");}}}

转载请注明原文地址:https://www.9cbs.com/read-60131.html

9cbs

New Post(0)