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
'open connection to database
If Not sqlConn.State = ConnectionState.Open Then
'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)
'I'm not sure if I need to use a dataset and to load data