Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Put VB.NET array values into PG table

Status
Not open for further replies.

gjc123

Programmer
Aug 16, 2005
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top