Fill dataGrid from MySQL database in C# WPF

Question

I want to fill a dataGrid in my WPF application.

My XAML:

<DataGrid AutoGenerateColumns="True" Height="200" HorizontalAlignment="Left" 
Margin="102,72,0,0" Name="dataGrid1" VerticalAlignment="Top" Width="848" />

My code behind:

  public void FillGrid()
    {
        string MyConString =    
        "SERVER=myserver.com;" +
        "DATABASE=mydatabase;" +
        "UID=myuserid;" +
        "PASSWORD=mypass;";

        string sql = "SELECT clientnr, name, address FROM clients ORDER BY name";

        MySqlConnection connection = new MySqlConnection(MyConString);
        MySqlCommand cmdSel = new MySqlCommand(sql, connection);
        DataTable dt = new DataTable();
        MySqlDataAdapter da = new MySqlDataAdapter(cmdSel);
        da.Fill(dt);
        dataGrid1.DataContext = dt;
    }

I'm sure that the MySQL part is correct, it does not give any errors. VS10 express doesn't give any errors. But if i execute the method my dataGrid won't be filled.

What I'm doing wrong?

Thanks in advance!

Rachel · Accepted Answer · 2011-06-06 16:36:35Z

6

Set your DataGrid's binding:

<DataGrid ItemsSource="{Binding }" />

edited Jun 6, 2011 at 16:36

answered Jun 6, 2011 at 16:29

Rachel

133k67 gold badges316 silver badges513 bronze badges

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

2 Comments

Rachel Over a year ago

@Lars See the update to set the DataGrid binding. Also, verify your FillGrid method is getting run.

Rachel Over a year ago

@HaiderKhattak I'd suggest posting a new question with the relevant code. The most likely cause is your DataContext isn't set correctly.

Jon · Accepted Answer · 2011-06-06 16:42:54Z

You definitely want it to be bound to the DataTable and not the Adapter, as Rachel suggested (the adapter's job is to populate the DataTable). Also, it's good to enclose connections and commands in usings to make sure everything is cleaned up, like this:

public void FillGrid()
{
    string MyConString =
    "SERVER=myserver.com;" +
    "DATABASE=mydatabase;" +
    "UID=myuserid;" +
    "PASSWORD=mypass;";

    string sql = "SELECT clientnr, name, address FROM clients ORDER BY name";

    using (MySqlConnection connection = new MySqlConnection(MyConString))
    {
        connection.Open();
        using (MySqlCommand cmdSel = new MySqlCommand(sql, connection))
        {
            DataTable dt = new DataTable();
            MySqlDataAdapter da = new MySqlDataAdapter(cmdSel);
            da.Fill(dt);
            dataGrid1.DataContext = dt;
        }
        connection.Close();
    }
}

kmatyaszek · Accepted Answer · 2013-01-20 11:31:15Z

3

Replace

dataGrid1.DataContext = dt;

with

dataGrid1.ItemsSource = dt.DefaultView;

edited Jan 20, 2013 at 11:31

kmatyaszek

19.3k9 gold badges62 silver badges66 bronze badges

answered Jan 20, 2013 at 11:11

thomiel

3,07528 silver badges42 bronze badges

1 Comment

lurker Over a year ago

This should explain why the replacement is recommended.

akjoshi · Accepted Answer · 2012-11-16 06:10:05Z

1

Just call the method FillGrid() after InitializeComponents() in your code behind. I just did that and it runs perfectly.

edited Nov 16, 2012 at 6:10

akjoshi

15.8k13 gold badges107 silver badges122 bronze badges

answered Jul 26, 2011 at 0:19

Daniel-ito

191 bronze badge

1 Comment

user1034912 Over a year ago

details pleaseeeee

Guest28512 · Accepted Answer · 2021-08-16 12:41:39Z

1

I always use this code to display/fill data in my Datagrid:

SqlConnection con = new SqlConnection("your connection string");
    
private void LoadGrid()
    {
        SqlCommand cmd = new SqlCommand("Select * From XXX;", con);
        DataTable dt = new DataTable();
        con.Open();
        SqlDataAdapter sdr = new SqlDataAdapter(cmd);
        sdr.Fill(dt);
        dataGrid.ItemsSource = dt.DefaultView;
        con.Close();
    }

answered Aug 16, 2021 at 12:41

Guest28512

211 bronze badge

Collectives™ on Stack Overflow

Fill dataGrid from MySQL database in C# WPF

5 Answers 5

2 Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related