Select id from one table and its value from another table c#

Question

Select id from one table and its value from another table to search in window application c#

 

 Table1

ID	billno	Name	total	tax	Grand total
1	1	2	500	100	600
2	1	2	200	50	250
3	0	2	700	150	850

Table2

ID	name	address
1	kavi	Dehli
2	kavita	Jaipur

 

 

how to gridview show records

 ID. Billno, Name(Table2 ), total(0 ,Rows) , Tax(0,Rows) Grand total (0 ,rows)