Oh nuts!!

Thanks Mike!



>I can't view the link, either, but see the problem. In the code that populates and adds Columns, it is always Col1.Type being set.
>
>>I'm working on a project that imports an Excel file into a database. It's 99% done, and now I have run into a problem. This is a bit long, but I could use some help.
>>
>>I have a class in the project which represents column info:
>>
>>

>>public class ExcelExportColumnInfo
>>{
>>    private ColumnType _Type;
>>    private string _DBColumnName = "";
>>    private string _ExcelColumnName = "";
>>
>>    public enum ColumnType
>>    {
>>        String,
>>        Int32
>>    }
>>
>>    public ColumnType Type
>>    {
>>        get { return _Type; }
>>        set { _Type = value; }
>>    }
>>
>>    public string ExcelColumnName
>>    {
>>        get { return _ExcelColumnName; }
>>        set { _ExcelColumnName = value; }
>>    }
>>
>>    public string DBColumnName
>>    {
>>        get { return _DBColumnName; }
>>        set { _DBColumnName = value; }
>>    }
>>}
>>

>>
>>I then create instances of the column info class for each column in the Excel file that is to be imported into the database:
>>

>>// Collection to hold the column information
>>ArrayList Columns = new ArrayList();
>>
>>// One object for each column
>>ExcelExportColumnInfo Col1 = new ExcelExportColumnInfo();
>>Col1.DBColumnName = "Customer";
>>Col1.ExcelColumnName = "Conctrac # -- Customer";
>>Col1.Type = ExcelExportColumnInfo.ColumnType.String;
>>Columns.Add(Col1);
>>
>>ExcelExportColumnInfo Col2 = new ExcelExportColumnInfo();
>>Col2.DBColumnName = "Quantity";
>>Col2.ExcelColumnName = "Quantity";
>>Col1.Type = ExcelExportColumnInfo.ColumnType.Int32;
>>Columns.Add(Col2);
>>
>>ExcelExportColumnInfo Col3 = new ExcelExportColumnInfo();
>>Col3.DBColumnName = "PartNumber";
>>Col3.ExcelColumnName = "Part Number";
>>Col1.Type = ExcelExportColumnInfo.ColumnType.String;
>>Columns.Add(Col3);
>>
>>ExcelExportColumnInfo Col4 = new ExcelExportColumnInfo();
>>Col4.DBColumnName = "Location";
>>Col4.ExcelColumnName = "Ship To";
>>Col1.Type = ExcelExportColumnInfo.ColumnType.String;
>>Columns.Add(Col4);
>>
>>// Call the method to export the sheet to the database
>>Excel.ExportSheetToDB(ExpInfo, Columns);
>>

>>
>>
>>The second column's Type property should be ExcelExportColumnInfo.ColumnType.Int32.
>>
>>Please see the following pic: http://marois.freewebspace.com/pic1.JPG. Notice that somehow it is being stored in the property as a string.
>>
>>Anyone know what's wrong here?
>>
>>Thanks.