Seeking C# training opportunity

Question

Hi - I am a software developer in South-Africa and my wife is going to New York in March 2016 (7-13) and I am tagging along for fun. But I was thinking while I am there maybe I can improve my skills by doing free temp C# development at a company and learn from peers... or something similar - do a course that is relevant to industry in C#...

 

So I was hoping somebody may guide me in a direction on how to make contact maybe with companies in New York to help me or who is willing to let me work their or just allow me to "browse" non core projects so that I can maybe improve my skills? I know this sounds on sided, but if you can think of a way that the company can gain something from me as well then I will consider it - eg training courses then I will obviously have to pay for it...

 

Thanks in advance and thanks for a great forum. 

Answer 1

I did but it returns an error, 'Couldn't find installable ISAM'. So, I retain my connection but I append the IMEX. ;Extended Properties='text;IMEX=1; HDR=Yes;FMT=Delimited(,)' And still zeroes were vanished.

Answer 2

I believe you need to set the option in your connection string to force textual import rather than auto detecting it.

Provider=Microsoft.ACE.OLEDB.12.0;
    Data Source=c:\path\to\myfile.xlsx;
    Extended Properties=\"Excel 12.0 Xml;IMEX=1\";

The IMEX=1 extended property tells Excel to treat intermixed data as text.

Answer 3

But then, I am retrieving the ID from file using OleDB, and it turns out the the zeroes of the ID in the dataset was already ommitted.

Answer 4

Format the column in the Excel sheet where the IDs are stored as TEXT instead of numeric. If you are storing the values programmatically, put the value in a quote ''. Single quote is used as an escape character and it preserves all the values enclosed in quotes. This should solve your problem.