Dear Sir,

Thanks for ur goods help. but now i am not clear to get the exapmle from "http://msdn.microsoft.com/en-us/libr...atamember.aspx )"

suppose
i have two table as per order no.. and both table structure are same formated.
if select orderno one by one then data filled into the datagridview control as per selection of
one by one orderno. if select 1st orderno then all datafiled into dgv and next i select 2nd orderno then all data filled in after lastrow there means all data should be displayed in dgv
so. plz give sample code or suitable idea regarding this matter

i did it like that
dgv.datasource=table (orderno -1)
dgv.datasource=table (orderno-2)

but it displayed only last table(order-2) data in datagridwview control
but i want both table 1 and 2 data to be shown in datagridview..


thank & regards