Hi, I nead the codes that solve the parts (d and 4) by using the Visual Basic language.

d. On click button Display List of Expiring Medicines i. Write a query to display Productid, Name, Type, Strength, Price and Quantity and also compute 50% discount whose period is less than or equal to one year from today. ii. Display query result in Datagridview. 1 Mark 3 Marks iii. Write the query result in a file "NewExpiryList. Txt". 3 Mark iv. Implement exception handle for the file not found. 1 Mark 3 On click button Go to profit Visualization a. Open form ProfitVision. 0.5 Marks 4 On Click button Display Chart 5 Marks a. Consider the following data to create a column chart as shown. b. Convert each of the profit to the percentage of the target 500000 . c. On click button Close, close the form