How to get a row by column name

Question

I am trying to get a column value by name instead of by ordinal. Here is the code I already have:

SELECT trim([Workitem Id]) as [Workitem Id1] from 1.csv

above is the query

rrm.id = oDR["Workitem Id"] == DBNull.Value ? string.Empty : oDR["Workitem Id"];

When I run this query I get too few parameters expected error.

score 1 · Accepted Answer · answered Jul 19 '12 at 17:48

1

Your column name is actually Workitem Id1 is it not?

answered Jul 19 '12 at 17:48

Mike Park

The column name is: Workitem Id – Luke101 Jul 19 '12 at 17:54
@Luke101 But you aliased it as `Workitem Id1`, so you can't access it by the original column name. – Mike Park Jul 19 '12 at 17:55
Wow..I didnt see that. I fixed but it is still returning the same error. – Luke101 Jul 19 '12 at 17:59
Can you loop through the column names in your data reader to make sure you have the column names correct? – Mike Park Jul 19 '12 at 18:06
OMG..I can't believe it. I just had the query pointing to the wrong file. thanks for your time for giving me a hint at the problem. – Luke101 Jul 19 '12 at 18:07

1 Answers1