How to use inner join query in asp.net using C#

Question

how to use inner join query in asp.net using c# with example coding and design

Senthilkumar · Answer

Hi Selvi I think you want to know about the sql server inner join query. The same can be written in stored procedure or inline query in your application. Lets see what is inner join InnerJoin is used to join one or more tables in the sql server. It will returns the matching records in the both table based on the condition. Assume that there are two tables: Products and Sales Products: ProductID | Name | Manfacturer | Rate | Date ------------------------------------------------------- 1 Scooty TVS 35000 10/10/2012 2 Splendor Hero Honda 50000 5/6/2012 Sales: SaleID | CustomerID | ProductID | Qty | SoldDate ------------------------------------------------------ 1 1 2 1 12/12/2012 Here i want to join these two tables. It will return the matching records in both tables. SELECT S.SaleID P.ProductID P.ProductName P.Manfacturer S.CustomerID S.SoldDate S.QtyP.Rate (s.Qty * P.Rate) AS [Total] FROM Products P INNER JOIN Sales S ON s.ProductID = P.ProductID The above query returns the result set as SaleID | ProductID | ProductName | Manfacturer | CustomerID | SoldDate | Qty | Rate | Total --------------------------------------------------------------------------------------------------------- 1 2 Splendor Hero Honda 1 12/12/2010 1 50000 50000.00 Still you can join the customer table for display the custom details with S.CustomerID = Customer.CustomerID. Hope this will help you.

selvi subramanian · Answer

thanks

MuthuMari M · Answer

Hi Inner joins return all rows from multiple tables where the join condition is met. For example create suppliers and orders table SELECT suppliers.supplier_id suppliers.supplier_name orders.order_date FROM suppliers orders WHERE suppliers.supplier_id = orders.supplier_id; This SQL statement would return all rows from the suppliers and orders tables where there is a matching supplier_id value in both the suppliers and orders tables. iew in c# for ex add one grid and bind this values in gridview using template to bind the values in easy manner.steps are 1.choose datasource 2.select new data source  add connection string 3.specify custom sql statements or store procedure then type your join query ( choose querybuilder to chk ur joins are correct) then test query  finish. press F5 ur details are loaded in gridview. thanks Please mark as Accepted answer if your query resolved.

Datta Kharad · Answer

Hi Refer this article... http://www.c-sharpcorner.com/uploadfile/raj1979/joins-in-sql-server-2005/