public void showPurchases()
{
SqlConnection conn = Connection.getConnection();
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT TOP 30 pt.Name as [Part Name], P.Name as [Party Name], Pur.SellingPrice as [Cost Price], Pur.Qty as [Quanitity] FROM Purchase Pur INNER JOIN Party P ON P.Id = Pur.PartyId INNER JOIN Parts pt ON pt.PartNo = Pur.PartNo WHERE DatePurchased = convert(date,GETDATE())", conn);
DataTable dtstudent = new DataTable();
sda.Fill(dtstudent);
PurchaseDao.DataSource = dtstudent;
PurchaseDao.CancelEdit();
conn.Close();
}