Show MySQL database values in DataGridView C#

Question

I made a connection to my database, but when I try to view some data from 1 table, is not showing in dataGridView. When I am pressing the button, few seconds seems like is going to show the values, and after that nothing posted in dataGridView

Can anyone explain if I made sth wrong in my code? I am working in Visual Studio 2013

My code:

private void button1_Click(object sender, EventArgs e)
{
    string connectionString = "datasource=localhost;database=microweb;port=3306;username=root;password=pass";

    MySqlConnection conn = new MySqlConnection(connectionString);
    MySqlCommand cmd = new MySqlCommand("select * from reservations", conn);

    try
    {
        MySqlDataAdapter sda = new MySqlDataAdapter();
        sda.SelectCommand = cmd;
        DataTable dta = new DataTable();
        sda.Fill(dta);
        BindingSource bdsour = new BindingSource();

        bdsour.DataSource = dta;
        dataGridView1.DataSource = bdsour;
        sda.Update(dta);

    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }    
}

Is your datasource really named "localhost"? If so, how many (any?) records are contained in dta after the Fill? — B. Clay Shannon-B. Crow Raven
– B. Clay Shannon-B. Crow Raven, Commented Mar 17, 2016 at 22:45
yes, is named localhost. I made some changes in the connectionString, like another database name, pass, datasource, and is showing me some errors, like there is no database named... or password is incorrect... — Alex V
– Alex V, Commented Mar 17, 2016 at 22:51

Roman Marusyk · Accepted Answer · 2016-03-17 23:00:49Z

2

You should set AutoGenerateColumns to true

bdsour.DataSource = dta;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = bdsour;

edited Mar 17, 2016 at 23:00

answered Mar 17, 2016 at 22:56

Roman Marusyk

24.8k27 gold badges83 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Roman Marusyk Over a year ago

@AlexV Glad to have been of help

Collectives™ on Stack Overflow

Show MySQL database values in DataGridView C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related