c# using mysql plus return data

Question

Hi I have a problem in retrieving data from mysql and return data.

This the scenario for details.

I have a class called database then under that class i have function class public string listh() so that i can return a data to anywhere that will instantiate and call this method. I want to make this function dynamic. That's why i separate this. the query is good no errror but the problem is how to return and foreach data so that i can put it into datagridview . My code is this. 

 

public class database { 

public string list() {

confirm = db_conn.Cs;

try

{

conn = new MySqlConnection(confirm);

conn.Open();

string query = "SELECT * FROM palma_user";

command = new MySqlCommand(query, conn);

dr = command.ExecuteReader();

return dr.ToString();

 

}

catch (MySqlException ex)

{

return ex.ToString();

}

finally {

if(conn != null){

conn.Close();

}

}

}

} 

so if is instantiated something like this.

 

Database db = new Database();

db.list();

 

with that, i want to loop something like this.

 

while (dr.Read())

{

   dr.GetString(1));

}

 

that code is good only if the the query is not separated from the Form or let us direct loop and put into grid.

In my case i separate the code from the class and return the value.

Please help me. Thanks.

 

Regards,

Vergel