How to read SQL Server COUNT from SqlDataReader in PHP?
Example 1
string sql = "SELECT COUNT(*) FROM [DB].[dbo].[myTable]";
SqlCommand cmd = new SqlComman(sql, connectionString);
SqlDataReader mySqlDataReader = cmd.ExecuteReader();
int count = mySqlDataReader.GetInt32(0); // Here is where I get the error.
Example 2
if (mySqlDataReader.Read()) {
count = mySqlDataReader.GetInt32(0);
}