Get Number of mysql connections if Connection are not cached

string  Qry=" FLUSH STATUS ;SHOW GLOBAL STATUS LIKE '%Max_used_connections%' ";
MysqlDataAdapter ad =new MysqlDataAdapter(Qry);
so fill that to dataset and u will get that.

If connection is cached u need to do work on thread cache and work on  that.