Comments by Sams13 (Top 2 by date)

Sams13 8-Jul-13 4:01am View

I am asking if there are a better way to insert data from resultSet into sql table rather than using the looping

Do While rs.EOF = False
cmdCommand.CommandText = "INSERT INTO tblAccount(FULL_NAME) VALUES ( '" & rs.Fields(0).Value & "')"
cmdCommand.Execute (cmdCommand)
rs.MoveNext
Loop

Sams13 2-Jul-13 1:55am View

Thank you. It works

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid