how to populate data into a datagridview from a mysql database

Question

Hi,

I have a winform which contains a datagridview in which there are three fileds name,password,and city. I have the same fields in a mysql db table called 'userprofile'. The Mysql database infrmation is as follows.

database name: office

data source name: exess

Now how to populate the data in the mysql db table 'userprofile' into the respective fields of datagridview . plwase help!!?