Export Data into Excel ?

Question

hello guys how r u ??

my question is that, i am getting data from database into dataset, and now i want to write my dataset into excel file , while i was trying to export gridview into excel but the problem was that i have one column of CODE into my database table with values  like 001, 002, 003  and so on but in excel file CODE column is showing 1, 2, 3  not with zero while i want CODE value  with zeros  ... i hope you got my point what i m trying to do..


replyy soon


Thanks