Solved

Move selected Items from datagridview1 to another datagridview2

Posted on 2011-02-11
11
240 Views
Last Modified: 2012-08-13
I have datagridview1  bound to a database I want to select items from here then transfer them to Datagridview2
0
Comment
Question by:teogos
  • 9
  • 2
11 Comments
 

Author Comment

by:teogos
ID: 34870992
I am using windows forms visual basic
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34871077
0
 

Author Comment

by:teogos
ID: 34871132
I will try, but I was looking for something simpler like on the CellContentClick,  I just have three colummns to transfer
0
 

Author Comment

by:teogos
ID: 34873807
Does not work, will not tranfer
0
 

Author Comment

by:teogos
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
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:teogos
ID: 34890960
Increasing points

0
 

Author Comment

by:teogos
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.CreateCells(DataGridView2)

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

            DataGridView2.Rows.Add(dgvNewRow)
        Next


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
0
 

Author Comment

by:teogos
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
0
 

Author Comment

by:teogos
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
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 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
0
 

Author Closing Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with creating multiple xml files from one xml file using VB.NET 6 39
Format column on datatable 7 29
Help with Syntax 9 28
Help with AsEnumerable(), LINQ 4 22
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now