Hi all,

I have an array of 4 elements, for each of these elements i would like to create a dataset for each. currently this is what i have. 

answer8(0) = CheckBox1.Text
answer8(1) = CheckBox2.Text
answer8(2) = CheckBox3.Text
answer8(3) = CheckBox4.Text
answer8(4) = CheckBox5.Text

For i = 0 to UBOUND(answers)

    str_counter = "SELECT [Count] FROM Answers WHERE Answers = '" & answer(i) & "'"
    da_counter = New Data.OleDb.OleDbDataAdapter(str_counter, conn)
    ds_counter = New Data.DataSet
    da_counter.Fill(ds_counter)
    tcount = ds_counter.Tables(0).Rows(0).Item(0) <----- error occurs here

the first and second element in the array works fine ...but it reaches the third one it comes out with " There no row at position 0"

any solution or suggestions for this? thanks
 

 Hi~

It seems ds_counter.Tables(0) returns no rows.

You can try something like this to determine if Tables(0) returns rows:

  if  ds_counter.Tables(0).RowCount > 0 then
     tcount = ds_counter.Tables(0).Rows(0).Item(0)
  End if

Hope it helps.