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)

Rafnas T P · Answer

select Table1.ID . Billno Table2. Name  total Tax Grandtotal from Table1 join Table2 on Table1. Name =Table2.ID where Billno=0

Dharmraj Thakur · Answer

select Table1.ID Table1.billno Table2. name  Table1.total Table1.tax Table1.GrandTotal From Table1 inner join Table2 on Table1. Name = Table2.ID

Karthi Keyan · Answer

@jodha You don't have any unique id in both table. see your 1st table the billno 1 having the id 123. in table 2 you are having diff name for diff id. your table1 structure must be follow. ID billno Name total tax Grandtotal 1 1 2 500 100 600 1 1 2 200 50 250 1 0 2 700 150 850 follow this then only you can get the Name from table 2 based on Id by using JOIN operation. select T1.IDT1.billnoT2.nameT1.totalT1.taxT1.Grandtotal from Table1 T1 inner join Table2 T2 on T1.ID = T2.ID. i hope this will help you.

Rafnas T P · Answer

try changing like this select MainBillForm.ID Billno Customer_Details.CustName Date Amount Tax_Amount Total_Amount from MainBillForm left join Customer_Details on MainBillFor m. Name =Customer_Details.CustID

Jyoti Jodha · Answer

my select Query is this... select MainBillForm.ID Billno Customer_Details.CustName DateAmount Tax_Amount Total_Amount from MainBillForm left join Customer_Details on MainBillForm.CustName=Customer_Details.ID where Billno=0

Rafnas T P · Answer

try left join as below select Table1.ID . Billno Table2. Name  total Tax Grandtotal from Table1 left join Table2 on Table1. Name =Table2.ID

Jyoti Jodha · Answer

don't show records in gridview.....??

Jyoti Jodha · Answer

Show records Only 0 Rows (Billno  columns)

Rafnas T P · Answer

select Table1.ID . Billno Table2. Name  total Tax Grandtotal from Table1 join Table2 on Table1. Name =Table2.ID for this you have to join this two tables the select query is as follows above