How do i save from datagridview to sql server using loop? (vb.net, visual studio 2015)

See more:

VB

Visual-Studio

I cant seem to save multiple data from my datagridview to SQL Server.
When i loop using messagebox, the loop from line 1 to 10 works. But when using the same code to insert data, it can only save 1 line then the code exits.

Any sensei willing to help?
:(

What I have tried:

Dim c As Integer = 0
Dim dgv As Integer = DataGridView1.Rows.Count - 1
While c < dgv
ExecuteSQLQuery("INSERT INTO G_Masterlist (serial_no) VALUES (" + DataGridView1.Item(3, c).Value.ToString + ");")
'MsgBox(DataGridView1.Item(3, c).Value.ToString)
c += 1
End While



"also tried this"



For Each band As DataGridViewBand In DataGridView1.Rows
Dim strItemID As String = CStr(DataGridView1.Rows(band.Index).Cells(3).Value)
'MsgBox(strItemID)
sqlSTR = "INSERT INTO G_Masterlist (serial_no) VALUES ('" + strItemID + "')"
ExecuteSQLQuery(sqlSTR)
Next