Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: 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 at 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
0 OriginalGriff 459
1 Maciej Los 325
2 Sergey Alexandrovich Kryukov 234
3 DamithSL 233
4 BillWoodruff 200
0 OriginalGriff 7,168
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,461
3 Manas Bhardwaj 4,876
4 Maciej Los 4,450


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 9 Jul 2013
Copyright © CodeProject, 1999-2014
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