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

18 votes351 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
3 votes370 views3 answers
C# sql select
SQL
5 votes358 views1 answer
How to check nls format in oracle
SQL
1 vote335 views2 answers
Procedure pl/sql
SQL
1 vote379 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote393 views1 answer
Reset postgres table index to next max value
SQL
15 votes408 views4 answers
Create table if not exists sql
SQL
3 votes357 views1 answer
Select nextval from sequence sql
SQL
3 votes334 views4 answers
Show sql server database
SQL
1 vote349 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL