select lasted purchase according to date time and email c#

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 OrderID,ProductID, ClientID,OrderDate 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='[email protected]'

 

This is an example query i dont no in which table you are maintaining the orderdetails along with these columns OrderID,ProductID, ClientID,OrderDate 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

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  

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  

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='[email protected]");

 

//rows contains all the records based on latest date 

 

Do let me know if it solves your problem 

try   this query

 

 select * from Products where date=(select MAX(date) from products where email='[email protected]') and email='[email protected]'

 

 if you want to search by name like devendr then put (email like 'devendr%')