Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Move selected Items from datagridview1 to another datagridview2

Posted on 2011-02-11
Medium Priority
Last Modified: 2012-08-13
I have datagridview1  bound to a database I want to select items from here then transfer them to Datagridview2
Question by:teogos
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 2

Author Comment

ID: 34870992
I am using windows forms visual basic

Author Comment

ID: 34871132
I will try, but I was looking for something simpler like on the CellContentClick,  I just have three colummns to transfer
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 34873807
Does not work, will not tranfer

Author Comment

ID: 34887640
Can you provide me with some code samples

Datagridview1   is the bound data table and datagridview2 is the one I want to transfer the selected records

Datagridview1 has    Prod_Code ,  Boxes, Lbs   those are the ones I want to transfer to 2

Author Comment

ID: 34890960
Increasing points


Author Comment

ID: 34898143
I got to this far, the data is being transfer to datagridview2 using the code below

For Each dgvRow As DataGridViewRow In DataGridView1.SelectedRows
            Dim dgvNewRow As New DataGridViewRow

            dgvNewRow.Cells(0).Value = dgvRow.Cells("ProdCodeDataGridViewTextBoxColumn").Value
            dgvNewRow.Cells(1).Value = dgvRow.Cells("BoxesDataGridViewTextBoxColumn").Value
            dgvNewRow.Cells(2).Value = dgvRow.Cells("LbsDataGridViewTextBoxColumn").Value


but since datagridview1 is a databound to a database is getting refresh on a timer based, but  datagridview2 is not getting new data for the previous selected records,

How Can get the new values for the
            dgvNewRow.Cells(1).Value = dgvRow.Cells("BoxesDataGridViewTextBoxColumn").Value
            dgvNewRow.Cells(2).Value = dgvRow.Cells("LbsDataGridViewTextBoxColumn").Value

that are happening on Datagridview1 to datagridview2  based on the previous selected records

Author Comment

ID: 34915379
Changing the layout.
If I have a Bound datagrid. and how Can I fliter multiple items   something like a Check box to select items and by checking this box the items will be the filters

Author Comment

ID: 34915582
I have found this. to filter the  DatagridView

Dim dv As DataView = Me.BEEF.Tables("BEEFREGULAR").DefaultView
        dv.RowFilter = "Prod_Code='" & Me.ComboBox1.Text & "'"
        DataGridView1.DataSource = dv

This works, but  only one record  each time,I want to be multiple select on the combobox1 then filter the datagridview with the selections
LVL 83

Accepted Solution

CodeCruiser earned 2000 total points
ID: 35022060
You can use the checkboxes to allow user to make multiple selections. You would then need to construct a filter string using something like this

Dim filter as sting
if cb1.checked then
   filter = "column1=val1"
end if
if cb2.checked then
   filter &= "and column2=val2"
end if

filter = filter.trim.trim("a").trim("n").trim("d").trim

dv.rowfilter = filter

Author Closing Comment

ID: 35055233
Sorry, took me a while to get back, Thanks

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question