"I have customer tables in two different applications that i want to be able to pull up in a datagridview"
Do these tables come from the *same* database? If they are, you can use sql joins and have the resultset stored in a dataset or a collection. Then take only the fields that you want to be displayed in your datagridview. Benj On Jun 19, 4:13 am, Snoopy33 <[email protected]> wrote: > I have a problem that i have no idea how to approach. I have customer > tables in two different applications that i want to be able to pull up > in a datagridview in the application that i'm developing. > > the fields in table1 are > > CCode, Cname, Caddress, CPhone > > and fields in table 2 are > CCode, Cname, Caddress, CPhone > > (for our purposes, the same) > > I want a single datagridview with just the 4 fields from each table > combined. In other words, i don't want a total of 8 fields in the > datagridview. > > Is there any way to accomplish this? > > I'm pulling the data from an SQL Database using VB.Net to develop in. > > Thanks for any help. > > Ben
