I was working on a project using my C# Class Generator and realized that I had no way to get a count of the number of records in the table. In the past I have used the DataAdapter class - easy, but not very efficient.
I ran accross a post on one of the discussion forums and decided to build a new function in my class generator appropriately named RecordCount. The function returns an 'int' with the number of records in the table.
m_dbConnection is the Connection string to your database
aRepresentative is the name of our table
Id is unique column used in our table
Using the C# Class Generator, the generated code is as follows:
public int RecordCount() // Get Count of Records
string countCmd = "SELECT Count(Id) AS Total FROM aRepresentative ";
SqlConnection m_SqlConnection = new SqlConnection(m_dbConnection);
SqlCommand m_SqlCommand = new SqlCommand(countCmd, m_SqlConnection);
// Open the Connection ----------------------------
recCount = (int)m_SqlCommand.ExecuteScalar();
} // end try
catch (Exception e)
throw new Exception("Error in RecordCount() -> " + e.ToString());
} // end Select