A column named [column name] already belongs to this DataTable

Question

private void BindFields()
{
    DataTable table = Globals.ConvertDataReaderToDataTable(DataProvider.GetFields());
    _fieldCount = table.Rows.Count;

    dataGrid.DataSource = table;
    dataGrid.DataBind();
}

The ConvertDataReaderToDataTable, provided by the DotNetNuke platform, throws this exception :

A column named [column name] already belongs to this DataTable

I do have columns with the same names in different tables, but they are primary/foreign key pairs and thus have the same values. What would you do to solve this problem?

Solution 1

I simply used

DataTable dataTable = new DataTable();
dataTable.Load(dataReader);

instead of DotNetNuke's

DataTable dataTable = Globals.ConvertDataReaderToDataTable(dataReader);

and I don't get the exception anymore.

Solution 2

This happens when you have the same column selected in your SQL JOIN Statements. I fixed this problem by removing the the duplicate column from my sql join like this
Change This

    SELECT O.Section,S.CurriculumTblCode, 
    S.Section ,S.SectionSettingTblCode FROM 
    otf.ViewOneToFiveGroups O 
    INNER JOIN 
    SectionSetting S ON O.SectionSettingTblCode= S.SectionSettingTblCode`

S.Section

     SELECT O.Section,S.CurriculumTblCode,S.SectionSettingTblCode 
     FROM 
     otf.ViewOneToFiveGroups O 
     INNER JOIN SectionSetting S ON O.SectionSettingTblCode= 
     S.SectionSettingTblCode

Comments

[Joel Coehoorn]

I wonder why they don't just use myDataTableInstance.Load(myDataReaderInstance)

[Admin]

Seems to have solved my problem. Thanks.

[Arulmouzhi]

it's helpful for me when i use flat file import through SSMS.