Click here to Skip to main content
13,349,350 members (57,078 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Respected All ,

Am Using 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 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

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
        'TODO: This line of code loads data into the 'CountryDataSet.India' table. You can move, or remove it, as needed.

    End Sub

    Private Sub IndiaBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles IndiaBindingNavigatorSaveItem.Click

    End Sub
End Class
Posted 9-Jul-13 0:09am
James Abuda 9-Jul-13 5:33am
I think you must post your code here so that we can debug then answer your question more easy. :-)

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

It really sounds like all you need is something like this:
Private Sub ButtonClick(sender As System.Object, e As System.EventArgs) Handles Button1.Click, Button2.Click, Button3.Click
    DataGridView1.AutoGenerateColumns = True
    DataGridView1.DataSource = CountryDataSet
    DataGridView1.DataMember = DirectCast(sender, Button).Text
End Sub

This assumes the dataset is completely loaded before any buttons are clicked, and that you only want to see one table at a time. If you want to see multiple tables at once, you'll have to merge their data into one or manually load the grid with the data.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.180111.1 | Last Updated 9 Jul 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100