I am reading an excel file using ADO.Net. In a column, my first value is nothing and the rest of the values are numbers. But when I read values, I am getting all empty strings. If I replace my first value with some random number, then I am able to read all the values.
My assumption is that IDataReader is detecting the type by its first value and applying it to rest of the values. Is there a way to tell it to assume everything to be strings? Or any other solution to this problem. (Note: I gottu use DataReader because a lot of the logic in the base classes is based on it and I cannot change it.)
[CODE]
while (dreader.Read())
{
if (ProcessRecord(dreader))
bError = true;
}
ProcessRecord(IDataReader dr)
{
string value = dr.GetValue(0).ToString();
}
[CODE]