/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 vote149 views1 answer
Delete first row in sql
SQL
0 vote151 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote143 views1 answer
Truncate left characters mysql
SQL
0 vote174 views1 answer
Mysql equivalent decode oracle
SQL
0 vote147 views1 answer
Utiliser sql ligne de commande
SQL
1 vote155 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote150 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote151 views1 answer
Select all columns except one sql
SQL
1 vote161 views1 answer
Mysql not supported auth mode
SQL
0 vote143 views1 answer
Postgresql comandos basicos
SQL