Populating Excel to DataSet

[sujith_s]

New Message on dotNET User Group Hyd Populating Excel to DataSet Reply   Reply to Sender   Recommend Message 1 in Discussion From: sujith_s Hi,   Thanks for reading my message. I have a funny problem while populating Excel data to a Data Set. I do not face any issues while populating to a data set. The problem is some data fail to populate to the data set and returns empty string.   Example: Lets say Cell A1 contains value "A12345" and cell A2 contains "12345", what happens is cell A1 returns empty Null. sometimes vice versa. Sometimes by changing the cell format helps. If all the column as combination of Alpha numeric, every thing goes fine. Guess what! My customer uploads the excel file and when I do the necessary validations and return Error "No Data Available......." and they see the data on the excel file................ Naturally they go crazy. So do I.   Sorry about my language, I have this bad habbit of writing and reading less :)). I would be grateful if anyone could help me.     Thank you in advance. Have great day.   Cheers Sujith View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.