Hi Bello,

Check this example.

SQL

SELECT Gender, 
CAST((CAST(COUNT(Gender) AS NUMERIC(18,2)) / (SELECT COUNT(*) FROM Employees)) * 100 AS NUMERIC(18,2)) '%'
FROM Employees
GROUP BY Gender

Then use the query to display the Percentage.

Refer below article to connect to MySQL database and dipslay the result in GridView.

Connect (Bind) GridView to MySql database in ASP.Net using C# and VB.Net