public int GetCount(string ConnectionText,string TableName)
{
SqlConnecton conn = new SqlConnection(ConnectionText);
sqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM "+ TableName,conn);
conn.Open();
int myCount = comd.ExecuteNonQuery();
conn.Close();
return myCount;
}