Click here to Skip to main content
12,631,374 members (31,770 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB VB.NET
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
        'TODO: This line of code loads data into the 'CountryDataSet.India' table. You can move, or remove it, as needed.
        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
Posted 9-Jul-13 0:09am
Comments
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
 
good
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.
  Permalink  

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 | Mobile
Web02 | 2.8.161205.3 | Last Updated 9 Jul 2013
Copyright © CodeProject, 1999-2016
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