CODEWITHSUNDEEP
c#mysqldatagridview
Catalin Mihai
Catalin Mihai

Reputation: 107

Fill Datagridview with MySQL data

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:

enter image description here

Upvotes: 7

Views: 31063

Answers (2)

Taco2
Taco2

Reputation: 439

       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;
    }

Upvotes: 14

AntLaC
AntLaC

Reputation: 1225

After you set your DataSource you need to do a DataBind

dataGridView1.DataBind();

Upvotes: 0

Related Questions