Generate an Excel file from datareader

Public void export2excel (Object sender, eventargs E) { // Import the currently queried data to excel Sqlconnection sqlconn = new sqlconnection (configurationsettings. etettings ["connectionstring"]); // If this parameter is set to true, data is appended to the current data. Otherwise, the current data is overwritten. Streamwriter W = new streamwriter (server. mappath ("data \ empdimissionresult.xls"), false, encoding. Default ); Sqlconn. open (); Try { Sqlcommand sqlcmd = sqlconn. createcommand (); Sqlcmd. commandtext = Your SQL statement; Sqldatareader reader = sqlcmd. executereader (); For (INT I = 0; I <reader. fieldcount; ++ I) { W. Write (reader. getname (I )); W. Write ('\ t '); } W. Write ("\ r \ n "); Object [] values = new object [reader. fieldcount]; While (reader. Read ()) { Reader. getvalues (values ); For (INT I = 0; I <values. length; ++ I) { W. Write (Values [I]. tostring ()); W. Write ('\ t '); } W. Write ("\ r \ n "); } W. Flush (); W. Close (); Reader. Close (); Sqlconn. Close (); Response. Redirect ("data \ empdimissionresult.xls "); } Catch { W. Close (); Sqlconn. Close (); Return; } }