how to search from textbox and fill specific columns of datagridview from sql databas

[relief12]

i am trying to search itemcode by typing in textbox and i want to get specific coloums in same row from sql database. i have made coloumns with headers in datagridview and i want that searched data in that specific datagridview coloumns. my code is searching but adding new columns next to already made columns in datagridview. please tell me how to do this?

 

Private Sub Button13_Click(sender As Object, e As EventArgs) Handles Button13.Click

        On Error Resume Next

        Using cn As New SqlConnection("server= PANKAJ\SQLEXPRESS; database = pankaj billing software; integrated security=true")

            Using cmd2 As New SqlCommand("select itemcode As 'Item Code', item,qty As Quantity, weight as Weight from stockdata Where itemcode = @itemcode;", cn)

                cmd2.Parameters.AddWithValue("@itemcode", TextBox1.Text)

                cn.Open()

                Dim dr As SqlDataReader = cmd2.ExecuteReader()

                dt.Load(dr)

                DataGridView1.DataSource = dt



                For Each row As DataGridViewRow In DataGridView1.Rows


                    cmd2.Parameters.Add("@item", SqlDbType.VarChar)
                    cmd2.Parameters.Add("@qty", SqlDbType.VarChar)
                    cmd2.Parameters.Add("@weight", SqlDbType.VarChar)


                    With cmd2

                        row.Cells(1).Value = .Parameters("@item").Value
                        row.Cells(2).Value = .Parameters("@qty").Value
                        row.Cells(2).Value = .Parameters("@weight").Value

                    End With
                    cmd2.ExecuteNonQuery()

                Next

            End Using
        End Using

[DataMiser]

I'm not sure what that loop would actually do as coded. Granted I have not did much with binding in VB.Net nor with the data grid but it would seem to me that you would either bind the grid to your datatable or for go the data table and just loop through the reader data adding each row to the grid