select lasted purchase according to date time and email c#

Question

hii friends how to get latest purchase itme in table according to email and date time like devendr@gmail.com 22/11/2016 product1 devendr@gmail.com 23/11/2016 product2 devendr@gmail.com 25/11/2016 product23 ram@gmail.com 25/11/2016 product2 i want select devendra purchase latest details according to date time and email id thanks in advance

Amit Gupta · Answer

Hey For any further question also brief your question like whether you want the latest record from sql through query or from the datatable. In sql Select * from tablename where purchasetime = (select max (purchasetime) from tablename where email ='××@×××.com') // you will get records based on latest date If using datatable Var dt = new DataTable (); //assuming datatable is filled var rows= dt.Select (max (purchasetime) and email='xx@xxx.com); //rows contains all the records based on latest date Do let me know if it solves your problem

Rupesh Kahane · Answer

1) Bellow query will give you all records in desc order SELECT email purchaseDate product FROM TableName group by email  purchaseDate product order by purchaseDate desc 2) Bellow query will give most top record i.e. 1st record SELECT top 1 Name email purchaseDate FROM TableName group by email  name purchaseDate  product order by purchaseDate desc

Kranthi Vardhan Kolluru · Answer

try this query select * from Products where date =( select MAX ( date ) from products where email= 'devendr@gmail.com' ) and email= 'devendr@gmail.com' if you want to search by name like devendr then put (email like 'devendr%')

Kranthi Vardhan Kolluru · Answer

in your query are you getting the data from Tbl_OrderDetails Table or Tbl_OrderMaster Table..? and where is the OrderDate\PurchaseDate that client has purchased..? Tbl_OrderDetails Table not from Tbl_Client_Adrress table. i.e. You have Order Table which maintain the OrderIDProductID ClientIDOrderDate and Email then inner join from Order Table i.e. Tbl_Order_Master inner join Tbl_Client_Address on Tbl_OrderMaster.ClientAdrsId = Tbl_Client_Address.ClientId inner join Tbl_products on Tbl_OrderMaster.ProductID=Tbl_Products.ProductID where Tbl_OrderMaster.OrderID>0 and Tbl_Order_Master.OrderDate=(select Max(Tbl_Order_Master.OrderDate) from Tbl_Order_Master) and Tbl_OrderMaster.emailID='Devendr@gmail.com' This is an example query i dont no in which table you are maintaining the orderdetails along with these columns OrderIDProductID ClientIDOrderDate and Email. From Order Details Table you can join all remaing table so you must maintain the Primary keys of remaining tables in Order table as Foriegn Key

Devendra Kumar · Answer

SELECT Tbl_OrderDetail.Qantity Tbl_Products.ProductName Tbl_Products.ProductCode Tbl_OrderDetail.individual_price Tbl_OrderDetail.individual_shipping Tbl_Client_Address.ClientEmail Tbl_Client_Address.ClientName Tbl_Client_Address.ClientMobile Tbl_Client_Address.ClientStreet Tbl_Client_Address.ClientCity Tbl_Client_Address.ClientState Tbl_Client_Address.ClientPostal Tbl_Client_Address.ClientCountry FROM Tbl_Client_Address INNER JOIN Tbl_OrderMaster ON Tbl_Client_Address.ClientId = Tbl_OrderMaster.ClientAdrsId INNER JOIN Tbl_OrderDetail ON Tbl_OrderMaster.orderId = Tbl_OrderDetail.OrderMasterfkId INNER JOIN Tbl_Products ON Tbl_OrderDetail.ProductFkId = Tbl_Products.ProductId in this query where condition email and date time