Append data to DataGridView instead of overwriting it in Vb.net
Posted on 2014-10-30
I have two datagridviews. I select multiple rows from one datagridview and move it to another Datagridview. And I have to do it multiple times. First time it works fine. But when I do it next time the previous data is overwritten. I want the Previous rows as well as the new rows in the second datagridview.
I am using the code below to bind the datagridview.
cmd = New SqlCommand(finalSql, connection)
da.SelectCommand = cmd
bsource.DataSource = dt
dgvRegister.DataSource = bsource
Thank you in advance.