(Column)Name Surname Name1 Surname1 Name2 Surname2 Name3 Surname3
(Column)Name Surname Name1 Surname1
For i as integer = 0 To dgv2.rowcount -1 Dim query as string = "SELECT * From db_table WHERE Name LIKE '%" & dgv2.rows(i).cells(0).value &"'" Dim comm as new sqlcommand(query,conn) dim adapter as new sqladapter(comm) dim table as new datatable() adapter.fill(table) dgv1.datasource = table
Dim query as string = "SELECT * From db_table WHERE Name LIKE '%" & dgv2.rows(i).cells(0).value &"'"
Const query As String = "SELECT * FROM db_table WHERE Name LIKE @Name" Dim comm as New SqlCommand(query, conn) comm.Parameters.AddWithValue("@Name", "%" & dgv2.rows(i).cells(0).value & "%")
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)