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

0 vote159 views1 answer
Query params sql insert python f string
SQL
2 votes148 views1 answer
Find all triggers in database
SQL
0 vote148 views1 answer
How to start my sql server on mac
SQL
4 votes171 views2 answers
Oracle unlock account
SQL
0 vote147 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote152 views1 answer
Pl sql turn off variable substitution
SQL
0 vote190 views1 answer
Liquibase update row
SQL
16 votes154 views4 answers
Ascending order mysql
SQL
9 votes164 views2 answers
Oracle all tables in schema
SQL
0 vote107 views1 answer
Plsql trigger insert update
SQL