Fill dataGridView from DataGridView

[freddiebunt]

Hi,

I'm looking for a code, to Fill a dataGridView from DataGridView by clicking on a row.

This is what I have til now

Imports System.Data.SQLClient

Public Class hulBereken2

    Private Sub hulBereken2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        GridOphalen()
    End Sub

    Private Sub GridOphalen()

        Dim connectionString As String = My.Settings.HulpstoffenConnectionString()
        Dim SQLString As String = "Select * From Hulpstof"
        Dim mijnDataAdapter As New SqlDataAdapter(SQLString, connectionString)
        Dim mijnDataSet As New DataSet

        mijnDataAdapter.Fill(mijnDataSet)
        DataGridView1.DataSource = mijnDataSet.Tables(0)
    End Sub

    Private Sub DataGridView1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseUp
        Dim cm As CurrencyManager = CType(Me.BindingContext(DataGridView1.DataSource, DataGridView1.DataMember), CurrencyManager)
        Dim dv As DataView = CType(cm.List, DataView)
        Dim dr As DataRow

        dr = dv.Item(cm.Position).Row



      



    End Sub
End Class

thanks,

Fred from Holland