several datagrids bound to several dataviews that come from one dataset

Hello Exp.
I have a datagrid for each day of the week.  Each datagird is bound to a dataview that filters a dataset to the appropriate day of the week.

Problem-
When selecting a cell.  The contents appear in another datagird.
When selecting and deleting a row.  A Cell or sometimes the whole row from another datagrid is selected and deleted.

Observation-
It seems that since all the datagirds are bound to the same dataset through a view that the last grid that was bound has the focus for all editing.

What is the best way to go about having several datagirds hooked to the same data filtered by day?
justinwood88Asked:
Who is Participating?
 
arif_eqbalConnect With a Mentor Commented:
Well you need to have the Datagrids populated using separate DataTables
Eg.
Dim DT_Day1 As New DataTable
DT_Day1=MyDataset.Tables(0)
DT_Day1.DefaultView.RowFilter("Your Criteria")
DataGrid_Day1.DataSource=DT_Day1

So On for other DataGrids
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.