Hi, 
   I am trying to export my DataSet items to Excel sheet. I have bind the collection to DataGrid() and am saving it to Excel. The collection is exported to Excel, but just doesn't take all the fields. In my table & Model I have 31 fields but only 29 fields are exported. Among the 3 not exported fields 2 are of type Enum & 3rd of DateTime type. Their is other field also of DateTime type & that is exported properly. Here is the fields of my Model :
[EnumDataType(typeof(Suffix)), Display(Name = "Suffix *")] [Required(ErrorMessage = "Suffix is Required")] public Suffix NameSuffix { get; set; } [EnumDataType(typeof(InquiryStatus)), Display(Name = "Status")] [Required(ErrorMessage = "Status is Required")] public InquiryStatus Inquiry_Status { get; set; } [Display(Name = "Follow Up Date", Promp ...

Go to the complete details ...