Column 'column' does not belong to table Table

G

Guest

I get this strange error:

Column 'PNR ' does not belong to table Table

It is strange because the columnname in the dataset is PNR.

String SQL = "SELECT PERSONNR AS PNR, ... FROM theTABLE";
OleDataAdapter.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
String t1 = dr[0].ToString(); //gives correct value
String t2 = ds.Tables[0].Columns[0].ColumnName; // gives "PNR"
String t3 = dr["PNR"].ToString(); //Gives error, why?
}

I've tried to rename the column and even selected without alias. Same error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DBConcurrencyException 1
Error Message :-Update requires a valid InsertCommand when passed DataRow collection with new rows. 0
Prepared statement '(@ID int...,' expects parameter @ID, which was not supplied 2
Column 'Column' does not belong to table 'Table' 3
SqlDataAdapter Update table with AutoIncrement column 8
system.argumentException; Column 'id ' does not belong to table T 0
deleting rows with SQLCommandBuilder 2
does dataadater updates 2 tables. 3

Top