System.ArgumentException: Column 'X' Does Not Belong to Table — DataRow Fix in C#

In ASP.NET and other ADO.NET code you'll often see this in a stack trace: System.ArgumentException: Column 'AboutMotherFather' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at MyPage.Page_Load(...). The page code asked a DataRow for a column, and the table behind it doesn't have one by that name. The fix is almost always in the SQL or the name, not in the C# loop.

What the Exception Means

DataRow lets you read a value by column name: row["Email"]. Internally it looks the name up in the row's DataTable.Columns. If no column matches, it throws System.ArgumentException with the message Column 'Email' does not belong to table followed by the table's name. That's what DataRow.GetDataColumn in the stack trace is doing.

The key point: a DataTable filled from a query contains only the columns that query returned, named exactly as the query named them (including aliases).

using System;
using System.Data;

var table = new DataTable("Students");
table.Columns.Add("Name");
table.Columns.Add("Phone");
table.Rows.Add("Asha", "555-0101");

DataRow row = table.Rows[0];
Console.WriteLine(row["Name"]);   // works
Console.WriteLine(row["Email"]);  // throws: no such column

See What Columns You Really Have

Stop guessing and print the column names at the point of failure. This usually solves it in one run: you'll see the alias, the typo or the missing column immediately.

foreach (DataColumn col in table.Columns)
{
    Console.WriteLine($"{col.Ordinal}: {col.ColumnName} ({col.DataType.Name})");
}

The Usual Causes and Fixes

1. The query doesn't select it: add it to the SELECT list or stored procedure.
2. It's aliased: SELECT about_parent AS AboutParent means the C# name is AboutParent.
3. A typo or different spelling: column-name lookup ignores upper/lower case, so casing is rarely the issue, but underscores, spaces and spelling must match exactly.
4. Wrong table: reading DataSet.Tables[0] when the data is in Tables[1], or reusing a variable filled by a different query.

-- Before: the page reads row["AboutMotherFather"] but the query doesn't return it
SELECT StudentId, Name, Phone
FROM   Students;

-- After: select it, with the exact name the code uses
SELECT StudentId, Name, Phone, AboutMotherFather
FROM   Students;

Reading Optional Columns Safely

If a column is genuinely optional (different queries return different shapes), check before reading instead of letting the exception decide.

string GetText(DataRow row, string column)
{
    if (!row.Table.Columns.Contains(column) || row.IsNull(column))
        return "";
    return row[column].ToString();
}

var about = GetText(row, "AboutMotherFather");