I wrote a function that allows me to retrieve data from a single SQL table and place it into 3 datagridviews. The problem i am having is as follows:
* Whenever a user types something in anyone of the datagridviews that information is recorded in all three of the datagridviews.
I need some assistance on how to fix that. I have enclosed my function that is called to populate the 3 datagridviews.
Function SetupColumns(ByVal str As String) As BindingSource Data_set.Clear() Try GConn.ConnectionString = GConnstr GConn.Open() ' opens a global connection data_adapter = New SqlDataAdapter(str, GConn) data_adapter.Fill(Data_set, "Result") bnd.DataSource = Data_set bnd.DataMember = "Result" GConn.Close() Catch ex As Exception MsgBox(ex.Message) End Try Return bnd End Function