how to update database using array

Can anyone help?
I'm trying to update a database table using an array.
Here's what I have so far....I'm kinda stuck here

Dim arrProjectID As ArrayList = New ArrayList
Try
'open connection to database
If Not sqlConn.State = ConnectionState.Open Then
sqlConn.Open()
End If

'set my sql String to pull my project ID's
strSql = "SELECT ExternalProjectID FROM Projects"

'Set sqlCommand and Execute Query to retrieve data
sqlCmd = New SqlCommand(strSql, sqlConn)
sqlCmd.ExecuteNonQuery()

'I'm not sure if I need to use a dataset and to load data
'or what?
arrProjectID.Add()
.....
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories