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, Sep 18 '17 at 07:17

score 1 · Answer 1 · answered Sep 19 '17 at 10:50

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>

score 0 · Accepted Answer · edited Sep 18 '17 at 09:27

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 '17 at 09:27

mm8

163,881
10
57
88

answered Sep 18 '17 at 07:56

Bahman Rashidi

86
1
5

where is your link? – tabby Sep 18 '17 at 08:23
https://stackoverflow.com/questions/21128666/how-to-bind-observablecollection-with-listbox-in-wpf – Bahman Rashidi Sep 18 '17 at 09:38

binding MySQL database with ListBox in WPF

2 Answers2