how to use array as parameter in sqldatareader

Question

I want to use array in sqldatareader object.

Code

for(int j=0;j<12;j++)   //12 use for month
 {
  if(j!=(mon-1))
   {
   ***String mont = MyReader1["('"+month[j]+"')"].ToString();***
   tt += mont;
   }
 }

I got error like

'January' System.IndexOutOfRangeException: 'January'

i use month name in array

and in database month name is colunm name

i have error in MyReader1["('"+month[j]+"')"]

Please show us table structure - columnname and datatype. – KV Prajapati Jan 21 '12 at 09:18 — KV Prajapati, Jan 21 '12 at 09:18

score 0 · Accepted Answer · answered Jan 21 '12 at 09:15

0

If month is an array of string then try,

string month=MyReader1[month[j]];

answered Jan 21 '12 at 09:15

KV Prajapati

93,659
19
148
186

how to use array as parameter in sqldatareader

1 Answers1