Hi.. See now you want the data from three tables so you have to just edit the query according to that take a joins of three tables select theapopriate fields you want from these three assign the result to a dataset and just assign that dataset to your Gridview
You have to just edit your query.. On Aug 10, 10:26 pm, digger_54 <[email protected]> wrote: > Hi all, > > can anyone help me, I need to pull data from 2 tables into the same > datagridview. > > All the columns will be comming from 1 table, except 1 column that > will be comming from another table > > The columns I have are: > > Car_Number > Active > In_Service_Date > Out_Service_Date > Pool_Seq_Num (this is in both tables, and instead of displaying this > column, I want to display the 'FLEETNAME' from the other column where > Pool_Seq_Num = Pool_Seq_Num. > > When I created my datagridview, I didn't expect this and now it is a > last minute change. > > thanks
