Merge tables in grid view

[sagar_p_parakh]

I want to merge the database table from ms access to vb.net in grid view .

I can display the single table in to the grid view. So please help me to display the multiple tables from database

Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\xyz.mdb"
        Dim myConnection As OleDbConnection = New OleDbConnection()
        myConnection.ConnectionString = connString
Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT * from info", myConnection)
        Dim ds As New DataSet
        da.Fill(ds, "info")
        DataGridView1.DataSource = ds.Tables(0)

 

[cjard]

your use of the word MERGE makes no sense to me in the context. MERGE is an Oracle operation whereby rows from one table are inserted or used to update rows in another table depending on whether the destination row exists.

Do you want to JOIN, or to UNION?

If you do not know, see wikipedia on the difference between an SQL JOIN and an SQL UNION