C# select Mysql

DataSet ds = new DataSet();
using (MySqlConnection con = new MySqlConnection(connectionstr))
{
    using (MySqlCommand cmd = con.CreateCommand())
    {
        con.Open();
        cmd.CommandText = "select * from mysql.user;";
        MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
        adapter.Fill(ds);
    }
}

Similar codes

4 votes246 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
20 votes247 views3 answers
How to open postgresql in mac
SQL
0 vote232 views2 answers
How to get json data mysql
SQL
2 votes238 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote234 views1 answer
Can't connect to postgresql mac os
SQL
39 votes246 views4 answers
Select duplicates in sql
SQL
1 vote221 views1 answer
Oracle add proxy
SQL
0 vote235 views1 answer
Mysql Like(searching in the string)
SQL
19 votes232 views6 answers
Sql server drop table if exists
SQL
-1 vote246 views1 answer
Sql show custom constraints
SQL