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 1,2,3. 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.ID,T1.billno,T2.name,T1.total,T1.tax,T1.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, Date,Amount, 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

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

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (9)