HOW TO GET NUMBER OF ROWS IN A TABLE IN MYSQL

F Scott Fitzgerald

Total Post:29

Points:203
Posted by  F Scott Fitzgerald
C# 
C#
 1114  View(s)
Ratings:
Rate this:

After sleepless night and run over the stackoverflow I could not find the method (function) that can resolve my probleme.

What I wrote is very harder for the server. Is there any more clever way to resolve this problem?

Here my code:

public static int GetIndexLong(string TblName)
{
    int rowsNbr = 0;
    using(MySqlConnection conn = new MySqlConnection(PublicVariables.cs))
    {
        using(MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + TblName, conn))
        {
            conn.Open();
            using (MySqlDataReader reader = cmd.ExecuteReader())
            {
                while (reader.Read())
                {
                    ++rowsNbr;
                }
            }
            return rowsNbr;
        }
    }
}

It does the job but I know it's not the good way.

Working with C# Express 2008 on .NET 4.0.

  1. Ida B Wells

    Post:30

    Points:210
    Re: How to get number of rows in a table in mysql

    Are you looking for count:

    SELECT COUNT(*) FROM TableName

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!