I have created a VB.NET program that creates arrays of data. Every array is a column array with about 500 rows. I would like to put these arrays into a PG table. I was trying to use a for/next loop but cannot get it to work. Can somebody help me with this. Thank you very much.
My for next loop was something like this:
for i = 0 to ubound(array)
command.CommandText = "INSERT INTO TestData(prod_id) VALUES(array(i))"
command.Connection = conn
command.ExecuteNonQuery()
Next
My for next loop was something like this:
for i = 0 to ubound(array)
command.CommandText = "INSERT INTO TestData(prod_id) VALUES(array(i))"
command.Connection = conn
command.ExecuteNonQuery()
Next