mysql datagridview,填充的DataGridView与MySQL数据

i tried several times to make it work but it just doesn't fill up the datagridview with mysql data ,here's my code :

string connectionString = "SERVER=localhost;DATABASE=shootsource;UID=root;PASSWORD=;";

string sql = "SELECT * FROM characters";

MySqlConnection connection = new MySqlConnection(connectionString);

connection.Open();

sCommand = new MySqlCommand(sql, connection);

sAdapter = new MySqlDataAdapter(sCommand);

sBuilder = new MySqlCommandBuilder(sAdapter);

sDs = new DataSet();

sAdapter.Fill(sDs, "characters");

sTable = sDs.Tables["characters"];

connection.Close();

dataGridView1.DataSource = sDs.Tables["characters"];

dataGridView1.ReadOnly = true;

dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

It shows only the columns from the mysql table 'characters' : id,name,time etc...how can i populate it from the db?

Here is an image of the problem:

解决方案private void MySQL_ToDatagridview()

{

//VarribleKeeper.MySQLConnectionString = your connection string

//info being your table name

MySqlConnection mysqlCon = new

MySqlConnection(VarribleKeeper.MySQLConnectionString);

mysqlCon.Open();

MySqlDataAdapter MyDA = new MySqlDataAdapter();

string sqlSelectAll = "SELECT * from info";

MyDA.SelectCommand = new MySqlCommand(sqlSelectAll, mysqlCon);

DataTable table = new DataTable();

MyDA.Fill(table);

BindingSource bSource = new BindingSource();

bSource.DataSource = table;

dataGridView1.DataSource = bSource;

}