i want to break the columns up into array, loop through the text file lines, and insert into the Access database using SQL command. I have also the datagridview, which i populate my datas and my access database having the datas too.

Thanks in advance!

This post has been edited by Atli: 24 June 2013 - 02:22 AM
Reason for edit:: Use [code] tags when posting code.

Re: how to write text file column into array

Posted 24 June 2013 - 05:44 PM

sela007, on 24 June 2013 - 08:51 AM, said:

at first glance, your code looks fine. Do you have any bugs?

Hi thanks for you reply. yea, i do have errors.
for my arrdata(0), (1), (2),(3), (4)has an error saying variable used before it has been assigned a value.
and for the INSERT command, i want the data to go into my database instead of "School" .
Please help thanks, kinda urgent for this.

Re: how to write text file column into array

Posted 24 June 2013 - 06:20 PM

sela007, on 24 June 2013 - 08:51 AM, said:

at first glance, your code looks fine. Do you have any bugs?

i have change my code a little, could you help me check if theres any other errors apart from the error im getting which is "index outside bounds of array", how do i solve that? with the codes i've done, am i doing the right coding to achieve what i want?

Thanks!!

fanglign, on 24 June 2013 - 06:18 PM, said:

sela007, on 24 June 2013 - 08:51 AM, said:

at first glance, your code looks fine. Do you have any bugs?

i have change my code a little, could you help me check if theres any other errors apart from the error im getting which is "index outside bounds of array", how do i solve that? with the codes i've done, am i doing the right coding to achieve what i want?