Howdy, Stranger!

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

Categories

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.