/SQL/How to get all values in a table mysql in c#

How to get all values in a table mysql in c#

this.data_reader = command.ExecuteReader();
        if (this.data_reader.HasRows) {
            this.count = data_reader.FieldCount;
            while (this.data_reader.Read());           
            {
                for (var i = 0; i < count; i++)
                {
                    Debug.WriteLine(this.data_reader.GetValue(i));
                }
            }
           this.data_reader.Close();
        }

Source: stackoverflow.com

Similar codes

0 vote186 views1 answer
Oracle array
SQL
1 vote197 views1 answer
Mysql how to truncate table with foreign keys
SQL
13 votes248 views2 answers
Sqlite rename table
SQL
2 votes173 views1 answer
Postgresql update sequence next value
SQL
0 vote223 views1 answer
Plsql check for string in numeric
SQL
0 vote182 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
11 votes174 views1 answer
Oracle view ddl
SQL
0 vote183 views1 answer
With_for_update sqlalchemy
SQL
2 votes216 views1 answer
Mariadb select multiple rows into one column
SQL
1 vote188 views1 answer
Sqlite check if row exists
SQL