datagridview in tabcontrol!

[jeshra279]

hi everyone, I have a tab control with 3 tabs, A,B,C. I have one one database "student" in which i have 4 columns. There are two datagridviewB and datagridviewC in the two tabs B and C. I am updating the entries of a datagridviewB by entering details in a form present in Tab A. Now when I am working in tab C to update the datagridviewC, say for example filtering "student" database and displaying filtered results in datagridviewC; while updating datagridviewC, I noticed that datagridviewB in tab B also getting updated. My code for filter "student" database in tab C is like this: cmd = New SqlCommand("SELECT * FROM student WHERE [Name] <= '" + name + "'", con) myDA = New SqlDataAdapter(cmd) myDataSet = New DataSet() myDA.Fill(myDataSet, "student") datagridviewC.DataSource = myDataSet.Tables("student").DefaultView Can someone tell me, how to update the datagridviewC in tab C without altering the entries present in datagridviewB in tab B? FYI : my datagridviewB contains all the student data and in tab C i am filtering the database based on "Name" and displaying in datagridviewC.

[Mycroft Holmes]

If your datasource for the datagridviews is the same then naturally the data is the same. You can separate the datasources into bindingsources or copy the dataview to a new table for each datagridview. BTW this should be in the Windows Forms forum.

Never underestimate the power of human stupidity RAH