INSERTING TWO TABLES IN ONE GRIDVIEW

[shyne7]

How to insert two tables in one gridview?and how to connect it and to navigate...tnx;) sunshine

[Frank Kerrigan]

You could use a stored procedure with a temp table and use that create proc myproc AS SELECT * INTO #TEMP FROM Table1 SELECT * INTO #TEMP From * Table2 select * from #temp go or use a Union SELECT SELECT * FROM TABLE1 UNION ALL SELECT * FROM TABLE2 You get the idea, use SQL to do it.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]

[shyne7]

Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source = C:\Users\--Sunshine--\Documents\thesis\Database1.mdb") con.Open() Dim da As New OleDbDataAdapter(sql, con) sql = "Select * from Supplier_Information union all Select * from Products" da.Fill(ds, "Supplier_Information and Products") dgvSupplier.DataSource = ds.Tables("Supplier_Information and Products").DefaultView is this right?how will i assigned in my textboxes the table name? txtsuppID.Text = ds.Tables("which tablename??").Rows(inc).Item(0) tnx