How can bind MySql database into a Datagrid (UWP)

Question

i established a basic connection to a MySql Database following this https://learn.microsoft.com/en-us/windows/uwp/data-access/mysql-databases

    public MainPage()
    {


        this.InitializeComponent();

        var dt = new DataTable();
        using (var con = new MySqlConnection(
            "User ID = root; Password = ****; Initial Catalog = ****; Server = localhost"))
        using (var cmd = new MySqlCommand("SELECT * FROM ****", con))
        {
            con.Open();
            dt.Load(cmd.ExecuteReader());
        }

        this.DataContext = dt;

    }

now im trying to show the database content into a datagrid and trying to find more related.

Mikael · Accepted Answer · 2021-03-29 00:57:41Z

1

Use a sql data adapter. edit: you can map columns if needed.

    using (con)
    {
        con.Open();
        using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
        {
            sda.Fill(dt);
        }
    }

edited Mar 29, 2021 at 0:57

answered Mar 28, 2021 at 20:05

Mikael

9921 gold badge15 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How can bind MySql database into a Datagrid (UWP)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related