Column 'IC NUMBER' does not belong to table in winform

Asked Jun 17 '15 at 17:54

Active Jun 17 '15 at 17:54

Viewed 246 times

I'm trying to access a data column in a datatable to get its value but i keep getting the same error that the IC NUMBER column does not belong to this table! on this line

ic[j] = Form1.dt.Rows[i]["IC NUMBER"].ToString();

when i debug the application i can see the column is there :

enter image description here

and when i use this code :

ic[j] = Form1.dt.Rows[i][5].ToString();

it works fine but i need to use the columns name since there will be more or less column each and every time user import a new file. what is wrong with my code?

asked Jun 17 '15 at 17:54

CodeMonkey

2,511
4
27
38

2

There is a space at the end of `"IC NUMBER "`, in your string you are missing that space, so try `ic[j] = Form1.dt.Rows[i]["IC NUMBER "].ToString();` – Habib Jun 17 '15 at 17:56
WOOOOOOOOOOOOOOOOOOOW....i could never have seen that . thanks a lot man – CodeMonkey Jun 17 '15 at 17:58
Please mark as answered. – Charlie Jun 17 '15 at 18:50
@Habib if you don't mind, write the same thing as answer so i can mark it as answered – CodeMonkey Jun 17 '15 at 20:22
1

@Ali, this is a typo, and unlikely to help future visitors, that is why I have voted to close this question as a simple typographical mistake. – Habib Jun 18 '15 at 13:23

Column 'IC NUMBER' does not belong to table in winform

0 Answers0