Hello ,
(Assuming that you are fetching records by Store Procedure or Sql Command and then showing records in DataGridView).
Before display the records in DataGridView , first join two tables named as 'table_FruitPrice' and 'table_FruitName' by FruitId and then show the record in DataGridView.
Sql Query will be
Select a.FruitId, a.FruitPrice , b.FruitName from table_FruitPrice a inner join table_FruitName b on a.FruitId=b.FruitId
Thanks