Export datatable to excel

This section describes how to import data from a able table to an Excel worksheet. First, bind the data in the able data table to the gridview, and then add the data in the gridview to the Excel format. Instance Code String sconnectionstring; // declare a string // connect to the database string and connect to the xbmis database. The username is sasconnectionstring = "Data Source = .; initial catalog = xbmis; user id = sa; "; // create the sqlconnection database connection object sqlconnection conn = new sqlconnection (sconnectionstring); // open connconn. open (); // SQL statement to retrieve all the data in the t_yongh table string commandstring = "select bianh as number, zhucyhm as registration name, xingm as name, xingb as gender from t_yongh "; sqldataadapter dataadapter = new sqldataadapter (commandstring, Conn); ds_datatable DS = new ds_datatable (); // fill the dataset dataadapter. fill (DS, "yongh"); datatable datatable1 = Ds. tables ["yongh"]; response. clear (); response. buffer = true; // response. contenttype = "application/vnd. MS-excel "; response. contenttype = "application/vnd. MS-word "; response. contentencoding = system. text. encoding. utf8; response. charset = ""; this. enableviewstate = false; stringwriter ostringwriter = new stringwriter (); htmltextwriter ohtmltextwriter = new htmltextwriter (ostringwriter); DataGrid DG = new DataGrid (); DG. datasource = datatable1; // return datatabledg. databind (); DG. rendercontrol (ohtmltextwriter); response. write (ostringwriter. tostring (); response. end ();