Respected All ,
Am Using vb.net 2008 and Database is MS Access 2007 .I Created one record in access . Record name is " Country.accdb ( access database ) " and i made 3 Tables there .
1 India
2 Australia
3 USA
All tables Fields Are same .
Person Name , Age , Occupation .
I Connected This access database To Vb.net Through Database Wizard . Now i got ' Countrydataset.xsd '.Afterthat I Dragged INDIA Datagridview on form And Dragged Details Also . Afterthat I made 3 Buttons . . Button Names ,
1 India
2 Australia
3 USA
If I Click INDIA need to show field Details in Same Datagridview
If I Click AUSTRALIA need to show Field Details in Same Datagridview
If I Click USA need to show Fieldd etails in Same Datagridview
Please be note that i have only One datagridview .
How to Display All table fields Details in Single datagridview . Actually all fields are same . Thatsy am looking likethis . Now am stuckuped.My code is given below . If anyone knows about this question please answer me It will great help for me . Thanking you ......
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.IndiaTableAdapter.Fill(Me.CountryDataSet.India)
End Sub
Private Sub IndiaBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles IndiaBindingNavigatorSaveItem.Click
Me.Validate()
Me.IndiaBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CountryDataSet)
End Sub
End Class