binding MySQL database with ListBox in WPF

Question

I have a MySQL database containing of images and texts that want binding it to ListBox in WPF project; here is my code that have exception error, how can I fix that?

public DataTable GetTable(String query, String sortBy)
{
    String connString = "server=localhost;uid=root;pwd=root;database=database_clothes";
    connection = new MySqlConnection(connString);
    adapter = new MySqlDataAdapter(query, connection);
    DataTable dataTable = new DataTable();

    adapter.Fill(dataTable);
    dataTable.DefaultView.Sort = sortBy;
    return dataTable;
}

It says that you don't have database database_clothes on that server. Did you check that? — Chetan
– Chetan, Commented Sep 18, 2017 at 7:17

faraday · Accepted Answer · 2017-09-19 10:50:34Z

1

Just answering my question! the problem was not mysql authentication despite of error message, here was my problem in sql commands in xaml file where the table name "names" was not as mine:

        <ObjectDataProvider x:Key="NamesTable"
ObjectType="{x:Type local:DatabaseTable}"
MethodName="GetTable">
        <ObjectDataProvider.MethodParameters>
            <s:String>SELECT * FROM names</s:String>
            <s:String>Name</s:String>
        </ObjectDataProvider.MethodParameters>
    </ObjectDataProvider>

answered Sep 19, 2017 at 10:50

faraday

5310 bronze badges

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

Comments

mm8 · Accepted Answer · 2017-09-18 09:27:14Z

0

this exception said taht your connection is invalid. i think the database name is not correct. after resolve this problem , you should map your datatable to observablecollection then can binde observablecollection to your ListBox

here you can find good description

How to bind ObservableCollection with Listbox in WPF

edited Sep 18, 2017 at 9:27

mm8

170k10 gold badges70 silver badges102 bronze badges

answered Sep 18, 2017 at 7:56

Bahman Rashidi

1061 silver badge5 bronze badges

2 Comments

tabby Over a year ago

where is your link?

Bahman Rashidi Over a year ago

stackoverflow.com/questions/21128666/…

Collectives™ on Stack Overflow

binding MySQL database with ListBox in WPF

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related