Visual Basic

how to search record in gridview in vb 6.0

sql_query.CommandText = "insert into tablelabel02 with (tablockx) (nome_posto, ordemfabrico, serialnumber, referencia,dataetiqueta,qrgerado,data,operador,posx,posy,impressora,controlo)output inserted.qrgerado
    values (@posto, @ordemfabrico, next value for '" & sequenceID & "' , @refcode, replace(cast(convert(varchar,getdate(),5) as varchar(10)),'-','/'),
    @refcode+replace(cast(convert(varchar,getdate(),5)as varchar(10)),'-','')+right('000'+cast((next value for '" & sequenceID & "' )as varchar (4)),4), getdate(), @operador,@labelx,@labely, @impressora, 'xx' );"

next value for seq_a 

next value for '" & sequenceID & "'

Private Sub btnCount_Click(sender As Object, e As EventArgs) Handles btnCount.Click
        Dim arrsize = rtbDHCP_lease.Lines.Length - 1
        Dim MyNum(arrsize)

        For I = 1 To arrsize
            MyNum(I) = rtbDHCP_lease.Lines(I).Substring(41, (rtbDHCP_lease.Lines(I).IndexOf(".", 41) - 41))
            ProgressBar1.Value = (I / arrsize) * 100
        Next

        Dim query = From item In MyNum
                    Order By item
                    Group By vlans = item
                        Into vlans_count = Group, Count()

        For Each result In query
            dgvDHCPcount.Rows.Add(New Integer() {result.vlans, result.Count})
        Next
End Sub