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(); }